What is the difference between anonymous block and named
block or stored procedure?

Answer Posted / tushar

annonymous block-it do not returns values
Named block-named block called function must returned values

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is uncommittable transactions? : Transact sql

655


How do you write an inner join query?

603


If a cursor is open, how can we find in a pl/sql block?

780


Explain the update statement in sql

648


Describe types of sql statements?

635






Where is all the data on the internet stored?

645


Is left join inner or outer by default?

626


what is the syntax for using sql_variant_property? : Transact sql

627


What is dbo in sql?

618


What is the maximum number of triggers, you can apply on a single table?

643


What is execute immediate?

634


Can delete statement be rollbacked?

620


how to use regular expression in pattern match conditions? : Sql dba

623


What is trigger explain it?

636


What is the difference between distinct and unique in sql?

550