Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW. I did with: SELECT * FROM (SELECT * from KimTay) WHERE ROWNUM <= 11; and with: SELECT * FROM (SELECT TABLE_NAME FROM ALL_TABLES ORDER BY TABLE_NAME ) WHERE ROWNUM <= 10; and with: SELECT * FROM SYSTABLES but nothing worked and some of them gave me an error as (ERROR 1248 (42000) at line 1: Every derived table must have its own alias) and I need answers for these too: Task 11: List all the columns contained within the system catalog, but only display the first 11 records that are in the KimTay TABLE_SCHEMA. Task 12: List all the views contained within the system catalog, but only display the first 12 records.
!I am doing all this from cengage!
Task 10: List all the tables contained within the system catalog, but only display the first 10 records with a TABLE_TYPE of SYSTEM VIEW.
Task 12: List all the views contained within the system catalog, but only display the first 12 records.
Task 13: Write the command to display only tables within the system catalog that have the KimTay TABLE_SCHEMA and are of the type BASE TABLE. Display only the following columns: TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE.
Task 14: Create an index named ITEM_INDEX1 on the ITEM_ID column in the INVOICE_LINE table.
Task 15: Create an index named ITEM_INDEX2 on the CATEGORY column in the ITEM table.
Task 16: Create an index named ITEM_INDEX3 on the CATEGORY and LOCATION columns in the ITEM table.
Task 17: Create an index named ITEM_INDEX4 on the CATEGORY and LOCATION columns in the ITEM table. List categories in descending order.
Task 18: Delete the index named ITEM_INDEX3.
Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns.
Task 20: List every column in the ITEM table and its associated data type.
Task 21: Alter the INVOICE_LINE table by adding the INVOICE_NUM column as a foreign key referencing the INVOICE_NUM column in the INVOICES table.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
