Answer / a.jyothsna

Declare section
---
declaring the variables
---
Begin section
---
executable statements
---
Exception section
---
exception handlers
---
end;

Answer / nishi

Declare section

---

declaring the variables

---

Begin section

---

executable statements

---

Exception section

---

exception handlers

---

end;

Answer / vijay_1994

declare
cursor
user defined exception
variable
begin
sql statement
plsql statement (application wise/business logic)
exception
end;

What is the use of prepared statement?

0 Answers  

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  

---

Why we use triggers in mysql?

0 Answers  

---

Explain the difference between 'between' & 'and' operators in sql

0 Answers  

---

Why sql query is slow?

0 Answers  

---

What is the difference between truncate and drop statements?

0 Answers  

---

what is the syntax used for partition in tsql? : Transact sql

0 Answers  

---

What is example of database?

0 Answers  

---

Can a foreign key have a different name?

0 Answers  

---

How to process query result in pl/sql?

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

Whis is not false in primary key?

0 Answers   Fintellix,

---