[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Oracle Define Functions,Procedure or Package

Posted on 2007-11-28
9
Medium Priority
?
1,546 Views
Last Modified: 2013-12-18
Can you name Oracle defined inbuilt

1) Functions
2) Procedure
3) Packages  ???
0
Comment
Question by:gauravflame
9 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20371504
can you please clarify your question?

now, if I understand correctly, you want to rename the oracle functions?
0
 
LVL 3

Expert Comment

by:prasanthi_k
ID: 20371537
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
 
LVL 13

Accepted Solution

by:
sonicefu earned 1500 total points
ID: 20371565
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 13

Expert Comment

by:sonicefu
ID: 20371610
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
 
LVL 13

Expert Comment

by:sonicefu
ID: 20371633
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
 

Author Comment

by:gauravflame
ID: 20371705
Do Oracle have concept for Built in Procedures ?
0
 
LVL 27

Expert Comment

by:sujith80
ID: 20371805
>> Do Oracle have concept for Built in Procedures ?

Built in procedures to do what?
What exactly are you looking for?
0
 
LVL 13

Expert Comment

by:sonicefu
ID: 20371824
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses
Course of the Month8 days, 7 hours left to enroll

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question