Answer / suman rana

select * from T2
minus
select * from T1

Answer / suresh babu

select SCN_TO_TIMESTAMP(ORA_ROWSCN) from table;

This query shows all records timestamp.From this result you
can find record,which recently updated.

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1 Answers   Oracle,

---

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 Answers  

---

Can Multiple instances be run on Single Machine???

3 Answers  

---

How to create a new table in oracle?

1 Answers  

---

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 Answers  

---

What happens to the data files if a tablespace is dropped?

1 Answers  

---

Is it possible to split the print reviewer into more than one region ?

1 Answers   Oracle,

---

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

7 Answers   Cognizant, IBM,

---

How to write date and time interval literals in oracle?

1 Answers  

---

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 Answers  

---

WHAT IS ecc 6.0

1 Answers  

---

Hi Can any one tell me what are the API's used in requisition import.

1 Answers  

---