PACKAGE NAME.PROCEDURE NAME (parameters); variable := PACKAGE NAME.FUNCTIO

Explain how procedures and functions are called in a PL/SQL
block ?

Question Posted / tulsi

Answer Posted / tulsi

PACKAGE NAME.PROCEDURE NAME (parameters);
variable := PACKAGE NAME.FUNCTION NAME (arguments);

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the purpose of a secondary key?

951

what is collation? : Sql dba

1139

Define join and name different types of joins?

995

What is over () in sql?

943

What is sql and how does it work?

1159

what are the drivers in mysql? : Sql dba

1012

What are the string functions in sql?

964

Explain polymorphism in pl/sql.

1110

What is sqlite format?

1184

Can you inner join the same table?

988

Which kind of parameters cannot have a default value in pl sql?

1134

Can we call stored procedure in function?

952

What is dialect in sql?

939

Can we rollback truncate?

992

What is difference between group by and partition by?

1048