Unix/Linux Go Back    


Programming Post questions about C, C++, Java, SQL, and other programming languages here.

Oracle/UNIX

Programming


Closed    
 
Thread Tools Search this Thread Display Modes
    #1  
Old Unix and Linux 01-01-2016   -   Original Discussion by zbest1966
zbest1966's Unix or Linux Image
zbest1966 zbest1966 is offline
Registered User
 
Join Date: Dec 2015
Last Activity: 12 December 2017, 10:48 AM EST
Location: Washington DC, Clinton, MD
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Unix or Linux Question Oracle/UNIX

How do you combine the two language.
Sponsored Links
    #2  
Old Unix and Linux 01-01-2016   -   Original Discussion by zbest1966
jim mcnamara's Unix or Linux Image
jim mcnamara jim mcnamara is offline Forum Staff  
...@...
 
Join Date: Feb 2004
Last Activity: 17 December 2017, 10:01 PM EST
Location: NM
Posts: 11,256
Thanks: 578
Thanked 1,122 Times in 1,034 Posts
Actually neither one is a computer language. I think you probably mean SQLPLUS (Oracle inquiry) and UNIX shell.

Simple example using a UNIX shell here document to call a sqlplus command
for a pretend user, passwd, and Oracle instance. You have to be able to execute the sqlplus command and have a valid oracle account before this will work:


Code:
sqlplus -s user/passwd@instance << -EOF
set head off

select field1 from mytable;
exit
EOF

Sponsored Links
Closed

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
oracle to unix djbilly UNIX for Advanced & Expert Users 1 02-09-2007 03:21 AM
unix for oracle ravi raj kumar UNIX for Dummies Questions & Answers 6 01-03-2007 05:19 AM
Restore of oracle 8i from hp unix 11.0 to HP unix 11i amitb HP-UX 1 05-26-2005 10:44 AM
Oracle 9i on Unix gerald_agoi Programming 2 09-17-2001 07:12 PM



All times are GMT -4. The time now is 02:48 AM.