Answer / vignesh lakshmirajan

The column contains null value will come first.. COz oracle consider the null value as larger value in this case....

Answer / suman rana

if you are sorting a table using "order by"(descending)
clause of a column which contains a null value, row
containing null value will come first. Alternatively you can
use the clause "Nulls First" along with order by clause to
appear the Null values first.

Can we write insert statement in function in oracle?

0 Answers  

---

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

1 Answers   Wipro,

---

How to drop a stored procedure in oracle?

0 Answers  

---

Explain implicit cursor.

0 Answers  

---

How to filter out duplications in the returning rows using oracle?

0 Answers  

---

Explain table?

0 Answers  

---

What happens if variable names collide with table/column names?

0 Answers  

---

Explain drop constraint oracle?

0 Answers  

---

in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

3 Answers   Polaris,

---

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

0 Answers  

---

Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

3 Answers  

---

What is self-referential integrity constraint ?

2 Answers   SunGard,

---