• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1558
  • Last Modified:

Oracle Define Functions,Procedure or Package

Can you name Oracle defined inbuilt

1) Functions
2) Procedure
3) Packages  ???
0
gauravflame
Asked:
gauravflame
1 Solution
 
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now