Answer Posted / srao

Query is nothing but a single statement to retrieve data
from one or more tables.

Procedure is nothing but the combinations of Different
queries.

Is pl sql a scripting language?

969

---

What is union and union all keyword in sql and what are their differences?

1045

---

What is ttitle and btitle?

1006

---

Can we use commit inside a trigger?

1027

---

What is mutating error in pl sql?

962

---

what is the functionality of the function htmlentities? : Sql dba

891

---

what is the difference between group by and order by in sql? : Sql dba

1053

---

What is the use of count (*) in sql?

980

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2021

---

How to fix oracle error ora-00942: table or view does not exist

955

---

What is the usage of the distinct keyword?

1166

---

how to use like conditions? : Sql dba

1036

---

What is synonyms?

999

---

Is sql sequential or random?

981

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

2200

---