- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Sqlplus_Oracle8i
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
тАО03-10-2005 08:18 PM
тАО03-10-2005 08:18 PM
Sqlplus_Oracle8i
- Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
- PL/SQL Release 8.1.7.4.0 - Production
- TNS for Solaris: Version 8.1.7.4.0 - Production
but i need the output as
Oracle8i Enterprise Edition Release 8.1.7.4.0
PL/SQL Release 8.1.7.4.0
TNS for Solaris: Version 8.1.7.4.0
What i have to do ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2005 08:28 PM
тАО03-10-2005 08:28 PM
Re: Sqlplus_Oracle8i
cat /tmp/output | awk -F"-" {'print $2'} | cut -c2-
I don't know of a way in SQL - someone else may though.
Keith
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2005 08:38 PM
тАО03-10-2005 08:38 PM
Re: Sqlplus_Oracle8i
I don't know much about Sqlplus, but on Sybase ASE query we could achieve this.
Why don't you look into the sql guide and see if there is some string manipulation that can be done in the query using sqlplus.
Within the query we would output to a string and then do string manipulation before outputting..all in one sql statement
rgds
Mobeen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2005 08:46 PM
тАО03-10-2005 08:46 PM
Re: Sqlplus_Oracle8i
I am searching the same for last one hour.
but i didnt get.
Help me, if u have time.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2005 08:48 PM
тАО03-10-2005 08:48 PM
Re: Sqlplus_Oracle8i
try either of:
select replace(banner,' - Production','') from v$version
where banner LIKE '% 8.%'
or:
select replace(replace(banner,' - Production',''),'Production','') from v$version
where banner LIKE '% 8.%'
hope this helps!
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2005 08:51 PM
тАО03-10-2005 08:51 PM
Re: Sqlplus_Oracle8i
why did you include '-' to your sql statement?
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2005 08:52 PM
тАО03-10-2005 08:52 PM
Re: Sqlplus_Oracle8i
You are the man !! No wonder you have a crown :)
I think replace should do the trick :), i know all these SQLs subscribe to ANSI and i should have figured that out ...
Unfortunately i have nothing to test ...
regards
Mobeen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2005 08:53 PM
тАО03-10-2005 08:53 PM
Re: Sqlplus_Oracle8i
spool /tmp/output
run your SELECT statement
spool off
Then at Unix:
cat /tmp/output | awk -F"-" {'print $2'} | cut -c2-
HTH - Keith
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2005 08:54 PM
тАО03-10-2005 08:54 PM
Re: Sqlplus_Oracle8i
Yogeeraj's sqlplus will work.
Just be aware of the 64bit addition in the banner, if you ever convert to 64bit.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-10-2005 09:04 PM
тАО03-10-2005 09:04 PM
Re: Sqlplus_Oracle8i
it's working fine.
is it possible to print like this
Oracle8i Enterprise Edition Release 8.1.7.4.0
PL/SQL Release
TNS for Solaris: Version
that is like table format.
i.e Align format ?