| REPORT generating dilema SQL plus, SQL worksheet, SQL developer, when to you choose to use which.. [message #309876] |
Sat, 29 March 2008 10:12  |
oraclewannabe
Messages: 26
Registered: January 2008
|
Junior Member |
|
|
hi i am always generating report for my company into excel sheet..
and i encoutner a scenario where by i need to do a
BREAK ON col skip 1 command.
now i am wondering..
1) i am using sql developer to export the report into excel sheet everytime. and ihave tried using the break on col skip 1 command, it will not work on sql developer.
if i run it in a script [F5] i cannot export the data in excel..
2) if i use sql*plus to do the report, i wont not be able to see all the columns in 1 straight row..
even though i have set the linesize to the maximum..my tables has too many columns..
2nd , can sql*plus generate excel file?
3) what is the difference between sqlworksheet and sqlplus, does oracle10g still support sqlworksheet? i cant seem to find it in oracle10g
4) somehow i feel certain mechanism inside sqldeveloper sqlworksheet are the same of sqlplus,
anybody has a clue?
thats all 10s
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
