Top "Sqlplus" questions

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

How to select spool's filename from table in sqlplus

how could I select the name of my spool filename from a table in sqlplus? I have something like: SPOOL …

sql oracle sqlplus spool
Prevent output of SPOOL from being wrapped

I'm trying to generate all DDLs for objects in a Database using the SPOOL command in SQLPLUS: SET trimspool ON …

oracle sqlplus spool
Using impdp/expdp with RDS Oracle on AWS

I'm very new to Amazon web services, especially using their RDS system. I have set up an Oracle database (11.2) and …

amazon-web-services oracle11g sqlplus rds impdp
Spooling a query containing an XMLTYPE column using sqlplus

I have a query that concatenates (manually by ||) a handful of columns, one of which is an XMLTYPE field (calling …

oracle sqlplus spool
ORA-12541 TNS :no listener on 1 specific remote database, but not on others

Some context: I'm setting up an environment to run some Ruby code our Lead wrote to connect to some remote …

oracle oracle-sqldeveloper sqlplus tnsnames tns
How to undo ALTER TABLE using sqlplus (Oracle 10g Express)?

rollback; doesn't seem to undo alter table changes. Background: I'm generating some .sql scripts (based on parsed Hibernate scripts) which …

oracle10g sqlplus rollback alter
How to mask characters with X in a varchar2 field in Oracle SQL

I have a list of varchar records (column) varchar2(30) with names. How to mask characters inside the name with the …

sql oracle oracle11g sqlplus varchar2
Select top rows from a sqlplus query

I have a query select sum(pur.purchase_net_invoice_value), par.party_desc from purchase pur join party par …

sql database plsql sqlplus oracle-xe
Explanation of a BLOB and a CLOB

I am looking for a real good explanation of a BLOB and CLOB data. I am looking for the great …

sql oracle blob sqlplus clob
tnsping fails, but can connect to Oracle DB via sqlplus

I've installed the Oracle Client v. 11.2.0.1 on a Windows XP machine and set both the TNS_ADMIN and ORACLE_HOME …

oracle11g sqlplus oracleclient tnsnames tns