I just need the queries create Table Erikpid number primary

I just need the queries.

create Table Erik(p_id number primary key);

Create table

Erik_Morataya

(

Id_number NOT NULL. Unique,

Lastname varchar2(20) NOT NULL,

Firstsname varchar2(20),

Gender char(10),

DOB date,

PRIMARY KEY(Id),

Foreign Key (Id) REFERENCES Erik(P_Id)

Check (Id>0)

);

Use the UPDATE command to update multiple values in the table created in the above database. Use the SELECT * FROM your_table_name; command to display the content of the table (make sure to substitute your_table_name with the actual name of your table).

Use the DELETE command to delete one specific row from the table created in the above database. Use the SELECT * FROM your_table_name; command to display the content of the table (make sure to substitute your_table_name with the actual name of your table).

Use the COMMIT statement to save changes in the table created in the above database. Use the SELECT * FROM your_table_name; command to display the content of the table (make sure to substitute your_table_name with the actual name of your table).

Use the ROLLBACK command to undo changes in the table created in the above database. What happened? Why? Use the SELECT * FROM your_table_name; command to display the content of the table (make sure to substitute your_table_name with the actual name of your table).

Use the DROP TABLE command to drop the table created in the above database.

Solution

1)Use the UPDATE command to update multiple values in the table created in the above database.

Ans:UPDATE Erik_Morataya SET Lastname varchar2=\'Schmidt\', Firstsname=\'Alfred\',Gender=\'M,DOB=\'12/12/1995\';

2)Use the SELECT * FROM your_table_name

Ans:

SELECT * FROM NEW_TABLE_NAME;

3)Use the DELETE command to delete one specific row from the table created in the above database. Use the SELECT * FROM your_table_name;

DELETE FROM NEW_TABLE_NAME where id=1234;

SELECT * FROM NEW_TABLE_NAME;

4)COMMIT;

SELECT * FROM NEW_TABLE_NAME;

5)ROLLBACK;

(The ROLLBACK command is the transactional command used to undo transactions that have not already been saved to the database.)Hence table name will not be changed it remains as \"NEW_TABLE_NAME\".

6) SELECT * FROM NEW_TABLE_NAME;

7) DROP TABLE NEW_TABLE_NAME;

====================================================================================

Comment about the work