Answer / omkar pattajoshi

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

Answer / sushant

$sqlplus
$scott/tiger

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

Answer / mannu

You have to set the following:

ORACLE_HOME
ORACLE_SID
PATH

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

1 Answers  

---

What is the difference among union, minus and intersect?

1 Answers  

---

Talk about views

10 Answers   Polaris,

---

What is an escape character in sql?

1 Answers  

---

What does subquery mean in sql?

1 Answers  

---

What is procedure explain with program?

1 Answers  

---

when is the use of update_statistics command? : Sql dba

1 Answers  

---

What is a package ? What are the advantages of packages ?

2 Answers   Symphony,

---

how to create a table index in mysql? : Sql dba

1 Answers  

---

What is the difference between jpql and sql?

1 Answers  

---

Can cursors be part of a trigger body?

1 Answers  

---