Answer Posted / ashi

Sub query: The sub query has more than one select
statement,the inner query which executes first and then it
will be the value of the 2nd query.
EX:
select ename from emp where sal>(select avg(sal) from emp);

Joins:
When the data from more than one table in the database,then
a join condition used.Rows in the one table can be joined to
rows in the other table according ro the common values
existing in corresponding columns
EX:
select dname,ename from emp,dept where emp.deptid=dept.deptid;

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2174

---

What is Reduced List of Values?

2241

---

How do we get field detail of a table?

1124

---

What are the tools for Oracle ?

1105

---

Name the various constraints used in oracle?

1075

---

Please explain joins in oracle?

1103

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1921

---

State some uses of redo log files?

1064

---

Difference between open_form and call_form in oracle.

1217

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2353

---

What are the most common interview questions on ETL Testing for experience?

1185

---

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1996

---

What is tns service name?

1177

---

what is the use of system.effective.date variable in oracle?

1161

---

What do you mean by merge in oracle?

1027

---