- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- sqlplus string to connect with out showing in ps c...
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
тАО06-30-2005 05:40 AM
тАО06-30-2005 05:40 AM
But when I try I get an error:
Original:
sqlplus -s user1/userpw <
yada yada...
What I am trying to do:
sqlplus -s <
yada, yada
ERROR:
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
where
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2005 05:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2005 06:02 AM
тАО06-30-2005 06:02 AM
Re: sqlplus string to connect with out showing in ps command
Is there a way to get rid of the extra fluff on feed back. I am piping to a file:
Extra fluff:
SQL*Plus: Release 8.1.7.0.0 - Production on Thu Jun 30 13:00:25 2005
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> Connected.
SQL>
no rows selected
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2005 06:24 AM
тАО06-30-2005 06:24 AM
Re: sqlplus string to connect with out showing in ps command
sqplus -s /nolog <
SELECT tn from TN_TABLE WHERE TN = '$i';
yada yada...
exit
EOF
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2005 06:43 AM
тАО06-30-2005 06:43 AM
Re: sqlplus string to connect with out showing in ps command
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2005 06:59 AM
тАО06-30-2005 06:59 AM
Re: sqlplus string to connect with out showing in ps command
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2005 07:14 AM
тАО06-30-2005 07:14 AM
Re: sqlplus string to connect with out showing in ps command
cat file |while read i
do
echo $i
sqlplus /nolog <
SELECT tn from tn_table WHERE TN = '$i';
EOF
done
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2005 07:15 AM
тАО06-30-2005 07:15 AM
Re: sqlplus string to connect with out showing in ps command
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2005 04:41 PM
тАО06-30-2005 04:41 PM
Re: sqlplus string to connect with out showing in ps command
one work around would be to spool to a file in the sqlplus then use another file which you would stuff all the outputs from sqlplus, i.e. something like
cat /dev/null > myresults.lis
cat file |while read i
do
echo $i
sqlplus /nolog <
spool tmpfile.lis
SELECT tn from tn_table WHERE TN = '$i';
spool off
EOF
cat tmpfile.lis >> myresults.lis
done
hope this helps!
regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-30-2005 04:45 PM
тАО06-30-2005 04:45 PM
Re: sqlplus string to connect with out showing in ps command
at the sqlplus level, you can also use the SQLPLUS commands like "set heading off" etc.
to remove any other unimportant info which of course you can also do at script level.
good luck
regards
yogeeraj