IS 'define' a valid SQL statement?

Anuradha

• Oct 24th, 2005

 

 Ans:

No. Its a Keyword.

wkosmider

 Profile Answers by wkosmider 

• Nov 1st, 2005

 

Although true, I find "keyword" a bit too generic. It is a sqlplus command to set a value to a replacement parameter.

Sailaja Pasupuleti

• Dec 3rd, 2005

 

Hi,

  DEFINE is a command of SQL * PLUS Tool. 

  This is only valid in SQL * PLUS. 

  With DEFINE command, user can define the session variables.

  Ex:   SQL> DEFINE  pi=22/7

         SQL> select  &pi  from  dual;

         Output:-   3.14285714

Regards,

Sailaja

marthand

• Dec 27th, 2005

 

define is not a sql command

define is Isql*plus command.  to give a global variable we use it

vijaya

• Jan 10th, 2006

 

if DEFINE is isqlplus command then how do u define ACCEPT command. what is difference between them?i think define is a command in sql *plus which works same in isqlplus with ACCEPT.pls do forward the argument.