Top "Sqlplus" questions

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

Clear the heading in Oracle spool

I have spooled a file before running the below command and got the output like this, I have set heading …

Read More
oracle sqlplus spool
Sqlplus oracle : How can I run sql command on bash in 1 line?

Can I convert this into 1 command line on bash in sqlplus? cause i want to automate it. sqlplus / as sysdba …

Read More
oracle sqlplus
Problem running oracle script from command line using sqlplus

I'm having a problem trying to run my sql script into oracle using sqlplus. The script just populates some dummy …

Read More
sql oracle sqlplus
Show the structure of the table in SQL

Can someone explain things a little better to me? How do I show the structure of a table? I run …

Read More
sql sqlplus
Displaying the constraints in a table

Hello I am trying to display the constraints in one of my tables but for some reason I get the …

Read More
sql oracle constraints sqlplus
How to download and setup sqlplus for running sql commands?

I am sorry, for bugging you all with a very silly question probably, but I just started learning data base …

Read More
oracle sqlplus instantclient
ORA-12543: TNS:destination host unreachable but telnet and tnsping works

Last days i stay face to face with a strange oracle problem. I have defined database in tnsnames.ora. Oracle …

Read More
oracle sqlplus telnet tnsnames
Max column width in Oracle spool to file

I have a script like this: SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET TERMOUT …

Read More
oracle sqlplus oracle-xml-db-repository
insert a multiline string in Oracle with sqlplus

I have a SQL script that will insert a long string into a table. The string contains a new line (…

Read More
sql oracle newline sqlplus
How to see a list of all the indexes (including implicit ones) in SQL*Plus?

Is there some way to get a list of all the indexes on a particular table using SQL*Plus? I …

Read More
sql indexing sqlplus