What can be a size of a pl/sql block? Is there any limit?

Answer Posted / pavan_1981

not more 32KB

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we go for stored procedures?

490


discuss about myisam key cache. : Sql dba

540


What are the types of sql commands?

520


What are the types of index in sql?

512


What is difference between pls_integer and integer?

498






How do you optimize a query?

514


List different type of expressions with the example.

532


What is sql query optimization?

525


Can we rollback after truncate?

541


How many commands are there in sql?

521


What is the difference between a primary key and a unique key?

539


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

1029


How many sql statements are used?

544


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1509


How do you write a complex sql query?

560