-
-
-
How to declare a variable with FLOAT (2 DECIMAL PLACES) in table creation in oracle?
How to declare a variable with FLOAT (2 DECIMAL PLACES) in table creation in oracle?
-
What are the differences between Database Trigger and Integrity constraints ?
A declarative integrity constraint is a statement about the database that is always true. A constraint applies to existing data in the table and any statement that manipulates the table. A trigger does not apply to data loaded before the definition of the trigger, therefore, it does not guarantee all data in a table conforms to the rules established...
Chankey007
- Oct 26th, 2010
An integrity constraint defines a business rule for a table column which automatically takes care by Oracle internally. Intefrity Constraints are NOT NULL, UNIQUE, CHECK, PRIMARY KEY, FOREIGN KEY.?...
samiksc
- Jan 19th, 2006
A trigger is a piece of code which gets automatically executed upon occurrence of an event. It may not be meant for enforcing integrity. For example you may want to save the user info as soon as he ma...
-
What is difference between Procedures and Functions ?
A Function returns a value to the caller where as a Procedure does not.
RPush
- Aug 5th, 2010
Procedure executes as a part of PL/SQL block wherein Function invoked as part of expression.Function must have RETURN keyword in the header , which is not applicable for Procedure.Function must return...
sameer rokde
- Aug 3rd, 2010
Procedure is to do specific task where as function is to compute values.Procedure may or may not return value at all, but function must return value.Function can be used in SQL statement but Procedure is not used.
-
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
sriatit
- Oct 12th, 2009
You can check this by using translate function. If the return value is NULL then the input is a number else it is character or alpha numeric.Ex:select ('abcd', '~0123456789', ...
PratikshaD
- Jun 12th, 2009
You can use translate function.translate(,'~0123456789','~') will return null if the input is numeric. Not null if the input is alphanumeric.
-
What are the advantages of having a Package ?
Increased functionality (for example,global package variables can be declared and used by any proecdure in the package) and performance (for example all objects of the package are parsed compiled, and loaded into memory once)
Pankaj Gauba
- Sep 13th, 2006
Main advantage is OVERLOADING of function and procedures
-
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.
-
Ans