Q
Problem solve Get help with specific problems with your technologies, process and projects.

Where session-specific SQL is executed

Can you tell me where the session-specific SQL statements and other SQL statements are executed? For example:
set autotrace on; echo on;

select * from emp;
Which process is responsible for executing both of the statements?

SET AUTOTRACE ON and SET ECHO ON are SQL*Plus commands. They are not executed in the database. They only tell the SQL*Plus application how to do certain things. This is entirely handled within SQL*Plus. So your SQL*Plus executable is responsible for these statements.

A command like "SELECT * FROM EMP;" is also handled by SQL*Plus. But SQL*Plus recognizes this as a SQL statement. So SQL*Plus passes the SQL statement to the database. In return, SQL*Plus gets data back and shows the data on the screen.

For More Information

Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close