annonymous block-it do not returns values Named block-named block called f

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

Question Posted / tushar

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

Please Help Members By Posting Answers For Below Questions

What is difference between cursor and trigger?

1017

Does truncate need commit?

893

Is primary key clustered or nonclustered?

952

What is procedure and function?

921

Can a key be both primary and foreign?

944

what is a materialized view? : Sql dba

996

What is the difference between subquery and correlated query?

989

What is clustered index sql?

931

What are sql functions? Describe the different types of sql functions?

1057

What is a delimiter in sas?

979

How do you run a query?

954

How many types of triggers are there in pl sql?

1012

What is a ddl command?

1006

how to use case expression? : Sql dba

958

What is the maximum size of sqlite database?

1040