Answer / pavan_1981

not more 32KB

Answer / akshata kamat

The maximum parsed/compiled size of a PL/SQL block is 64K
and the maximum code size is 100K.You can run the following
select statement to query the size of an existing package or
procedure. SQL> select * from dba_object_size where name =
'procedure_name'

What is numeric function sql?

0 Answers  

---

Does sql between include endpoints?

0 Answers  

---

what is the difference between to_char and to_date functions?

10 Answers   Infosys,

---

Can we use rowid as primary key?

0 Answers  

---

Is there any restriction on the use of union in embedded sql?

0 Answers  

---

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

What does select count (*) mean in sql?

0 Answers  

---

Difference between truncate, delete and drop commands?

0 Answers  

---

Write a query to display the current date in sql?

0 Answers  

---

what is foreign key? : Sql dba

0 Answers  

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

Why do we need view in sql?

0 Answers  

---