I just need the queries. create Table Erik(p_id number primary key); Create tabl
ID: 3931327 • Letter: I
Question
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.
Explanation / Answer
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