SQL Plus - IS 'define' a valid SQL statement?

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 94 of 132

IS 'define' a valid SQL statement?

Total Answers and Comments: 5

Last Update: January 10, 2006 Asked by: suresh

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 24, 2005 14:05:57

Anuradha

RE: IS 'define' a valid SQL statement?

Ans:

No. Its a Keyword.

Is this answer useful? Yes | No

November 01, 2005 07:45:06

wkosmider

Member Since: October 2005 Contribution: 1

RE: IS 'define' a valid SQL statement?

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

Is this answer useful? Yes | No

December 03, 2005 08:35:06

Sailaja Pasupuleti

RE: IS 'define' a valid SQL statement?

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

Is this answer useful? Yes | No

December 27, 2005 00:59:30

marthand

RE: IS 'define' a valid SQL statement?

define is not a sql command

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

Is this answer useful? Yes | No

January 10, 2006 14:15:56

vijaya

RE: IS 'define' a valid SQL statement?

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank