how to run two sql commands in oracle database

Question

there are two tables 1. employees and 2. departments

when I try to describe the two tables with the following code

desc employees;
desc departments;

I am getting the following error

Object to be described could not be found.

How are you executing those commands? What client are you using? What is the exact error message? — Nick Krasnov
– Nick Krasnov, Commented Dec 20, 2013 at 5:43
@danihp when I use it individually, like desc employees - it is describing the table. Why it is not running for desc employees; desc departments — Mrk
– Mrk, Commented Dec 20, 2013 at 5:54
@NicholasKrasnov I am using Oracle 10g database express edition — Mrk
– Mrk, Commented Dec 20, 2013 at 5:55
I say that describe is not an SQL Standard Command neither a Oracle SQL Command it is a SQL*PLUS tool command. This is not a solution, only a remark. In question title you talk about sql commands but samples are not. See @APC answer. — dani herrera
– dani herrera, Commented Dec 20, 2013 at 8:17

Maheswaran Ravisankar · Accepted Answer · 2013-12-20 06:35:51Z

1

you can never run two sqlplus commands at a time, you can queue your commands in your script, and execute the script. working principle is like this, when it sees the first word , if it realises as a proper keyword, it blindly try to execute what ever next to it.!

answered Dec 20, 2013 at 6:35

Maheswaran Ravisankar

17.9k6 gold badges50 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

APC · Accepted Answer · 2013-12-20 06:26:50Z

1

DESCRIBE is a SQL*Plus command. We can only run it in a SQL*Plus client, or an emulator such as PL/SQL Developer's command window.

In SQL*Plus we get this error message when we attempt to describe an object which doesn't exist:

SQL> desc t34
ERROR:
ORA-04043: object t34 does not exist


SQL>

Whereas in SQL Developer worksheets we get this

desc t34
ERROR:                           
-------------------------------- 
ERROR: object T34 does not exist

So you must be using a different client.

In the end it does not matter, all the messages mean the same thing: the object doesn't exist. The most likely explanation is that you're connected as a user different from the owner of the tables.

edited Dec 20, 2013 at 6:26

answered Dec 20, 2013 at 5:37

APC

147k20 gold badges180 silver badges289 bronze badges

1 Comment

Mrk Over a year ago

I am using oracle 10g database express edition. it's it an SQL plus client ??

Collectives™ on Stack Overflow

how to run two sql commands in oracle database

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related