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 having clause is used in sql?

724


What does select count (*) mean in sql?

737


Does sql*plus also have a pl/sql engine?

761


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

940


How we can update the view?

811






Explain what is table in a database?

782


How many sql databases can you have on one server?

756


Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

754


What is data type in database?

728


How much does sql certification cost?

740


Which is faster subquery or join?

850


What is the difference between stored procedure and view?

736


What is a pdo connection?

683


What is a variable in sql?

720


What are the types of optimization?

688