Answer Posted / 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

what are all the common sql function? : Sql dba

1131

---

how to escape special characters in sql statements? : Sql dba

1114

---

what is collation? : Sql dba

1229

---

how to start mysql server? : Sql dba

1267

---

what is dbms? : Sql dba

1061

---

If a cursor is open, how can we find in a pl/sql block?

1238

---

Does group by remove duplicates?

1112

---

what is bcp? When does it used? : Sql dba

1056

---

What is the best sql course?

1050

---

Is primary key always clustered index?

1095

---

how to use regular expression in pattern match conditions? : Sql dba

1113

---

What is the current version of sql?

1094

---

define sql insert statement ? : Sql dba

1098

---

what is sql server agent? : Sql dba

1182

---

Can we rollback truncate?

1074

---