Home » SQL & PL/SQL » SQL & PL/SQL » sql
sql [message #573] Thu, 21 February 2002 19:15 Go to next message
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 Go to previous message
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;
Previous Topic: ORA-01843: not a valid month
Next Topic: sequel server
Goto Forum:
  


Current Time: Fri Mar 29 00:30:51 CDT 2024