how to connect oracle in unix prompt?
- 4 Answers
- 11045 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
HI,
This is not a big job
$ su orcale10g
$sql plus
username/password-scott/tiger
If not connected just mail me on my mail id
omkarp.joshi@yahoo.co.uk
| Is This Answer Correct ? | 11 Yes | 5 No |
Answer / vipul garg
Hi,
$ sqlplus sys/sys as sysdba
If connect a instance then
first set environment variable as :
$ export ORACLE_SID = instance_name
$ sqlplus username/password@servicename
Regards
Vipul Garg
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mannu
You have to set the following:
ORACLE_HOME
ORACLE_SID
PATH
| Is This Answer Correct ? | 4 Yes | 6 No |
What is the difference between explicit and implicit cursors in oracle?
how to connect oracle in unix prompt?
How will you a activate/deactivate integrity constraints?
How many null values can be inserted in a coulmn whihc is unique constraint
How many sql statements are used? Define them.
How do rank () and dense_rank () differ?
What is auto increment in sql?
Define commit, rollback and savepoint?
What are types of indexes in sql?
Is pl sql a programming language?
Why is normalization important?
What are the popular database management systems in the it industry?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
