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.

Site Map

Site Map

Homepage

Last updated: 2009, November 18

/ 12 pages
Live ORACLE
Live ORACLE: November 2009
Live ORACLE: October 2009
Live ORACLE: September 2009
Live ORACLE: July 2009
Live ORACLE: June 2009
Live ORACLE: May 2009
Live ORACLE: April 2009
Live ORACLE: March 2009
Live ORACLE: February 2009
Live ORACLE: December 2008
Live ORACLE: November 2008
11/ 27 pages
Live ORACLE: password encryption package
Live ORACLE: populate a PL/SQL Table from a cursor
Live ORACLE: Profile PL/SQL code to get run-time statistics
Live ORACLE: BULK COLLECT and BULK BIND
Live ORACLE: UPDATE/DELETE in a LOOP
Live ORACLE: Delete duplicate values from a table
Live ORACLE: Convert LONG datatypes to LOBs (Large Objects)
Live ORACLE: VARRAY
Live ORACLE: Oracle database types and object tables
Live ORACLE: Count the number of rows for ALL tables in the current schema
Live ORACLE: Encoding and Decoding of Secret Messages
Live ORACLE: Spell out Numbers to Words
Live ORACLE: Check if a year is a leap year
Live ORACLE: Example of how to pass application info through to Oracle RDBMS
Live ORACLE: Display table and column comments for the current schema
Live ORACLE: Example script to demonstrate DEFAULT column values
Live ORACLE: Select the Nth highest - lowest value from a table
Live ORACLE: Reports information about your current database context
Live ORACLE: Show database version with options installed
Live ORACLE: Oracle Magazine (May/June 2008)
Live ORACLE: Oracle Magazine (July/August 2008)
Live ORACLE: Oracle Magazine (September/October 2008)
Live ORACLE: CROSS MATRIX report
Live ORACLE: SQL Hacks Source code
Live ORACLE: Oracle to Excel via Sqlplus
Live ORACLE: Oracle Magazine (November/December 2008)
Live ORACLE: BULK COLLECT and BULK BIND
12/ 41 pages
Live ORACLE: Oracle Database Design
Live ORACLE: Oracle Forms & Reports
Live ORACLE: Oracle Database Programming
Live ORACLE: Introduction on Oracle Database
Live ORACLE: Register on Oracle.com
Live ORACLE: Make a shortcut Icon for your Oracle Project
Live ORACLE: Oracle Magazine (January/February 2009)
Live ORACLE: Download and Install Oracle DB and Developer Step by Step
Live ORACLE: Foreign Key by TOAD
Live ORACLE: Package to generate HTML-type documentation for Oracle objects
Live ORACLE: Converts a string of text into seperate soundex values
Live ORACLE: NYSIIS function (an improvement on soundex)
Live ORACLE: convert numbers to chars for printing cheques amount in Indian Style
Live ORACLE: This function will convert a number to words, handy for ptinting cheques
Live ORACLE: Replace all occurences of a substring with another substring
Live ORACLE: Count the number of rows for ALL tables in current schema
Live ORACLE: List tables from schema with more than X rows
Live ORACLE: Maintain an audit log of DDL changes (alter/ drop/ create) within a schema
Live ORACLE: Access Internet Web pages from SQL or PL/SQL
Live ORACLE: Send e-mail messages and attachments from PL/SQL (using UTL_SMTP)
Live ORACLE: Send e-mail messages and attachments from PL/SQL
Live ORACLE: Send e-mail messages from PL/SQL
Live ORACLE: Execute operating system commands from PL/SQL
Live ORACLE: Demonstrate Java stored procedures
Live ORACLE: Example PL/SQL code to demonstrate Dynamic SQL
Live ORACLE: Create a database view on top of a file
Live ORACLE: writing to a file using the UTL_FILE package
Live ORACLE: Fetch Long column values piece-wise from PL/SQL
Live ORACLE: Load a binary file (images, documents, etc) into a database table
Live ORACLE: Fetch LOB column values piece-wise from PL/SQL
Live ORACLE: Algorithms
Live ORACLE: Print ASCII table
Live ORACLE: Check if a year is a leap year (FUNCTION)
Live ORACLE: Random number/ string generator package
Live ORACLE: Package with functions to convert numbers between the Decimal, Binary, Octal and Hexidecimal numbering systems
Live ORACLE: Pass Result sets (REF CURSOR) between Procedures and Functions
Live ORACLE: Oracle Database Programming
Live ORACLE: Download and Install Oracle DB and Developer Step by Step
Live ORACLE: Execute operating system commands from PL/SQL
Live ORACLE: Execute operating system commands from PL/SQL
Live ORACLE: Fetch Long column values piece-wise from PL/SQL
02/ 143 pages
Live ORACLE: Using ROWNUM
Live ORACLE: Using CURRVAL and NEXTVAL
Live ORACLE: Oracle Magazine - March/April 2009
Live ORACLE: Calling the SQL COUNT Function in PL/SQL
Live ORACLE: Substituting PL/SQL Variables
Live ORACLE: Checking SQL%ROWCOUNT After an UPDATE
Live ORACLE: Data Manipulation With PL/SQL
Live ORACLE: Using BULK COLLECT With a SELECT INTO Statement
Live ORACLE: Using the RETURNING Clause with a Record
Live ORACLE: Updating a Row Using a Record
Live ORACLE: Inserting a PL/SQL Record Using %ROWTYPE
Live ORACLE: Using SELECT INTO to Assign Values in a Record
Live ORACLE: Assigning All the Fields of a Record in One Statement
Live ORACLE: Assigning Default Values to a Record
Live ORACLE: Declaring a Nested Record
Live ORACLE: Using a Record as Parameter to a Procedure
Live ORACLE: Returning a Record from a Function
Live ORACLE: Using %ROWTYPE to Declare a Record
Live ORACLE: Declaring and Initializing Record Types
Live ORACLE: Declaring and Initializing a Simple Record Type
Live ORACLE: Incompatibility Between Package and Local Collection Types
Live ORACLE: How Invalid Subscripts are Handled With DELETE(n)
Live ORACLE: Collection Exceptions
Live ORACLE: Using the DELETE Method on a Collection
Live ORACLE: Using TRIM on Deleted Elements
Live ORACLE: Using TRIM to Decrease the Size of a Collection
Live ORACLE: Using EXTEND to Increase the Size of a Collection
Live ORACLE: Using NEXT to Access Elements of a Nested Table
Live ORACLE: Using PRIOR and NEXT to Access Collection Elements
Live ORACLE: Using FIRST and LAST With a Collection
Live ORACLE: Checking the Maximum Size of a Collection With LIMIT
Live ORACLE: Counting Collection Elements With COUNT
Live ORACLE: Checking Whether a Collection Element EXISTS
Live ORACLE: Multilevel Associative Array
Live ORACLE: Multilevel Nested Table
Live ORACLE: Multilevel VARRAY
Live ORACLE: Comparing Nested Tables with Set Operators
Live ORACLE: Comparing Two Nested Tables
Live ORACLE: Checking if a Collection Is Null
Live ORACLE: Assigning Values to Tables with Complex Datatypes
Live ORACLE: Assigning Values to VARRAYs with Complex Datatypes
Live ORACLE: Assigning Nested Tables with Set Operators
Live ORACLE: Assigning a Null Value to a Nested Table
Live ORACLE: Datatype Compatibility for Collection Assignment
Live ORACLE: Referencing an Element of an Associative Array
Live ORACLE: Referencing a Nested Table Element
Live ORACLE: Empty Varray Constructor
Live ORACLE: Combining Collection Declaration and Constructor
Live ORACLE: Collection Constructor Including Null Elements
Live ORACLE: Constructor for a Varray
Live ORACLE: Constructor for a Nested Table
Live ORACLE: NOT NULL Constraint on Collection Elements
Live ORACLE: VARRAY of Records
Live ORACLE: Specifying Collection Element Types with %TYPE and %ROWTYPE
Live ORACLE: Calling a Procedure With a Nested Table Parameter
Live ORACLE: Declaring a Procedure Parameter as a Nested Table
Live ORACLE: Declaring Collections with %TYPE
Live ORACLE: Declaring Nested Tables, Varrays, and Associative Arrays
Live ORACLE: Declaring an Associative Array
Live ORACLE: Declaring Collection Types
Live ORACLE: Using NULL as a Placeholder When Creating a Subprogram
Live ORACLE: Using the NULL Statement to Show No Action
Live ORACLE: Using a GOTO Statement to Branch an Enclosing Block
Live ORACLE: Using a NULL Statement to Allow a GOTO to a Label
Live ORACLE: Using a Simple GOTO Statement
Live ORACLE: Using EXIT With a Label in a LOOP
Live ORACLE: Using EXIT in a LOOP
Live ORACLE: Using Labels on Loops for Referencing
Live ORACLE: Using a Label for Referencing Variables Outside a Loop
Live ORACLE: Scope of the LOOP Counter Variable
Live ORACLE: Specifying a LOOP Range at Run Time
Live ORACLE: Changing the Increment of the Counter in a FOR..LOOP Statement
Live ORACLE: Using a Reverse FOR..LOOP Statement
Live ORACLE: Using a Simple FOR..LOOP Statement
Live ORACLE: Using EXIT With Labeled Loops
Live ORACLE: Using an EXIT Statement
Live ORACLE: Using the Searched CASE Statement
Live ORACLE: Using the CASE-WHEN Statement
Live ORACLE: Extended IF-THEN Statement
Live ORACLE: Using the IF-THEN-ELSIF Statement
Live ORACLE: Nested IF Statements
Live ORACLE: Using a Simple IF-THEN-ELSE Statement
Live ORACLE: Using a Simple IF-THEN Statement
Live ORACLE: Using the Function RTRIM
Live ORACLE: Comparing Character Values
Live ORACLE: Implicit Conversion
Live ORACLE: Using SUBTYPE With %TYPE and %ROWTYPE
Live ORACLE: Default Value With Subtypes
Live ORACLE: Constraints Inherited by Subprograms
Live ORACLE: Type Compatibility With the NUMBER Datatype
Live ORACLE: Using Ranges With Subtypes
Live ORACLE: Assigning Literals to an INTERVAL DAY TO SECOND Variable
Live ORACLE: Assigning Literals to an INTERVAL YEAR TO MONTH Variable
Live ORACLE: Assigning a Literal Value to a TIMESTAMP WITH LOCAL TIME ZONE
Live ORACLE: Assigning a Literal to a TIMESTAMP WITH TIME ZONE Variable
Live ORACLE: Using the SCN_TO_TIMESTAMP and TIMESTAMP_TO_SCN Functions
Live ORACLE: Assigning a Literal Value to a TIMESTAMP Variable
Live ORACLE: Using the Function REPLACE
Live ORACLE: Using the Function NVL
Live ORACLE: Using the Function DECODE
Live ORACLE: Using NULLs in Comparisons
Live ORACLE: Using a Search Condition With a CASE Statement
Live ORACLE: Using the WHEN Clause With a CASE Statement
Live ORACLE: Using BOOLEAN Variables in Conditional Tests
Live ORACLE: Using Comparison Operators
Live ORACLE: Short-Circuit Evaluation
Live ORACLE: Assigning a Query Result to a Variable
Live ORACLE: Assigning BOOLEAN Values
Live ORACLE: Initialization of Variables and Constants
Live ORACLE: PL/SQL Block Using Multiple and Duplicate Labels
Live ORACLE: Replace letter from word by number
Live ORACLE: Using Subprogram Qualifier With Identifiers
Live ORACLE: Using a Label Qualifier With Identifiers
Live ORACLE: Scope Rules
Live ORACLE: Using a Subprogram Name for Name Resolution
Live ORACLE: Using a Block Label for Name Resolution
Live ORACLE: Using an Alias for Column Names
Live ORACLE: Assigning Values to a Record With a %ROWTYPE Declaration
Live ORACLE: Using the %ROWTYPE Attribute
Live ORACLE: Using %ROWTYPE With Table Rows
Live ORACLE: Using %TYPE With Table Columns
Live ORACLE: Using %TYPE With the Datatype of a Variable
Live ORACLE: Creating a Database Trigger
Live ORACLE: Techniques for Calling a Standalone Procedure From SQL*Plus
Live ORACLE: Creating a Stored Subprogram
Live ORACLE: Defining an Object Type
Live ORACLE: Declaring a Record Type
Live ORACLE: Using a PL/SQL Collection Type
Live ORACLE: Creating a Package and Package Body
Live ORACLE: Using the GOTO Statement
Live ORACLE: Using the EXIT-WHEN Statement
Live ORACLE: Using WHILE-LOOP for Control
Live ORACLE: Using the FOR-LOOP
Live ORACLE: Using the IF-THEN_ELSE and CASE Statement for Conditional Control
Live ORACLE: Using %ROWTYPE with an Explicit Cursor
Live ORACLE: Processing Query Results in a LOOP
Live ORACLE: Assigning Values to Variables as Parameters of a Subprogram
Live ORACLE: Assigning Values to Variables by SELECTing INTO
Live ORACLE: Assigning Values to Variables With the Assignment Operator
Live ORACLE: Substituting PL/SQL Variables
Live ORACLE: Using NEXT to Access Elements of a Nested Table
Live ORACLE: Using the IF-THEN-ELSIF Statement
Live ORACLE: Assigning Literals to an INTERVAL DAY TO SECOND Variable
03/ 27 pages
Live ORACLE: Using ROLLBACK
Live ORACLE: Using COMMIT With the WRITE Clause
Live ORACLE: Using a Cursor Expression
Live ORACLE: Declaration of Cursor Variables in a Package
Live ORACLE: Fetching from a Cursor Variable into Collections
Live ORACLE: Fetching from a Cursor Variable into a Record
Live ORACLE: Cursor Variable with Different Return Types
Live ORACLE: Stored Procedure to Open Ref Cursors with Different Queries
Live ORACLE: Stored Procedure to Open a Ref Cursor
Live ORACLE: Checking If a Cursor Variable is Open
Live ORACLE: Passing a REF CURSOR as a Parameter
Live ORACLE: Passing Parameters to Explicit Cursors
Live ORACLE: Passing Parameters to a Cursor FOR Loop
Live ORACLE: Using a Correlated Subquery
Live ORACLE: Using a Subquery in a FROM Clause
Live ORACLE: Using a Subquery in a Cursor
Live ORACLE: Using an Alias For Expressions in a Query
Live ORACLE: Using %ROWCOUNT
Live ORACLE: Using %NOTFOUND
Live ORACLE: Using %ISOPEN
Live ORACLE: Using %FOUND
Live ORACLE: Fetching Bulk Data With a Cursor
Live ORACLE: Fetching the Same Cursor Into Different Variables
Live ORACLE: Referencing PL/SQL Variables Within Its Scope
Live ORACLE: Fetching With a Cursor
Live ORACLE: Using SQL%ROWCOUNT
Live ORACLE: Using SQL%FOUND
04/ 2 pages
Live ORACLE: The day when most of employees were Hired
Live ORACLE: Oracle Magazine - May/June 2009
05/ 35 pages
Live ORACLE: The Employee's Period by years and months
Live ORACLE: Know the Current USER of your Session by SQL Statement
Live ORACLE: Aliasing from Passing Global Variable with NOCOPY Hint
Live ORACLE: Specifying Invoker's Rights With a Procedure
Live ORACLE: Resolving PL/SQL Functions With Inheritance
Live ORACLE: Resolving PL/SQL Procedure Names
Live ORACLE: Overloading a Subprogram Name
Live ORACLE: Procedure with Default Parameter Values
Live ORACLE: Using the OUT Mode
Live ORACLE: Subprogram Calls Using Positional, Named, and Mixed Notation
Live ORACLE: Formal Parameters and Actual Parameters
Live ORACLE: Forward Declaration for a Nested Subprogram
Live ORACLE: Simple PL/SQL Function
Live ORACLE: Simple PL/SQL Procedure
Live ORACLE: Dynamic SQL Fetching into a Record
Live ORACLE: Accessing %ROWCOUNT For an Explicit Cursor
Live ORACLE: Using Duplicate Placeholders With Dynamic SQL
Live ORACLE: Oracle Forms Tutorial (www.aboutoracleapps.com)
Live ORACLE: Dynamic SQL Inside FORALL Statement
Live ORACLE: Dynamic SQL with RETURNING BULK COLLECT INTO Clause
Live ORACLE: Dynamic SQL with BULK COLLECT INTO Clause
Live ORACLE: Dynamic SQL Procedure that Accepts Table Name and WHERE Clause
Live ORACLE: Calling an Autonomous Function
Live ORACLE: Using Autonomous Triggers
Live ORACLE: Declaring an Autonomous Trigger
Live ORACLE: Declaring an Autonomous PL/SQL Block
Live ORACLE: Declaring an Autonomous Standalone Procedure
Live ORACLE: Declaring an Autonomous Function in a Package
Live ORACLE: Using %ROWTYPE with Cursors reference ROWID
Live ORACLE: Fetching Across COMMITs Using ROWID
Live ORACLE: Fetching Across Commits
Live ORACLE: Using CURRENT OF to Update the Latest Row Fetched From a Cursor
Live ORACLE: Using SET TRANSACTION to Begin a Read-only Transaction
Live ORACLE: Reusing a SAVEPOINT With ROLLBACK
Live ORACLE: Using SAVEPOINT With ROLLBACK
06/ 3 pages
Live ORACLE: Oracle Reports Online Help (Help Contents)
Live ORACLE: Oracle Forms Online Help
Live ORACLE: Oracle Magazine - July/August 2009
07/ 2 pages
Live ORACLE: Delete Value from LOV after selecting it
Live ORACLE: Delete Value from LOV after selecting it
09/ 1 pages
Live ORACLE: Oracle Magazine - September/October 2009
10/ 7 pages
Live ORACLE: Creating the emp_admin Package
Live ORACLE: Matching Package Specifications and Bodies
Live ORACLE: A Simple Package Specification Without a Body
Live ORACLE: Aliasing from Assigning Cursor Variables to Same Work Area
Live ORACLE: Aliasing Passing Same Parameter Multiple Times
Live ORACLE: SCROLL_VIEW Built-in
Live ORACLE: November/December 2009
11/ 47 pages
Live ORACLE: Using DEREF in a SELECT INTO Statement
Live ORACLE: Updating Rows in an Object Table With a REF Modifier
Live ORACLE: Updating and Deleting Rows in an Object Table
Live ORACLE: Inserting Rows in an Object Table
Live ORACLE: Accessing Object Attributes
Live ORACLE: Null Objects in a PL/SQL Block
Live ORACLE: Declaring Object Types in a PL/SQL Block
Live ORACLE: Site Map
Live ORACLE: Working With Object Types
Live ORACLE: Using a Pipelined Table Function as an Aggregate Function
Live ORACLE: Using Multiple REF CURSOR Input Variables
Live ORACLE: Using a Pipelined Table Function For a Transformation
Live ORACLE: Assigning the Result of a Table Function
Live ORACLE: Checking for PLSQL Compilation Type
Live ORACLE: Using NOCOPY With Parameters
Live ORACLE: SET_CANVAS_PROPERTY Built-in
Live ORACLE: Using FORALL With BULK COLLECT
Live ORACLE: Using BULK COLLECT With the RETURNING INTO Clause
Live ORACLE: Using LIMIT to Control the Number of Rows In a BULK COLLECT
Live ORACLE: Bulk-Fetching from a Cursor Into a Collection of Records
Live ORACLE: Bulk-Fetching from a Cursor Into One or More Collections
Live ORACLE: Using the Pseudocolumn ROWNUM to Limit Query Results
Live ORACLE: Retrieving Query Results With BULK COLLECT
Live ORACLE: Bulk Operation That Continues Despite Exceptions
Live ORACLE: Counting Rows Affected by FORALL With %BULK_ROWCOUNT
Live ORACLE: Using %BULK_ROWCOUNT With the FORALL Statement
Live ORACLE: Using Rollbacks With FORALL
Live ORACLE: Using FORALL with Non-Consecutive Index Values
Live ORACLE: Using FORALL with Part of a Collection
Live ORACLE: Issuing DELETE Statements in a Loop
Live ORACLE: Nesting a Query to Improve Performance
Live ORACLE: Using the DBMS_WARNING Package to Display Warnings
Live ORACLE: Controlling the Display of PL/SQL Warnings
Live ORACLE: Using a Locator Variable to Identify the Location of an Exception
Live ORACLE: Retrying a Transaction After an Exception
Live ORACLE: Continuing after an Exception Is Raised
Live ORACLE: Displaying SQLCODE and SQLERRM
Live ORACLE: How PL/SQL Exceptions Propagate
Live ORACLE: Reraising a PL/SQL Exception
Live ORACLE: Scope of an Exception
Live ORACLE: Using RAISE to Force a Pre-Defined Exception
Live ORACLE: Using RAISE to Force a User-Defined Exception
Live ORACLE: Raising an Application Error With raise_application_error
Live ORACLE: Scope of PL/SQL Exceptions
Live ORACLE: Managing Multiple Errors With a Single Exception Handler
Live ORACLE: Runtime Error Handling
Live ORACLE: Using PUT_LINE in the DBMS_OUTPUT Package




Share/Save/Bookmark

0 comments:

Post a Comment



Newer Posts Older Posts Home Page
 
http://www.dpriver.com/images/sqlpp-banner-2.png

Thanks for reading my Blog ... you Visitor Number :-