Top "Sqlplus" questions

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of …

oracle oracle11g sqlplus ora-12514 tnsping

How do I spool to a CSV formatted file using SQLPLUS?

I want to extract some queries to a CSV output format. Unfortunately, I can't use any fancy SQL client or …

sql oracle csv sqlplus

DBMS_OUTPUT.PUT_LINE not printing

When executing the following code, it just says the procedure is completed and doesn't print the infomation i want it …

plsql oracle10g sqlplus dbms-output

How to display databases in Oracle 11g using SQL*Plus

With help of this command show databases; I can see databases in MySQL. How to show the available databases in …

oracle oracle11g sqlplus

Escaping ampersand character in SQL string

I am trying to query a certain row by name in my sql database and it has an ampersand. I …

sql oracle escaping sqlplus

how to increase sqlplus column output length?

I have some queries to find out the ddl of some objects from a schema. The result columns I am …

sql oracle sqlplus column-width

Connect to sqlplus in a shell script and run SQL scripts

I have a .sql file, which is a bunch of oracle pl/sql commands and I want to create a …

bash shell sqlplus

Force index use in Oracle

I encountered this question in an interview and had no clue how to answer: There is a table which has …

sql oracle indexing sqlplus

sqlplus statement from command line

Is it possible to do something like this? $ sqlplus -s user/pass "select 1 from dual" or $ echo "select 1 from dual" | …

sql oracle sqlplus

How to output oracle sql result into a file in windows?

I tried select * from users save D:\test.sql create; But SQL plus gives me "no proper ended" How to …

sql oracle sqlplus