Top "Sqlplus" questions

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

Oracle Sqlplus client on Mac

I want to install SqlPlus client on my Mac, which is 64-bit. Firstly, I installed sqlplus for 64-bit, but I …

macos oracle 32bit-64bit sqlplus
Display Dynamic EXECUTE Output Within pl/sql From sqlplus

How to get the dynamic select results of EXECUTE within PL/SQL from Oracle sqlplus? I'm writing a simple sqlplus …

oracle plsql sqlplus
what does the "2"mean in SQL*Plus?

I am new to Oracle. And I have come across a problem. Firstly,I want to check the privileges of …

oracle oracle10g oracle11g sqlplus
Oracle SQL: Transferring tables from one user to another

I created a new user called temp, with a password temp. I have another user called Scott that is identified …

oracle sqlplus user-profile copying
When I enter a dateadd or datediff code i get this error all the time "ORA-00904 "DATEADD" INVALID IDENTIFIER."

I have a university project and I have a patient table with admission and discharge date attributes. I need to …

sql oracle oracle11g sqlplus dateadd
Inserting national characters into an oracle NCHAR or NVARCHAR column does not work

When inserting strings in an oracle database, some national characters are replaced with question marks, even though they are inserted …

java oracle unicode sqlplus nvarchar
How to remove unnecessary line breaks in SQL Plus Spooling?

I am spooling a package from a database and this is what I get: CREATE OR REPLACE PACKAGE BODY "CPI"."…

sql database command-line sqlplus spool
How to disable old and new value option in output when I run PL/SQL program

I am new to pl/sql so this might be a silly question, I created a simple PL/SQL program: …

plsql sqlplus
SQL*Plus does not execute SQL scripts that SQL Developer does

I am facing a very annoying problem. I have written (in Notepad++) some SQL scripts. Now when I try to …

sql oracle oracle11g sqlplus oracle-sqldeveloper
SQLPlus dynamic spool filename

i have an Oracle db and i want to export data to a file.However filename, extension and separator will …

oracle sqlplus spool