-
hi,
I am trying to do some column formating for the following table (egs emp)
I have a script as
begin
col empid a(4);
col empname a(30);
col deptno 9999;
end;
i am getting the following err
ERROR at line 2:
ORA-06550: line 2, column 5:
PLS-00103: Encountered the symbol "empid" when expecting one of the
following:
:= . ( @ % ;
Can I use this script for column formating ,when ever I need it
or exclucively set it?
Please advise
Badrinath
-
See this example for sample sql script formatting.
col owner format a12
col db_link format a36
col username format a12
col host format a12
col created format a12
select owner,
db_link,
username,
host,
created
from dba_db_links ;