Reference no: EM13165138
Test the database design by running the following queries on one of the tables. You must submit the returned results for each query.
You can use my table as an example. My table consists of this:
CUSTOMER: First name,Last Name, Address, Home phone, Cell phone and email address.
( just give me examples or syntax of how to query this table? you can use my table or use examples, which ever you like. just want the syntax.)
query specifying specific columns
query using a column alias
query using the concatenation operator
query using a literal character string
query eliminating duplicate rows
query using the where clause and a comparison operators
query using the BETWEEN operator
query using the IN(LIST) operator
query using the LIKE operator
query using the IS NULL operator
query using the AND operator
query using the OR operator
query using the NOT operator
query using the ORDER BY clause ascending or descending
query where output is sorted by column alias
query that is sorted by multiple columns
query involving an equijoin
query involving an outer join
query involving a self join
query involving the NVL function
query involving the DECODE function
query involving the SUBSTR function
query involving the INSTR function
query involving the UPPER function
query involving the LOWER function
query involving the LPAD function
query involving the RPAD function
query involving the MONTHS_BETWEEN function
query involving the HAVING clause
query involving the Group by clause
query involving the count function