Q&A Categories

Programmatic-Constructs

Wht is the logic to find whether the entered input is a number or the character. How can we design

Wht is the logic to find whether the entered input is a number or the character. How can we design this program using a procedure or the function '

Answers No Answers In: Programmatic-Constructs By: neha [ Grey Star Level] Sep 6, 2010

Which is better to use, procedures or packages? If a procedure within a package is called, will it

Which is better to use, procedures or packages? If a procedure within a package is called, will it load the entire package into memory? What is the best way to handle it? '

Answers No Answers In: Programmatic-Constructs By: bipin [ Grey Star Level] Sep 4, 2010

What  are  the  differences  between  Database  Trigger and Integrity

What  are  the  differences  between  Database  Trigger and Integrity constraints ? A declarative integrity constraint is a statement about the database that is always true....

Answers No Answers In: Programmatic-Constructs By: jes [ Grey Star Level] Sep 2, 2010

What  are  the  different  types  of PL/SQL program units that can be defined

What  are  the  different  types  of PL/SQL program units that can be defined and stored in ORACLE database ? Procedures and Functions,Packages and Database Triggers.  ...

Answers No Answers In: Programmatic-Constructs By: nitin [ Grey Star Level] Sep 2, 2010

What is difference between Procedures and Functions ?

What is difference between Procedures and Functions ? A Function returns a value to the caller where as a Procedure does not.'

Answers No Answers In: Programmatic-Constructs By: @mahesh@ [1 Grey Star Level] Aug 18, 2010

What is Database Trigger ?

What is Database Trigger ? A Database Trigger is procedure (set of SQL  and PL/SQL statements) that is automatically  executed  as  a  result of an insert in,update to, or delete...

Answers No Answers In: Programmatic-Constructs By: jes [ Grey Star Level] Aug 17, 2010

What is a Procedure ?

What is a Procedure ? A  Procedure consist of a set of SQL and PL/SQL statements that are grouped together  as a unit to solve a specific problem or perform a set of related tasks.  ...

Answers No Answers In: Programmatic-Constructs By: raju1587 [1 Grey Star Level] Aug 15, 2010

What is a Package ?

What is a Package ? A  Package  is a collection of related procedures, functions, variables and other package constructs together as a unit in the database.'

Answers No Answers In: Programmatic-Constructs By: admin [ Grey Star Level] Aug 15, 2010

What is a form trigger?

What is a form trigger? '

Answers No Answers In: Programmatic-Constructs By: pooja [ Grey Star Level] Aug 14, 2010

What are the uses of Database Trigger ?

What are the uses of Database Trigger ? Database  triggers  can  be  used  to automatic data generation, audit data modifications, enforce complex Integrity constraints, and customize...

Answers No Answers In: Programmatic-Constructs By: admin [ Grey Star Level] Aug 12, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]