| sql [message #573] |
Thu, 21 February 2002 19:15  |
benu
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
|
why do we have to give an alias name in a sub query while creating a view?
|
|
|
|
| Re: sql [message #576 is a reply to message #573] |
Fri, 22 February 2002 03:56  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
it is not mandatory when u use original column names in select statement.
but if u use any functions on columns in query, you have to give valid alias name (it becomes column name of view)
ex:
1)create view v1 as select empno,ename from emp;
2) create view v2 as select empno,upper(ename) ENAME from emp;
3) create view v13(empno,ename) as
select empno,upper(ename) from emp;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
