- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- HOWTO format sql queries without having to use for...
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
тАО07-25-2003 11:50 AM
тАО07-25-2003 11:50 AM
HOWTO format sql queries without having to use format all the time ??
OK, not the end of the world, but pretty anoying to me !!!
I have this OID on tons of tables on this DB that is declared as number(18)
When bringing up sqlplus, trying to quickly look at this numbers, to do some troubleshooting, or checking things out, If I list these columns, I get :
OID1 OID2 OID3
2.34+14 2.34+14 2.34+14
these values are all different,but because they are sequential in nature, I can not quickly tell them apart, but by using the
column OID1 format 9999999999999999
Is there a quick way to make sqlplus display the whole value without going to this exercise everytime ?
Thanks,
Henrique
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2003 12:55 PM
тАО07-25-2003 12:55 PM
Re: HOWTO format sql queries without having to use format all the time ??
try to set all your common columns format in glogin.sql. always, sqlplus reads this file before it brings up the sql prompt. more or less like .profile.
hth,
Stan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2003 03:21 PM
тАО07-25-2003 03:21 PM
Re: HOWTO format sql queries without having to use format all the time ??
- use a script to save the sqlplus parameter settings:
set termout off
store set sqlplus_settings replace
clear breaks
clear columns
clear computes
set feedback off
set verify off
set termout on
set define "&"
- use a script to make changes of all the required format settings
- use another script to restore these parameter settings in cases where they need to be temporarily changed:
set termout off
@sqlplus_settings
clear breaks
clear columns
clear computes
set termout on
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-25-2003 08:48 PM
тАО07-25-2003 08:48 PM
Re: HOWTO format sql queries without having to use format all the time ??
you may wish to create a file called login.sql in your home directory and put the following lines in it:
column OID1 format 9999999999999999
hope this helps!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-27-2003 07:14 AM
тАО07-27-2003 07:14 AM
Re: HOWTO format sql queries without having to use format all the time ??
$ORACLE_HOME/sqlplus/admin/glogin.sql for Global settings for SQL
login.sql placed at home dir of the user which is user profile for SQL
First the glogin .sql is read and then the login.sql
Thanks