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 sql built in functions?

936

---

How many triggers can be applied to a table?

1063

---

Can a table contain multiple primary key’s?

1097

---

What is the maximum database size for sql express?

1023

---

What is the difference between sql and isql*plus?

1094

---

what are the security recommendations while using mysql? : Sql dba

1117

---

what is the difference between char and varchar data types? : Sql dba

1109

---

What is a scalar value in sql?

1070

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

1021

---

Is oracle and sql same?

1007

---

What is pragma in pl sql?

1110

---

What is the clause we need to add in function body to return variable?

1012

---

What is the most restrictive isolation level? : Transact sql

1083

---

What are sql constraints?

1172

---

Why we use triggers in mysql?

992

---