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
5 answers

simple SQLPLUS issue.. my answer is wrong

I need to Calculate the total number of days spent on resolving tickets for the month of January 2012 for each tech personnel and List them in an ascending order. I tried to rewrite the question make it more clear at first so here Find all the tech…
user659745
  • 25
  • 2
  • 8
0
votes
1 answer

Cannot Connect with TOAD but Can with Other Tools/Apps

I am able to connect to an Oracle database using several tools, but am unable to connect using Toad for Oracle 8.5.3 (though before a login/logout to Windows I was able to). I am not using TNSNAMES.ORA to connect. I have two Oracle…
Kit
  • 20,354
  • 4
  • 60
  • 103
0
votes
4 answers

SQL programming help.... using count and max ..etc

I have a series of tables: TECH PERSONNEL (pplSoft, fname, lname, pittID, expertise, office phone) where fname is first name, and lname is last name. USERS (pplSoft, fname, lname, pittID, office phone) CATEGORIES (category id, category,…
CDev33
  • 1
  • 1
  • 2
0
votes
1 answer

Ksh function to query Oracle with return values

Some time ago I wrote a small routine to run some quick n' dirty queries (and with that I mean it is not used for large queries) against an Oracle DB, but also wanted to do it a bit easier to parse errors. Follows: # Executes the query # # Will…
filippo
  • 5,583
  • 13
  • 50
  • 72
0
votes
1 answer

can not run sqlplus commands in ssh connection

I connected to VM with ssh connection and I want to run sqlplus command, but when I run sqlplus / as sysdba (to example) I get sqlplus: command not found. I have on the VM oracle DB and I've created a data base.
zeevblu
  • 1,059
  • 2
  • 11
  • 26
0
votes
1 answer

SQLPlus 's weird reaction during DML statements execution

Today i was executing DML statements from sql file in sqlplus, oracle 10.2, i found something weird which is actually a question "Enter value for hamburger:". See attached and ending of question "Enter value for XXX" kept change with intervals. i…
Rehman
  • 3,908
  • 6
  • 28
  • 29
0
votes
4 answers

SQL - Oracle 11g - PL/SQL - Trigger compilation error

I'm having trouble running this piece of code. It says that the trigger was created with compilation errors but does not explain what's wrong and does not give any output. Below is the code and the error I'm given. I'm on Oracle 11g R1 and am using…
Brian
  • 1,951
  • 16
  • 56
  • 101
0
votes
3 answers

Oracle EX and SQL Plus: How to recover dump file?

I have .dmp and .log files. I need to recover the database schema and data using SQLPlus or some feature of EX. How do I do that? I've tried the RECOVER command and impdp. No luck, or I'm doing something wrong.
Doug
0
votes
3 answers

want an optimal solution for inserting more than one data in a single column of a single row

DROP TABLE District_Info; CREATE TABLE District_Info( Dname VARCHAR2(20) primary key, Boundary_dist VARCHAR2(20) ); for this code, for each Dname there are more than one Boundary_dist. it would be better if i could use an array of varchar2(20) and…
Umme Rumman Usha
  • 11
  • 5
0
votes
1 answer

What does SHOW ALL show?

What is the technical name for the variables shown by the SHOW ALL command in SQL*Plus? I want to know because the term "variable" is quite overloaded and I'd like to be specific. Typing "help show" says : SHOW ---- Shows the value of a SQL*Plus…
Jay Sullivan
  • 17,332
  • 11
  • 62
  • 86
0
votes
1 answer

How to return error code in case plsql compilation error from sqlplus

I use "WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK;" in my plsql scripts to use them in shell scripts. This works fine: echo exit | sqlplus user/pass@XE @normal.sql && echo "boo" Executes the script and prints "boo" This works fine too: echo exit…
Ivan Sopov
  • 2,300
  • 4
  • 21
  • 39
0
votes
3 answers

RMAN not starting

When I try to start RMAN I get this error: SQL> rman target=/ SP2-0734: unknown command beginning "rman targe..." - rest of line ignored. SQL> What am I missing?
randy white
  • 101
  • 1
  • 3
  • 8
0
votes
1 answer

Insert formatted date function using Oracle SQL*PLus?

Am a Oracle PL/SQL newbie. Basically, I have a table created as follows: CREATE TABLE MYTABLE ( ID VARCHAR2(3 CHAR) NOT NULL PRIMARY KEY, LAST_UPDATE DATE ); Am trying to write a script which will run through SQL*Plus…
PacificNW_Lover
  • 4,746
  • 31
  • 90
  • 144
0
votes
1 answer

Starting up a database instance fails when not connected to my home network

Every time I'm trying start a database instance and I'm not connected to my home wireless network or wireless is disabled, this is what happens: [mati@Mati-PC ~]$ sqlplus sys as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 17…
Mati
  • 1,378
  • 15
  • 20
0
votes
1 answer

Can I undo a rollback in sqlplus?

I somehow thought rollback means undo the last action. This is what I did: SQL> update owns 2 set DRIVER_ID=99999999 3 ^[[A^Z; 4 rows updated. SQL> select * from owns; DRIVER_ID LICENSE -------------------- ---------- 99999999 …
Caffeinated
  • 11,982
  • 40
  • 122
  • 216
1 2 3
…
99
100