OraFAQ Forum: Server Administration » What is the diff b/w 3 stmts

Home » RDBMS Server » Server Administration » What is the diff b/w 3 stmts

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

What is the diff b/w 3 stmts [message #58267]

Mon, 11 August 2003 09:47

sidd
Messages: 130
Registered: May 2003

Senior Member

what is the difference between all 3 stmts
1. select name Person_Name from emp;
2. select name into Person_Name from emp;
3. select name as Person_Name from emp;
which one is good to use. and why?

Report message to a moderator

Re: What is the diff b/w 3 stmts [message #58268 is a reply to message #58267]

Mon, 11 August 2003 10:45

Mike
Messages: 417
Registered: September 1998

Senior Member

Do your homework and you will get it ;-)

Have fun
Mike

Report message to a moderator

Re: What is the diff b/w 3 stmts [message #58273 is a reply to message #58267]

Tue, 12 August 2003 00:43

Maaher
Messages: 7065
Registered: December 2001

Senior Member

"Which one is good to use where?" would be a better question.

1 and 3 are SQL statements. The second one (select..into) is PL/SQL
MHE

Report message to a moderator

Re: What is the diff b/w 3 stmts [message #58294 is a reply to message #58268]

Tue, 12 August 2003 23:10

nsuria
Messages: 2
Registered: August 2003

Junior Member

Well Said Mike....
I really dont think we can compare the 3 statements.

Report message to a moderator

Re: What is the diff b/w 3 stmts [message #58296 is a reply to message #58268]

Wed, 13 August 2003 00:51

nsuria
Messages: 2
Registered: August 2003

Junior Member

Well Said Mike....
I really dont think we can compare the 3 statements.

Report message to a moderator

Re: What is the diff b/w 3 stmts [message #58893 is a reply to message #58267]

Fri, 10 October 2003 10:24

sidd
Messages: 130
Registered: May 2003

Senior Member

1 and 3 mean the same i.e. Person_name is the alias for the name column whereas in case of 2. value will be put into person_name variable.

Report message to a moderator

Previous Topic:	Backward compatibility 9i, 8i?
Next Topic:	How to Connect client oracle 9i to server 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:40:59 CDT 2024