hello seniors,
my table structure have 4 remarks field of varchar2(500) size.
When ever i give select * from table name..
the result gets wrap into many lines ..like this
select * from EMP;
_CO _NO _DATE _EMP_CODE _APPLY_ _E _EMP_ _EMP_ _E _E _EMP_SVC_
------ ---------- ---------- ------------ ---------- ----- -------- -------- ----- ----- -----------
_INSTAL_AMOUNT _EMP_ID_CARD _FINANCE_BY L L
----------------- --------------- --------------- - -
_REMARK1
----------------------------------------------------------------------------------------------------
_REMARK2
----------------------------------------------------------------------------------------------------
_REMARK3
----------------------------------------------------------------------------------------------------
_REMARK4
----------------------------------------------------------------------------------------------------
_REFERENCE_NO _EMP_ADDRESS
-------------------- -------------------------------------------------------------------------------
_EMP_EMAIL _FLEXI_FIELD1
------------------------------ ------------------------------
Is there a way besides selecting field, field...,to get the ouput by giving SELECT *
but EXCLUDE 1 or more columns.
very troublesome to set the environment variables and oracle10g does not by its own produces a complete line wise
data depending upon the data in each row.
TY.