Posts
كل كلمات امتحان الـ IELTS اللى هتحتاجها
12 years ago
skip to main |
skip to sidebar
Live ORACLE
if you are Oracle Developer ,than this Blog most likely will make you happy.
About my Blog
This Blog particularized for Oracle Developers ... you will see interesting Codes for SQL , PL/SQL as well as new ideas for Developer Suite and Client Tools that will help you in your professional life ... and I hope I reach for your satisfaction.
About Me
I'm Hany Freedom , 25 years old , I live in EL-Minia City in Egypt , I'm Moderator at ArabOUG.org the best Arabic Forum for ORACLE on the Net. if you interested to know more about me .... just Click Here.
Labels
- Client Tools Tutorial (2)
- Forms (4)
- my White Papers (4)
- Oracle Books (5)
- Oracle Magazine (12)
- PL/SQL Codes (285)
- Site Map (1)
- SQL Codes (23)
Blog Archive
-
▼
2009
(272)
-
▼
February
(139)
- Using ROWNUM
- Using CURRVAL and NEXTVAL
- Oracle Magazine - March/April 2009
- Calling the SQL COUNT Function in PL/SQL
- Substituting PL/SQL Variables
- Checking SQL%ROWCOUNT After an UPDATE
- Data Manipulation With PL/SQL
- Using BULK COLLECT With a SELECT INTO Statement
- Using the RETURNING Clause with a Record
- Updating a Row Using a Record
- Inserting a PL/SQL Record Using %ROWTYPE
- Using SELECT INTO to Assign Values in a Record
- Assigning All the Fields of a Record in One Statement
- Assigning Default Values to a Record
- Declaring a Nested Record
- Using a Record as Parameter to a Procedure
- Returning a Record from a Function
- Using %ROWTYPE to Declare a Record
- Declaring and Initializing Record Types
- Declaring and Initializing a Simple Record Type
- Incompatibility Between Package and Local Collecti...
- How Invalid Subscripts are Handled With DELETE(n)
- Collection Exceptions
- Using the DELETE Method on a Collection
- Using TRIM on Deleted Elements
- Using TRIM to Decrease the Size of a Collection
- Using EXTEND to Increase the Size of a Collection
- Using NEXT to Access Elements of a Nested Table
- Using PRIOR and NEXT to Access Collection Elements
- Using FIRST and LAST With a Collection
- Checking the Maximum Size of a Collection With LIMIT
- Counting Collection Elements With COUNT
- Checking Whether a Collection Element EXISTS
- Multilevel Associative Array
- Multilevel Nested Table
- Multilevel VARRAY
- Comparing Nested Tables with Set Operators
- Comparing Two Nested Tables
- Checking if a Collection Is Null
- Assigning Values to Tables with Complex Datatypes
- Assigning Values to VARRAYs with Complex Datatypes
- Assigning Nested Tables with Set Operators
- Assigning a Null Value to a Nested Table
- Datatype Compatibility for Collection Assignment
- Referencing an Element of an Associative Array
- Referencing a Nested Table Element
- Empty Varray Constructor
- Combining Collection Declaration and Constructor
- Collection Constructor Including Null Elements
- Constructor for a Varray
- Constructor for a Nested Table
- NOT NULL Constraint on Collection Elements
- VARRAY of Records
- Specifying Collection Element Types with %TYPE and...
- Calling a Procedure With a Nested Table Parameter
- Declaring a Procedure Parameter as a Nested Table
- Declaring Collections with %TYPE
- Declaring Nested Tables, Varrays, and Associative ...
- Declaring an Associative Array
- Declaring Collection Types
- Using NULL as a Placeholder When Creating a Subpro...
- Using the NULL Statement to Show No Action
- Using a GOTO Statement to Branch an Enclosing Block
- Using a NULL Statement to Allow a GOTO to a Label
- Using a Simple GOTO Statement
- Using EXIT With a Label in a LOOP
- Using EXIT in a LOOP
- Using Labels on Loops for Referencing
- Using a Label for Referencing Variables Outside a ...
- Scope of the LOOP Counter Variable
- Specifying a LOOP Range at Run Time
- Changing the Increment of the Counter in a FOR..LO...
- Using a Reverse FOR..LOOP Statement
- Using a Simple FOR..LOOP Statement
- Using EXIT With Labeled Loops
- Using an EXIT Statement
- Using the Searched CASE Statement
- Using the CASE-WHEN Statement
- Extended IF-THEN Statement
- Using the IF-THEN-ELSIF Statement
- Nested IF Statements
- Using a Simple IF-THEN-ELSE Statement
- Using a Simple IF-THEN Statement
- Using the Function RTRIM
- Comparing Character Values
- Implicit Conversion
- Using SUBTYPE With %TYPE and %ROWTYPE
- Default Value With Subtypes
- Constraints Inherited by Subprograms
- Type Compatibility With the NUMBER Datatype
- Using Ranges With Subtypes
- Assigning Literals to an INTERVAL DAY TO SECOND Va...
- Assigning Literals to an INTERVAL YEAR TO MONTH Va...
- Assigning a Literal Value to a TIMESTAMP WITH LOCA...
- Assigning a Literal to a TIMESTAMP WITH TIME ZONE ...
- Using the SCN_TO_TIMESTAMP and TIMESTAMP_TO_SCN Fu...
- Assigning a Literal Value to a TIMESTAMP Variable
- Using the Function REPLACE
- Using the Function NVL
- Using the Function DECODE
-
▼
February
(139)
Thanks for reading my Blog ... you Visitor Number :-
Hi there , Your example is very clear , but if i need to pass a variable value for the interval
say :
LW_MIN := INTERVAL '+01 00:30:00' DAY TO SECOND;
for the hard coded '+01 00:30:00' i need to pass a Variable , how can that be done pls help
Hi
THis was the example i was looking for . MOst of the example exaplining the Interval day to second are taking values from the table and not directly assiging the value to the variable ..