- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: SQL script needed
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2002 02:32 AM
тАО09-27-2002 02:32 AM
I'm running an ORACLE8 on a HPUX machine and I have a table with 80 objects. I need to compare the values of these objects before and after I perform some tests. The problem is, when I perform a "select" sql query for * (all the objects) the result is a mess - I cannot read the values under the corresponding object. I have tried with several linesizes - it doesn't work. Can somebody help me to retrieve some valuable information from my table?
Best regards,
john
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2002 02:36 AM
тАО09-27-2002 02:36 AM
Re: SQL script needed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2002 03:08 AM
тАО09-27-2002 03:08 AM
Re: SQL script needed
Can you read the values if you select just one or two columns from the table?
It might be worth using the FORMAT command to ensure the output is formatted neatly.
Example
column A format 999,999
select INT_ID as A from p_nbsc_packet_control_unit
That would ensure that every value from column INT_ID would be shown in the specified format.
Hope this helps a little,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2002 03:40 AM
тАО09-27-2002 03:40 AM
Re: SQL script needed
My unix tip - is only to open the terminal make the font size small, than resize and try set LINE_SIZE in oracle.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2002 03:52 AM
тАО09-27-2002 03:52 AM
Re: SQL script needed
What is your settings for WRAP ? If it's ON try to set to OFF with SET WRAP OFF command.
Best regards,
OK
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2002 03:56 AM
тАО09-27-2002 03:56 AM
Re: SQL script needed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2002 03:56 AM
тАО09-27-2002 03:56 AM
Re: SQL script needed
http://www.toadsoft.com/
it is 2MB freeware and exactly solve your problem.It uses sqlnet, you don't need to install anything else.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2002 04:02 AM
тАО09-27-2002 04:02 AM
Re: SQL script needed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2002 04:15 AM
тАО09-27-2002 04:15 AM
Solutionwhat about the attached script
Not the most recent but does the trick :
1) generate SQL script to extract data and format it as for a load (sqlloader)
2) generate the control file for the loader, but you won't need it in your case
Therefore, run the 1st SQL to generate your extract SQL script.
run you extract before your test
run your extract after your test
diff the 2 files
hope this help
Jean-Luc
Note : you can amend the generated script to sort the output on a specific order.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2002 04:19 AM
тАО09-27-2002 04:19 AM
Re: SQL script needed
I have to understand what to change in your script to adapt it to my needs. But this was what I looked for.
case closed