Top "Sqlplus" questions

SQL*Plus is a command-line interface for the Oracle RDBMS product.

How to echo text during SQL script execution in SQLPLUS

I have a batch file which runs a SQL script in sqlplus and sends the output to a log file: …

sql oracle11g sqlplus
How can I issue a single command from the command line through sql plus?

Using SQL Plus, you can run a script with the "@" operator from the command line, as in: c:\>sqlplus …

oracle command-line sqlplus
sqlplus how to find details of the currently connected database session

I have very recently started to work on oracle databases. Generally I have many sqlplus windows open to different oracle …

oracle sqlplus
executing a function in sql plus

I created a function in oracle that inserts records in specific tables and return an output according to what occurs …

oracle function sqlplus
How to View Oracle Stored Procedure using SQLPlus?

How can I view the code of a stored procedure using sqlplus for Oracle 10g? When I type in: desc …

oracle stored-procedures oracle10g sqlplus
How can I kill all sessions connecting to my oracle database?

I need to quickly (and forcibly) kill off all external sessions connecting to my oracle database without the supervision of …

oracle session sqlplus kill database-administration
Oracle query execution time

I would like to get the query execution time in Oracle. I don't want the time Oracle needs to print …

oracle sqlplus execution
CLEAR SCREEN - Oracle SQL Developer shortcut?

With the aim of reducing mouse activity I was wondering if there was such a command shortcut (eg cls or …

oracle sqlplus oracle-sqldeveloper
How do I format my oracle queries so the columns don't wrap?

I've tried this, but it doesn't work: col * format a20000 Do I really have to list every column specifically? That …

oracle sqlplus
How do I resolve this "ORA-01109: database not open" error?

I'm trying to create my own database using SQLPlus. So first I log into it as admin: sqlplus sys/sys_…

oracle sqlplus database-administration