Essay
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
• Connect to the database 'OracleDB' wit...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q7: The relational schema shown below is part
Q8: (a)SQL*Plus environment variables are set to
Q9: (a) What is a 'table' and what
Q10: Oracle database consists of logical and physical
Q11: A relational database contains details about journeys
Q13: (a) What is a SQL*Plus script? Why
Q14: The following tables form part of a
Q15: State the three primary uses of Oracle
Q16: The following tables form part of a
Q17: (a) What is a named block