]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

 · · · Index · Login/Register

Contents





1 registered user
 in last 24 hours

PL/SQL Name Function

A "name function" is a PL/SQL routine to return a human readable name of an object for any object type. As a convention, a name function consist of the object_type, followed by "__name" (double underscore).

 

Let's look take a typical example (obtaining the name of a project):

  

select im_project__name(:project_id)­­­

The only required parameter is the ID of an existing project.

 

This PL/SQL function just returns the contents of the im_projects.project_name database field.


Please take a moment to complete this form to help us improve our service.

Did this page help you to achieve your goal?
 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?
 1  2  3  4  5
Not
useful		       Extremely
useful
 
Privacy Policy
References to this Page: en:list_plsql, en:object_type_acs_object_type Categories: PL/SQL API (Contents)