|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
March 10th, 2004, 03:24 PM
|
|||
|
|||
|
SQL/Plus from Command Line
I was wondering is it possible to SSH into a server and run SQL/Plus from the command line or must I have some client installed?
Thanks, R
|
|
#2
March 12th, 2004, 12:30 PM
|
|||
|
|||
|
Re-
Sure, you just need to set environment variables
ORACLE_HOME=/bla/bla/bla; export ORACLE_HOME ORACLE_SID=<NAME>;export ORACLE_SID PATH=$PATH:$ORACLE_HOME/bin;export PATH etc..
|
|
#3
March 13th, 2004, 09:19 AM
|
|||
|
|||
|
Quote:
Ok, when I log in, those variables are set. I have never used SQL/Plus before, anytime I've had to do something with an oracle table, I've always authored a PHP script to do it. I'm assuming I can use SQL/Plus to create, alter, insert, and delete from Oracle tables? How do I launch SQL/Plus? Thanks, Roger
|
|
#4
March 13th, 2004, 12:16 PM
|
|||
|
|||
|
Sqlpus
if evrything is set you just need to call the sqlplus binary located $ORACLE_HOME/bin
SHELL>sqlplus username(owner of schema) sqlplus> that's it you can do any operations from here
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > SQL/Plus from Command Line |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
