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'

How do we tune the code?

2 Answers  

---

What are the various levels of constraints?

0 Answers  

---

What is database sql?

0 Answers  

---

what is data integrity

3 Answers   Fidelity, TCS,

---

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---

how to connect oracle in unix prompt?

4 Answers   Polaris,

---

What is union and union all keyword in sql?

0 Answers  

---

What is procedure and function in sql?

0 Answers  

---

What does an inner join do?

0 Answers  

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

Explain what is sql*plus?

0 Answers  

---