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 to create a menu in sqlplus or pl/sql?

1117

How do I kill a query in postgresql?

1098

What is a sql driver?

995

How delete all data from table in sql?

1014

What is the difference between sum and count in sql?

984

What is dml statement?

949

Explain 3 basic parts of a trigger.

1304

What are the types of join in sql?

1095

Can we join 3 tables in sql?

1031

What is the difference between syntax error and runtime error?

1135

What is the difference between python and sql?

995

Can we rename a column in the output of sql query?

991

How do I write a cron which will run a sql query and mail the results to agroup?

971

what is a constraint? : Sql dba

1150

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1103