Searching for "SQL*Plus"

Q:

What are the basic SQL*Plus commands?

Answer

1) START- Used to run a SQL script.
2) ACCEPT- Accepts input from user.
3) GET- Gets the sql file from user to place in buffer.
4) LIST- Displays the last command executed.
5) RUN- Used to list and run the command in buffer
6) SHOW- Shows the environment settings. Example: SHOW PAGESIZE

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

Q:

What is SQL*Plus? Explain its features

Answer

SQL*plus allows SQL and PL/SQL scripts to interactively run in command line.

It allows three kinds of commands to run; SQL, PL/SQL and SQL * Plus commands. It’s most commonly used by DBA’s to interact with the oracle database.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle