gauravflame
asked on
Oracle Define Functions,Procedure or Package
Can you name Oracle defined inbuilt
1) Functions
2) Procedure
3) Packages ???
1) Functions
2) Procedure
3) Packages ???
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.
There is a list of many built-in packages there.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Built-in function names can also be found from the following query
select object_name from all_arguments
where package_name = 'STANDARD'
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
http://www.4shared.com/file/29142325/52885561/_eBook_-_chm__Advanced_Oracle_PLSQL_-_Programming_with_Packages.html?s=1
ASKER
Do Oracle have concept for Built in Procedures ?
>> Do Oracle have concept for Built in Procedures ?
Built in procedures to do what?
What exactly are you looking for?
Built in procedures to do what?
What exactly are you looking for?
Yes there are, for example
DBMS_UTILITY.NAME_TOKENIZE
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);
DBMS_UTILITY.NAME_TOKENIZE
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);
now, if I understand correctly, you want to rename the oracle functions?