Top "Sqlplus" questions

how to retrieve records which occurred more than twice in oracle?

I have this table create table student ( stu_id int, s_name nvarchar(max), s_subject nvarchar(max), ) and this …

sql oracle sqlplus

scott account locked in SQL Plus

When I am trying to logging to Oracle Sql plus by entering 'scott' as username and 'tiger' as password, it …

oracle11g sqlplus

How to prettify the output coming from the SELECT query in command prompt?

I ran the simple select query in the command prompt,but the output rows are not coming in a single …

oracle sqlplus

executing a .sql file in sql plus terminal

I have written couple of sql scripts in a text file and saved them with a .sql extension. I want …

sqlplus sql-scripts

SqlPlus SP2-0734: Error

I am new to using SqlPlus but not new to using SQL, and I get the following error after writing …

sql oracle unix sqlplus

Maximum length of command line argument that can be passed to SQL*Plus?

I am calling SQL*Plus from Linux C Shell: sqlplus username/password @file.sql var1 var2 var3 If I pass …

linux command-line-arguments sqlplus csh

Remove last character from string in sql plus

I'm trying to remove the last character from a column output in sql plus. The length of the column entries …

sql oracle sqlplus

Ugly formatting in SQL*Plus

It is really annoying that when I run a select command in SQL*Plus such as: SELECT * FROM books; The …

sql oracle plsql oracle10g sqlplus

Sqlplus login error when using bash variables: SP2-0306: Invalid option

I have a bash script that connects to an oracle 10g database. In a first step it takes some variables …

oracle bash sqlplus ora-01017

How do I display the full content of LOB column in Oracle SQL*Plus?

When I try to display the contents of a LOB (large object) column in SQL*Plus, it is truncated. How …

oracle blob sqlplus clob lob