Top "Sqlplus" questions

How to insert a string which contains an "&"

How can I write an insert statement which includes the & character? For example, if I wanted to insert "J&…

sql oracle escaping sqlplus

How to display table data more clearly in oracle sqlplus

I want to be able to display the resulting data from a select in a pretty way, not all columns …

database oracle sqlplus

How to kill a running SELECT statement

How can I stop a running SELECT statement by killing the session? The command is continuously giving me output based …

sql oracle select oracle10g sqlplus

How do I ignore ampersands in a SQL script running from SQL Plus?

I have a SQL script that creates a package with a comment containing an ampersand (&). When I run the …

sql oracle sqlplus

Oracle: Import CSV file

I've been searching for a while now but can't seem to find answers so here goes... I've got a CSV …

oracle csv import sqlplus sql-loader

Connect to Oracle DB using sqlplus

I am using below command in Unix environment to connect to Oracle database: sqlplus test/test@'(DESCRIPTION=(ADDRESS_LIST=(…

oracle unix sqlplus

When or Why to use a "SET DEFINE OFF" in Oracle Database

I'm watching a Script in Oracle and I see something I don't recognize REM INSERTING into database1."Users" SET DEFINE …

oracle sqlplus

PL/SQL ORA-01422: exact fetch returns more than requested number of rows

I get keep getting this error I can't figure out what is wrong. DECLARE * ERROR at line 1: ORA-01422: exact fetch …

oracle plsql oracle11g sqlplus

Oracle SqlPlus - saving output in a file but don't show on screen

Using SqlPlus for Oracle, how do I save the output of a query in a file but not show it …

oracle sqlplus

How to get the employees with their managers

This is what I want the output to look like: Employee Emp# Manager Mgr# BLAKE 7698 KING 7839 CLARK 7782 KING 7839 JONES 7566 KING 7839 …

sql oracle sqlplus