OraFAQ Forum: Server Administration » what is the diff in all 3 stmts

Home » RDBMS Server » Server Administration » what is the diff in all 3 stmts

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

what is the diff in all 3 stmts [message #58266]

Mon, 11 August 2003 09:46

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 in 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 in all 3 stmts [message #58316 is a reply to message #58266]

Wed, 13 August 2003 16:26

ctg
Messages: 146
Registered: July 2002

Senior Member

#1 and #3 are the same. the AS keyword is optional in creating column aliases but is useful for self documentation.

#2 is invalid, it will cause an error

Report message to a moderator

Re: what is the diff in all 3 stmts [message #58331 is a reply to message #58316]

Thu, 14 August 2003 13:10

sidd
Messages: 130
Registered: May 2003

Senior Member

Thanks CTG

Report message to a moderator

Previous Topic:	URGENT: ORA 12154 on use of DB-Link
Next Topic:	DBFs, init.ora, control files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:00:27 CDT 2024