Top "Sqlplus" questions

How can I see the SQL execution plan in Oracle?

I'm learning about database indexes right now, and I'm trying to understand the efficiency of using them. I'd like to …

oracle sqlplus sql-execution-plan

Adding a newline in a spool file

Is there a way to add a newline in an sql spool file? I need the file to be structured …

oracle sqlplus spool

Webrick is very slow to respond. How to speed it up?

I have a Rails application that I'm running on my server. When I go to a remote desktop and attempt …

ruby-on-rails oracle sqlplus webrick

suppressing messages while running sql queries in a script

I am trying to write a simple query-script that gets me cnt of rows in a table. However I am …

sql oracle shell scripting sqlplus

Getting ORA-01033: ORACLE initialization or shutdown in progress

Yesterday I installed Oracle 12c Enterprise edition on my laptop. When I tried to connect to DB via SQLPLUS i …

sqlplus oracle12c

blanks lines in between data rows show up when using SPOOL in SQLPlus

I'm trying to spool a large query in sqlplus but for some reason, I see 2 blank lines every 558 rows to …

oracle sqlplus

sqlplus - using a bind variable in "IN" clause

I am setting a bind variable in a PL/SQL block, and I'm trying to use it in another query's …

oracle oracle10g sqlplus ora-01722 bind-variables

arrow keys are not functional in sqlplus

I find that the arrow keys don't work on the sqlplus console. For example if I press left arrow key, …

keyboard sqlplus key

DBMS_OUTPUT.PUT_LINE not printing anything

When executing the following code, it just says the procedure is completed and doesn't print the infomation . BEGIN dbms_output.…

plsql oracle10g sqlplus dbms-output

In SQL*Plus, how do I change the prompt to show the connected user and database?

To show, for example.... USER@SID > I thought this was potentially helpful to a few people so I'm going …

oracle sqlplus