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
Why do we go for stored procedures?
discuss about myisam key cache. : Sql dba
What are the types of sql commands?
What are the types of index in sql?
What is difference between pls_integer and integer?
How do you optimize a query?
List different type of expressions with the example.
What is sql query optimization?
Can we rollback after truncate?
How many commands are there in sql?
What is the difference between a primary key and a unique key?
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
How many sql statements are used?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
How do you write a complex sql query?