Good morning dba gurus,

i have a doub Regarding the STANDARD package? May i request you to help me
on this?
All the general oracle functions are there in standard package,like
to_char,substr,etc.
Suppose if i want to call a function or a procedure in a package,i have to
prefix the package
name and associate that particular procedure or function name.Like if i want
to call
SUBMIT of DBMS_JOB, i am using DBMS_JOB.SUBMIT(?,?,?,?).
But we are not prefixing the STANDARD package name anywhere while calling
the standard functions,like
substr,to_char,to_date,etc,etc.
How oracle is managing this? How i am able to call the function or a
procedure in the
package standard, without giving the package name?

Pls forgive me if this questions sounds simple.

Thanks in Advance.

Regards,
Giridhar Kodakalla


Oracle LazyDBA home page