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

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

569


Explain the components of sql?

581


How can you view the errors encountered in a trigger?

532


What is the difference between sum and count in sql?

507


Can we group by two columns in sql?

493






What does trigger mean in slang?

511


Can we alter stored procedure?

533


How is data stored on a disk?

525


Why do we go for stored procedures?

503


What is composite primary key in sql?

512


What are the sql commands?

598


Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

479


what is sub-query? : Transact sql

587


What is trigger explain with example?

537


What are the operators in sql?

515