OraFAQ Forum: Client Tools » description keyword

Home » Other » Client Tools » description keyword

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

description keyword [message #615517]

Thu, 05 June 2014 01:29

hahaie
Messages: 194
Registered: May 2014

Senior Member

What is DESCRIPTION keyword in plsql?

Report message to a moderator

Re: description keyword [message #615518 is a reply to message #615517]

Thu, 05 June 2014 01:39

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

DESCRIPTION? Nothing, as far as I know.

In SQL*Plus, DESC (not DESCRIPTION) describes an object (for example, if you have a table whose name is DEPT, then "DESC DEPT" describes that table, i.e. lists its columns and data types).

Report message to a moderator

Re: description keyword [message #615519 is a reply to message #615518]

Thu, 05 June 2014 02:05

hahaie
Messages: 194
Registered: May 2014

Senior Member

So what is it?see attachment

Attachment: description.JPG
(Size: 14.07KB, Downloaded 1786 times)

Report message to a moderator

Re: description keyword [message #615520 is a reply to message #615518]

Thu, 05 June 2014 02:06

Michel Cadot
Messages: 68678
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

...or DESCRIBE.

SQL> help desc
 DESCRIBE
 --------

 Lists the column definitions for a table, view, or synonym,
 or the specifications for a function or procedure.

 DESC[RIBE] {[schema.]object[@connect_identifier]}

Report message to a moderator

Re: description keyword [message #615521 is a reply to message #615520]

Thu, 05 June 2014 02:22

hahaie
Messages: 194
Registered: May 2014

Senior Member

no,this is description in plsql.see file attachment

Report message to a moderator

Re: description keyword [message #615522 is a reply to message #615521]

Thu, 05 June 2014 02:25

Michel Cadot
Messages: 68678
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is from which tool?

Report message to a moderator

Re: description keyword [message #615523 is a reply to message #615522]

Thu, 05 June 2014 02:28

hahaie
Messages: 194
Registered: May 2014

Senior Member

plsql developer

Report message to a moderator

Re: description keyword [message #615542 is a reply to message #615523]

Thu, 05 June 2014 04:55

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

hahaie wrote on Thu, 05 June 2014 12:58

plsql developer

I agree that you see two reserved keywords in PL/SQL Developer when using SQL window. However, you must ignore the "DECRIPTION" keyword. Only "DESC" is valid. You can validate it using "command window", you would see that "description" is not a keyword at all. Only "desc" keyword would work to describe an object.

/forum/fa/11919/0/

Attachment: PLSQL_Developer_Ver_10.jpg
(Size: 14.17KB, Downloaded 2711 times)

Report message to a moderator

Re: description keyword [message #615543 is a reply to message #615542]

Thu, 05 June 2014 05:01

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

There are so many other keywords in the PL/SQL Developer tool which are not reserved keywords. For example, see this :

/forum/fa/11920/0/

Is "CONSIDER" a reserved keyword? Of course not.

NOTE : Only 1 file attachment is allowed per message so posting this example as another message.

Attachment: Incorrect_keywords.jpg
(Size: 19.93KB, Downloaded 2674 times)

Report message to a moderator

Re: description keyword [message #615544 is a reply to message #615543]

Thu, 05 June 2014 05:13

hahaie
Messages: 194
Registered: May 2014

Senior Member

Thanks, but your answer did not satisfy me!
in "command window" how to get the key words?

Report message to a moderator

Re: description keyword [message #615545 is a reply to message #615544]

Thu, 05 June 2014 05:21

Michel Cadot
Messages: 68678
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Keywords for PLSQL Developer or keywords for SQL and PL/SQL?

Report message to a moderator

Re: description keyword [message #615546 is a reply to message #615544]

Thu, 05 June 2014 05:28

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

hahaie wrote on Thu, 05 June 2014 15:43

Thanks, but your answer did not satisfy me!
in "command window" how to get the key words?

I tried explaining you. If it bothers you so much, then use SQL*Plus.

Report message to a moderator

Previous Topic:	Run Log in SQLDeveloper still going even if DBMS_SCHEDULER.LOGGING_OFF is set
Next Topic:	Package body not showing.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 11 20:57:10 CDT 2024