YOU CAN NOT PASS PARAMETERS IN ANONYMOUS BLOCK WHERE AS YOU CAN PASS IT I

what is the difernece between named and anonymous pl/sql
blocks??

Question Posted / dev

Answer Posted / dev

YOU CAN NOT PASS PARAMETERS IN ANONYMOUS BLOCK
WHERE AS YOU CAN PASS IT IN NAMED PLSQL BLOCK.

YOU CAN CALL NAMED BLOCK FROM ANY DB(USING DB LINK)

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do you update a value in sql?

1099

How do I start sql from command line?

1079

Is sql considered coding?

1088

Whis is not false in primary key?

1517

explain commit and rollback in mysql : sql dba

1069

What is before and after trigger?

1007

How to disable a trigger name update_salary?

1308

Can we edit a view in sql?

1040

Can we insert in view in sql?

1100

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2608

What are the types of triggers in sql?

1140

What are the rules to be applied to nulls whilst doing comparisons?

1365

What is assignment operator in pl sql?

1086

What are packages in pl sql and also explain its advantages?

1119

Can 2 queries be executed simultaneously in a distributed database system?

1189