Topic: SQL*Plus and PL/SQL >> Please give some idea about procedures and constraints
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Please give some idea about procedures and constraints |
| busi |
Posted: Jul 18, 2007 07:33:49 AM |
Total Post: 13
Joined: Jan, 2007
|
HI
Please give me some idea about stand-alone procedures ..?
1)When to use Standalone procedure ?
2)What are the constraints in Pl/SQL ?When to use these constraints in pl/sql?
3)What is Named Notation ?
Best Regards
Busi |
|
|
 Dipu |
| Posted: Jul 19, 2007 01:55:05 AM |  |
|
Total Post: 8
Joined: Nov, 2006
|
1. Standalone procedure is a procedure which can be executed independently means neither it will take any parameters from any other schema or else from any other databases nor it will pass any data to any other schema or databases.It can be executed within the schema of its own using parameters.
2.There is no specific constraints for PL/SQL.Whatever constraints are already defined by oracle are sufficient i.e. Primary Key,Candidate Key,Unique Key,Foreign Key and Check Constraint.
3. Named notion is , if you pass the actual parameters for formal parameters of a procedue or function or package in any order by using there name only.
Means suppose you create a procedure say x using char,number as passing parameter like.
Craete or replace procedure X(a in char,b in number);
If you want to execute it on SQL prompt, you haveto write like this:
SQL> Exec x(a=>'A',b=>2); or else
SQl> Exec x(b=>2,b=>'A');
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 335 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
