Oracle Define Functions,Procedure or Package

Can you name Oracle defined inbuilt

1) Functions
2) Procedure
3) Packages  ???
gauravflameAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you please clarify your question?

now, if I understand correctly, you want to rename the oracle functions?
0
 
prasanthi_kCommented:
In case you want to know the names of the built-in packages available in Oracle 10g, then there is a good book available online at http://www.unix.org.ua/orelly/oracle/bipack/ch01_02.htm

There is a list of many built-in packages there.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
sonicefuCommented:
Built-in function names can also be found from the following query

select object_name from all_arguments
where package_name = 'STANDARD'

Open in new window

0
 
sonicefuCommented:
If you want to become a master of developing your own PL/SQL Packages then download the following book
http://www.4shared.com/file/29142325/52885561/_eBook_-_chm__Advanced_Oracle_PLSQL_-_Programming_with_Packages.html?s=1
0
 
gauravflameAuthor Commented:
Do Oracle have concept for Built in Procedures ?
0
 
SujithData ArchitectCommented:
>> Do Oracle have concept for Built in Procedures ?

Built in procedures to do what?
What exactly are you looking for?
0
 
sonicefuCommented:
Yes there are, for example

DBMS_UTILITY.NAME_TOKENIZE procedure

This procedure calls the PL/SQL parser to parse the given name that is in the following format,

    a [ . b [. c]] [@dblink ]

where dblink is the name of a database link. Here's the header for the procedure:

    PROCEDURE DBMS_UTILITY.NAME_TOKENIZE
       (name  IN VARCHAR2,
        a OUT VARCHAR2,
        b OUT VARCHAR2,
        c OUT VARCHAR2,
        dblink OUT VARCHAR2,
        nextpos OUT BINARY_INTEGER);
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.