Hi,
I am new to ORACLE DBA and just started my training..
I know how to format "Columns" using sqlplus but my question is how can i display "ename" (from EMP table) in UPPER, lower or Initcap case by using "SELECT * "....???
I know the i can do it by writing select statement e.g
select
empno,
Lower (ename),
etc
etc
from
emp;
and the above statement show me the result ename is converted into Lower case.
but suppose if table have too many columns and i just want to change name columen in initcap so how can i do that. I don't want to state each and every column in my select statement like above.
is there any way that i can use format column command with "Select *" statement.
e.g
col ename as initcap
select * from emp;
...????????