August 2010
You are currently browsing the articles from Techno Oracle written in the month of August 2010.
A working Oracle database instance is organized using initialization parameters,which are set in the initialization parameter file. These parameters influence the behavior of the running instance, including influencing performance. In general, a simple initialization file with applicable settings covers most situations, and the initialization file should be the first place you expect to do performance [...]
Written by admin on August 27th, 2010 with no comments.
Read more articles on Oracle PL/SQL and Oracle Tuning.
Just as you can base a record on a table, you can also base a record definition on a cursor.Records that are based on an Oracle cursor draw their structure from the SELECT statement used for the cursor. This type of record has the same number of columns, with the same names and datatypes, as [...]
Written by admin on August 22nd, 2010 with no comments.
Read more articles on Oracle PL/SQL and Records in Oracle.
If you have a record where all the fields in the record correspond exactly to the fields being returned from a SELECT statement, you can retrieve the values directly into that record. Here’s an example: DECLARE dept department%ROWTYPE; BEGIN SELECT * INTO dept FROM department WHERE dept_id = 502; … END; / You don’t have [...]
Written by admin on August 21st, 2010 with no comments.
Read more articles on Oracle PL/SQL and Records in Oracle.
If a record type variable is based on a table, it means that the fields in the record have the exact same name and data type as the columns in the specified table. You use the %ROWTYPE attribute to declare a record based on a table. To declare a record variable that exactly matches the [...]
Written by admin on August 21st, 2010 with no comments.
Read more articles on Oracle PL/SQL and Records in Oracle.
Records are a PL/SQL composite datatype.A record is a collection of individual values that are related somehow. Most often, records are used to represent a row in a table, and thus the relationship is based on all the values being from the same row. Each field in a record is unique and has its own [...]
Written by admin on August 21st, 2010 with no comments.
Read more articles on Records in Oracle.
Triggers may be dropped via the drop trigger command. In order to drop a trigger, you must either own the trigger or have the DROP ANY TRIGGER system privilege. Syntax: DROP TRIGGER trigger_name; Example: CREATE OR REPLACE TRIGGER EMP_MONDAY BEFORE INSERT OR UPDATE OR DELETE ON EMP BEGIN IF RTRIM(UPPER(TO_CHAR(SYSDATE,’DAY’)))=’MONDAY’ THEN RAISE_APPLICATION_ERROR (-20022,’NO OPERARTION CAN [...]
Written by admin on August 20th, 2010 with no comments.
Read more articles on Oracle PL/SQL and Triggers in oracle.
When a trigger is created it is automatically enabled and is triggered whenever the triggering command and the execution command is true.An enabled trigger executes the trigger body if the triggering statement is issued. To disable the execution use the ALTER TRIGGER command with the DISABLE clause. A disable trigger does not execute the trigger [...]
Written by admin on August 20th, 2010 with no comments.
Read more articles on Oracle PL/SQL and Triggers in oracle.
The Oracle engine provides a procedure named raise_appliation_error that allows programmers to issue user-defined error messages. Syntax: RAISE_APPLICATION_ERROR (error_number, message); Here: error_number It is a negative integer in the range-20000 to –20999 Message It is a character string up to 2048 bytes in length This procedure terminates procedure execution, rolls back any effects of the [...]
Written by admin on August 20th, 2010 with no comments.
Read more articles on Oracle PL/SQL and Triggers in oracle.
A trigger’s type is defined by the type of triggering transaction and by the level at which the trigger is executed. Oracle has the following types of triggers depending on the different applications: Row Level Triggers Statement Level Triggers Before Triggers After Triggers Here is a brief description about above triggers: Row Level Triggers Row [...]
Written by admin on August 20th, 2010 with no comments.
Read more articles on Oracle PL/SQL and Triggers in oracle.
A database trigger is a stored procedure that is fired when an INSERT,UPDATE, or DELETE statements is issued against the associate table.The name trigger is appropriate, as these are triggered (fired) whenever the above-mentioned commands are executed. A trigger defines an action the database should take when some database related event occurs. A trigger can [...]
Written by admin on August 19th, 2010 with no comments.
Read more articles on Triggers in oracle.
« Older articles
No newer articles