What are the advantages of pl sql over sql?

0 Answers  

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

0 Answers  

---

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  

---

I need a function for a train ticket reservation please answer it thanks in advance

0 Answers  

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---

---

What is the difference between a subquery and a join?

0 Answers  

---

how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,

---

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

---

How does left join work in sql?

0 Answers  

---

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

---

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---