OraFAQ Forum: Server Administration » use of keyword for table names

Home » RDBMS Server » Server Administration » use of keyword for table names

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

use of keyword for table names [message #371178]

Wed, 13 September 2000 05:13

sunil gupta
Messages: 11
Registered: September 2000

Junior Member

why does oracle allows to create a table with keyword describe but not with desc

Report message to a moderator

Re: use of keyword for table names [message #371185 is a reply to message #371178]

Wed, 13 September 2000 08:16

Mahesh Pednekar
Messages: 28
Registered: August 2000

Junior Member

Because describe is not a sql reserve word, it is a sql*plus command to describe a table but desc is a reserved word of sql for ORDER BY command (ie descending)
e.g :
select * from emp order by ename desc;

Regards -) Mahesh P.

Report message to a moderator

regarding comments [message #371211 is a reply to message #371178]

Sun, 17 September 2000 10:20

ramesh
Messages: 123
Registered: August 2000

Senior Member

respected sir
i have a doubt abt
how to make comments (description abt column) for a column while creating table
i will be very glad if u solve my prob
thanking u
rams

Report message to a moderator

Re: regarding comments [message #371212 is a reply to message #371178]

Mon, 18 September 2000 03:29

sunil gupta
Messages: 11
Registered: September 2000

Junior Member

u can write like

create table a(b number /*number field*/);

Report message to a moderator

Previous Topic:	Cannot run Export from Enterprise Manager
Next Topic:	Reg Oracle Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 21:17:29 CDT 2024