Prior to the adoption of sql as a standard

Assignment Help PL-SQL Programming
Reference no: EM13168586

Prior to the adoption of SQL as a standard by the American National Standards Institute (ANSI), each database management system (DBMS) had its own unique command language and syntax. SQL was adopted as an ANSI standard in 1986. The International Standards Organization (ISO) adopted it in 1987. This standard enables database portability.

Most commercial database vendors support the ANSI standard. However, most of these vendors also extend the standard with the addition of proprietary features. The Oracle version of SQL has differences from the ANSI standard version. For example, Oracle does not support either the full OUTER JOIN or the NATURAL JOIN of ANSI SQL.

When you have a choice, the vendor specific proprietary solution may offer better performance or convenience. On the other hand, the proprietary feature also limits or eliminates portability.

Think about the strengths and weaknesses of both the standard ANSI and proprietary Oracle approach to SQL. In particular, think about the different ways ANSI and Oracle support joins.

With these thoughts in mind:

Consider a situation where you would use a join to retrieve data from two tables in an Oracle database, such as the stock_count for an oil filter from the product table and the vendor for that oil filter from the vendor table. Would you prefer to use ANSI standard SQL or the proprietary Oracle SQL? What factors influenced your decision? Describe a situation where you would consider using the other option.

Reference no: EM13168586

Questions Cloud

Determine the number of grams of sodium acetate : Determine the number of grams of sodium acetate and the amounts in mLs of 6.00M acetic acid that you would need to make 50.00mL of a sodium acetate/acetic acid buffer solution at the pH equal to 5.00 in order to make a final concentration of 0.05M..
Redesign the grading program as an object-oriented design : redesign the grading program as an object-oriented design. We will start with a simple Student class. The student will have a name, an id (as a String) and a set of grades (as doubles)
Forest point construction at forest point construction : Forest Point Construction At Forest Point Construction, your boss says that he can estimate the total project time based on his personal experience. You are trying to convince him that he should use project management techniques to handle a comple..
Write a test program that obtains from the user : Write a test program that obtains from the user the items to store in two sets A and B, and displays the union A u B, the inter- section A n B, and the dierence A \ B. The data type of the items is your choice. ( you can only store objects.)
Prior to the adoption of sql as a standard : Prior to the adoption of SQL as a standard by the American National Standards Institute (ANSI), each database management system (DBMS) had its own unique command language and syntax. SQL was adopted as an ANSI standard in 1986. The International S..
Development of sacred music in medieval christianity : Which name or term is best associated with the development of sacred  music in medieval Christianity?
What is the percent dissociation the molecular acid : A 1 M solution of acetic acid is generated and a pH of 4.74 is measured. What is the percent dissociation
Long-run performance of the marketing system : The philosophy of ________ holds that a company’s marketing should support the best long-run  performance of the marketing system.
Symbolic-interaction approach to sexuality : If you were teaching a class about the symbolic-interaction approach to sexuality, on which of the following topics would you likely focus?

Reviews

Write a Review

 

PL-SQL Programming Questions & Answers

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Stored procedure named spinsertcategory

Write a script that creates and calls a stored procedure named spInsertCategory. First, code a statement that creates a procedure that adds a new row to the Categories table. To do that

  Display the customerid from the orders table

Display the CustomerID from the Orders table and the sum of the associated ItemPrice multiplied by Quantity using Gross Sales (with a space) as the column name from the OrderItems table.

  Draw an entity-relationship diagram

Draw an Entity-Relationship Diagram (ERD) for the data storage requirements of a business described in the case study and Data Model Transformation.

  Write a select statement that returns these columns

Write a SELECT statement that returns these columns from the Products table: The date_added column A column that uses the CAST function to return the date_added column with its date only (year, month, and day)

  Write statement which creates table named part

Write the statement which creates table named Part, with Id field as an int idendity PK, a SupplierId int field, a Description string field of size 25, a Count int field, a Class string field

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Write a pl-sql block

Write a PL/SQ block - Select the average salary of all employees in department number 20.

  Write sql commands to implement profile

Write SQL commands which would implement this profile. Next, write query that would list profile, profile resource name, and limit value for the new profile.

  Create a pl-sql block using the hr schema

Create a PL/SQL block to achieve the following using the HR schema and select the name, salary, and department of the employee with the maximum salary.

  How to select the primary key

How to select the primary key from the candidate keys? How do foreign keys relate to candidate keys? provide examples from either your workplace or class assignments

  Pretend that you are on the boards

Pretend that you are on the boards of the American National Standards Institute (ANSI) and the International Organization for Standards (ISO), two of the organizations who standardized SQL

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd