Answer Posted / venubabu

Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;


sql>Enter value for level:5

why dont we assign not null constraint as table level constraint.

2717

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2480

---

How to select some columns from a table in oracle?

1063

---

What is a tns file?

976

---

What do you mean by cdb and pdb in oracle 12c?

1038

---

Can sub procedure/function be called recursively?

982

---

What is open database communication (odbc) in oracle?

987

---

How to run create database statement?

1008

---

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2194

---

What is the use of aggregate functions in oracle?

1012

---

Explain drop constraint oracle?

1033

---

How to convert character types to numeric types?

1096

---

Give syntax for SQL and ORACLE joins.

1075

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1088

---

What is a nested table?

1036

---