Question 1: Modify the select statement in this section to display the hire_date column in the format: January 10, 2012.
Question 1:
Modify the select statement in this section to display the hire_date column in the format: January 10, 2012.
(7-3) Question 2:
Add a new row to a copy of the employees table, sec0703_employees. Set the hire date to show that the person was hired at 10:00 AM.
(7-6) Question 3:
assist me with a new sequence named seq0706_my_stuff. Set the beginning value to 100.
(7-7) Question 4:
Determine the current value of the sequence seq_sec0707. Then use its next three values to add new rows to the sec0707_sequence table. This table has only one column. It holds the value of the sequence number.
(7-9) Question 5:
Build an index on a copy of the departments table, sec0709_departments. Index the department_name field.
(7-12) Question 6:
Find information about the datatypes of all the columns of the l_foods table.
(7-14) Question 7:
Find out what indexes there are on the l_departments table.
(7-16) Question 8:
Find all the tables in the Oracle Data Dictionary about views.
(7-17) Question 9:
Find the meanings of all the columns of the user_tables table.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps