Hi All,
I have created a external table as follows.
{code}
create table emp_ext
(
eno number(8),
ename varchar2(20)
)
organization external
( type oracle_loader
default directory <dr_name>
access parameters
fields (
eno position(1:8) char(8),
ename position(9:29) char2(20)
)
)
location (...);
{code}
Now I would like to add another called Salary with data type as number(8) ... can you please let me know the syntax to add SAL column with fixed length to the above external table..
SAL NUMBER8)
in organization external it exiss as SAL POSITION(30:38) chanr(8) .. how can I alter this External table.. can I have the syntax please.
Thanks