Top "Sqlplus" questions

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

SQL Plus change current directory

How does one change the current directory in SQL Plus under windows. I am trying to write a script with …

oracle sqlplus
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Please suggest a solution for solving this issue?? While giving the command: sqlplus /nolog the error that occurred: sqlplus: error …

linux oracle installation sqlplus oracleclient
ORA-12154: TNS:could not resolve the connect identifier specified (PLSQL Developer)

I need to use PLSQL Developer to access oracle databases. I get the following error when I try to connect …

oracle plsql sqlplus plsqldeveloper tnsnames
TNS Protocol adapter error while starting Oracle SQL*Plus

Whenever I try to login into SQL*Plus (11g Standar Edition Win 64) I get an error related to some connection …

oracle oracle11g sqlplus
SQLPLUS error:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

I downloaded SQLPLUS from Oracle: http://www.oracle.com/technetwork/topics/winx64soft-089540.html Basic Lite and SQL*Plus I …

oracle connect sqlplus
How do you execute SQL from within a bash script?

I have some SQL scripts that I'm trying to automate. In the past I have used SQL*Plus, and called …

sql oracle bash plsql sqlplus
Removing Locks in Oracle 10

I have an issue when trying to update a column value in sqlplus. It basically wont complete and just hangs. …

sql oracle sqlplus
How can I check the last time stats was run on Oracle without using OEM

I want to check the last time stats was run on my Oracle 10g server. I would normally do this …

oracle oracle10g sqlplus statistics
Remove Column Header into the Output Text file

I want to create a flat file (text file) of my query from Oracle SQL Developer. I have successfully created …

oracle oracle-sqldeveloper sqlplus spool columnheader
How to get Oracle create table statement in SQL*Plus

I have a table that exists in an Oracle database, but doesn't show on my list of tables in the …

sql oracle sqlplus