Question: Oracle sql Change the setting of MY_FIRST_SEQ so that the minimum value that can be generated is -1000. A new table has been requested to
Oracle sql Change the setting of MY_FIRST_SEQ so that the minimum value that can be generated is -1000. A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns." emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009 Create a private synonym that enables you to reference the MY_FIRST_SEQ object as NUMGEN. Use a SELECT statement to view the CURRVAL of NUMGEN. Delete the NUMGEN synonym and MY_FIRST_SEEQ. Create a bitmap index on the CUSTOMERS table to speed up queries customers based on their state of residence. Verify that the index exist the index
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
