Write SQL*Plus commands to do the following:
• Connect to the database 'OracleDB' with the user name 'SalesTracking' and password 'sales';
• Make sure that the Autocommit is off;
• Display the name of the current user;
• List the names of all tables in this schema;
• Display the structure of the table Branch;
• List the names of all sequences in this schema.
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q3: The following tables form part of a
Q4: The following tables form part of a
Q5: The relational schema shown below is part
Q6: A relational database contains details about journeys
Q7: The following tables form part of a
Q9: Assume that the following table is created
Q10: What is a sequence? Write an SQL
Q11: (a) What is a 'table' and what
Q12: (a) What is a named block
Q13: Assuming that a single-row form is
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents