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 the usages of sql?

1011

---

What is the purpose of primary key?

966

---

Why query optimization is needed?

862

---

Is pl sql and postgresql same?

1053

---

What is difference between sql function and stored procedure?

942

---

explain the difference between myisam static and myisam dynamic. : Sql dba

885

---

What is varchar sql?

1059

---

How do I view a table in sql?

947

---

explain advantages of innodb over myisam. : Sql dba

1083

---

Can a table contain multiple primary key’s?

1042

---

what is a table in a database ? : Sql dba

989

---

What are tables and fields?

973

---

What are the indexing methods?

1002

---

what is the difference between join and union? : Sql dba

1028

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1292

---