Home » SQL & PL/SQL » Client Tools » description keyword
description keyword [message #615517] Thu, 05 June 2014 01:29 Go to next message
hahaie
Messages: 137
Registered: May 2014
Senior Member
What is DESCRIPTION keyword in plsql?
Re: description keyword [message #615518 is a reply to message #615517] Thu, 05 June 2014 01:39 Go to previous messageGo to next message
Littlefoot
Messages: 19817
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).
Re: description keyword [message #615519 is a reply to message #615518] Thu, 05 June 2014 02:05 Go to previous messageGo to next message
hahaie
Messages: 137
Registered: May 2014
Senior Member
So what is it?see attachment
Re: description keyword [message #615520 is a reply to message #615518] Thu, 05 June 2014 02:06 Go to previous messageGo to next message
Michel Cadot
Messages: 59814
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]}

Re: description keyword [message #615521 is a reply to message #615520] Thu, 05 June 2014 02:22 Go to previous messageGo to next message
hahaie
Messages: 137
Registered: May 2014
Senior Member
no,this is description in plsql.see file attachment
Re: description keyword [message #615522 is a reply to message #615521] Thu, 05 June 2014 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 59814
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

This is from which tool?



Re: description keyword [message #615523 is a reply to message #615522] Thu, 05 June 2014 02:28 Go to previous messageGo to next message
hahaie
Messages: 137
Registered: May 2014
Senior Member
plsql developer
Re: description keyword [message #615542 is a reply to message #615523] Thu, 05 June 2014 04:55 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2520
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.

./fa/11919/0/
Re: description keyword [message #615543 is a reply to message #615542] Thu, 05 June 2014 05:01 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2520
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 :

./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.
Re: description keyword [message #615544 is a reply to message #615543] Thu, 05 June 2014 05:13 Go to previous messageGo to next message
hahaie
Messages: 137
Registered: May 2014
Senior Member
Thanks, but your answer did not satisfy me!
in "command window" how to get the key words?
Re: description keyword [message #615545 is a reply to message #615544] Thu, 05 June 2014 05:21 Go to previous messageGo to next message
Michel Cadot
Messages: 59814
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: description keyword [message #615546 is a reply to message #615544] Thu, 05 June 2014 05:28 Go to previous message
Lalit Kumar B
Messages: 2520
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.
Previous Topic: Run Log in SQLDeveloper still going even if DBMS_SCHEDULER.LOGGING_OFF is set
Next Topic: Package body not showing.
Goto Forum:
  


Current Time: Thu Nov 27 18:55:38 CST 2014

Total time taken to generate the page: 0.09946 seconds