Stack Overflow
Stack Overflow

Questions tagged [sqlplus]

SQL*Plus is a command-line interface for the Oracle RDBMS product. SQL*Plus questions should probably be also tagged with oracle.

SQL*Plus is a command-line interface for the Oracle RDBMS product. SQL*Plus can be installed as part of the Oracle database product, or as a separate client, as well as as an Instant Client.

SQL*Plus questions should probably be also tagged with .

While SQL commands can be run through SQL*Plus, the tag should be used for questions that relate specifically to the SQL*Plus tool (e.g., connection or formatting issues) and not for SQL statements where the use of SQL*Plus is incidental.

When asking questions regarding SQL*Plus, it is advisable to state the version of the client as well as the database version.

Useful links:

3440 questions
0
votes
1 answer

What is the proper syntax for stored procedures in SQLPlus?

What's the proper syntax for writing stored procedures in sqlplus? The internet is surprisingly unhelpful on this point since SQL tutorials don't seem to specify their environment, or the example they give is a little confusing. I think the simplest…
buggritall
  • 151
  • 2
  • 6
0
votes
1 answer

I passed an argument to a sqlplus statement from bash, but the argument is taking all the script after as argument. How can I avoid this problem?

I have this kind of bash script $sqlplusconn is the connection to my oracle instance with sqlplus $foo is a number $sqlplusconn << EOF BEGIN @bar.sql $foo @foo.sql $foo COMMIT; EXCEPTION WHEN OTHERS THEN ROLLBACK; END; [... other…
Mikkel
  • 1
  • 2
0
votes
0 answers

How to Get SQLPLUS command output as flag instead of huge string in c# Process

I am running sqlplus command in c# by creating Process. Before running oracle script, I want to make sure if sqlplus is installed and working on system, so I am executing below code. string DBConnection = $"sqlplus…
Keval Patel
  • 161
  • 1
  • 15
0
votes
0 answers

Backspace not working in SQL*Plus through Mobaxterm terminal

when using oracleSQL on SQLplus commandline through Mobaxterm terminal, backspace isn't working. I tried stty erase but that doesn't seem to do anything currently using shift+backspace and hate the whole process. Any fixes??
Bishnu P
  • 1
0
votes
0 answers

Batch File SQL Loader DB Reset

Trying to simplify the process of creating batch files. I have been tasked with Oracle SQL DB Resets. The project currently uses batch files (.bat) to load table data (.txt) through SQL Loader. So Data (.txt) will be placed in a DIR and I have to…
UntiedMy Mind
  • 19
  • 2
0
votes
2 answers

sqlplus - command line select statement doesn't use login.sql settings

I have an sh script containing this: sqlplus -S $JDBC_URL <
Sridhar Sarnobat
  • 25,183
  • 12
  • 93
  • 106
0
votes
0 answers

Oracle plsql use of colsep produces different results than a concat

When I run this query: set heading off; set feedback off; set linesize 10000; set newpage NONE; select id||'|'||template||'|'||CREATED_DATE from SREAPP.ESSLOG_ERR_MESG_TEMPLATES; exit; I get what I need - pipe delimited records: ± |FSA-887 ↑2…
Christian Bongiorno
  • 5,150
  • 3
  • 38
  • 76
0
votes
0 answers

Getting SQL query output "kpceinit:enter" when using SQL plus in Unix script to fire SQL query to Oracle 19c

I am stuck on a random issue where I am getting SQL query output as "kpceinit:enter" The SQL query can be as simple as "select sysdate from dual" or when I am running any stored procedure. This error is randomly coming on any random query or stored…
Pradeep
  • 1
  • 2
0
votes
0 answers

Connection takes over 1 min while sqlplus to the database

while us sqlplus to connect the database,it always takes about 1 mins. I used the command strace -T -t -0 /tmp/s.out sqlplus user/pwd@dbname" ,and find it takes 40s here read(13, "\0\10\0\0\v\0\0\0", 8208) = 8 the connection should be connected…
Steve Eilu
  • 1
0
votes
1 answer

SQLPLUS: TNS-style vs regular connection parameters

I'm wondering what the difference could be between connecting with SQLPlus using a "TNS-style" entry…
ValeryC
  • 477
  • 3
  • 17
0
votes
0 answers

How to Preventing create table/view on my table/view that i granted to another schema/user> (ORALCE/SQLPLUS)

I have following scenario, is this possible to oe schema to select only, but not create table/view from hr table? table "Employees" created and have data hr schema granted read access to oe schema --> grant read on employees to oe; connected to oe…
Thangamani Eraniyan
  • 83
  • 3
0
votes
1 answer

Oracle db pass column as object to function

Is it possible to pass the column of the current row as an object like variable so i can extract some informations from that in a function? The function can be inside a package For example Select myfunction(column1) from dual; And then in the…
Moribundus
  • 39
  • 9
0
votes
0 answers

How to left justify the output of each column in SQL?

When I run the query above, I get: As you can see the output for MENU_ID is left justified while the output for all other columns are right justified. How can I left justify the output for all columns? By the way, I am using Oracle SQLPLUS.
Justin Chan
  • 47
  • 8
0
votes
0 answers

Forking a command series as a subprocess doesn't seem to work

I am trying to extract some data from a DB and monitor it's progress, since the tool that pulls the data doesn't appear to have a mechanism for doing so. So, I fork the command chain and then continue to count the lines of the output file until it…
Christian Bongiorno
  • 5,150
  • 3
  • 38
  • 76
0
votes
0 answers

Cannot connect ORACLE ORA-12514: TNS:listener does not currently know of service requested in connect descriptor in XAMPP

I have an SQL Plus Instance 19.3 which is connected through OCI8 to my php webserver in xampp, previously I had this all working where the webpage would display the content of the database, having come back to my computer after a holiday, and edited…
Xray25
  • 115
  • 13
1 2 3
…
99
100