Oracle Developer Examples, Tutorials and Articles

Lexical Parameter and Bind Variable in Oracle Reports

Published by

Lexical parameter

These are used to replace a value dynamically at run time. Lexical parameters can dynamically replace clauses in the Select statement in the data model and even the whole select statement. It replaces any part of a SELECT statement, such as column names, the FROM clause, ...

Working Around Mutating Table error with views

Published by

kiran.marla

WORKING AROUND MUTATING TABLE ERROR USING VIEW

Code sql:

SQL> CREATE TABLE STUD(RNO NUMBER(5), SNAME VARCHAR2(20), M1 NUMBER(4), M2   NUMBER(4),
               M3 NUMBER(4), TOT NUMBER(7), AVGG NUMBER(5,2));

Table created.

I created a table stud ...

5 Comments

We Can Import any text data file into a oracle table

Published by

sabyasachi

To Import Text formated data into oracle table we have to create a table and a control file according to the text file.
textfile:-
10001 20056 12122009
10002 20036 12112009
10002 20236 12122009
10002 20776 12112009
10002 20346 12112008

Rename ...

1 Comment

Oracle Forms Triggers On Different Levels

Published by

sabyasachi

Block Processing Triggers:

When-Create-Record: Perform an action whenever Form Builder attempts to create a new record in a block. For example, to set complex, calculated, or data-driven default values that must be specified at runtime, rather than design time.

When-Clear-Block: ...

1 Comment

How to migrate oracle forms10g to ADF/JAVA Application?

Published by

salmankhalid

Oracle JHeadstart 11g for ADF

Oracle JHeadstart 11g for ADF dramatically improves developer's productivity for the Oracle Application Development Framework (ADF). It allows IT organizations to rapidly introduce Java EE, without the need for a team of JEE gurus to build ...

4 Comments

To find Expression Names in Discoverer Reports

Published by

malli_18arjun

To find Expression Names in Discoverer Reports

By using this query ,Expressions defined for object can be queried

Code sql:

SELECT   a.exp_name, b.obj_name, a.exp_formula1, c.fun_name
    FROM eul4_us.eul4_expressions a JOIN eul4_us.eul4_objs b
         ON b.obj_id

...

JAVA class files in oracle PLSQL

Published by

salmankhalid

We can use the JAVA class file in our PLSQL code
Follow the steps.

1 - Make a java class

For example:

Code :

Public class SimpleJava {
public void main(String[] args) {
System.out.println("Here we are"); 
}

...

1 Comment

Details of Discoverer Report by sql query

Published by

malli_18arjun

By using the following query ,we can get the following details of Discoverer Reports

creation date
shared responsibity or owner
user name
shared name /responsibility

Code sql:

SELECT DISTINCT disco_docs.doc_name "Discoverer Workbook",
                TRUNC (disco_docs.doc_created_date)

...

6 Comments

How to exclude locked rows when selecting from a table

Published by

tyro

Many a times we face a situation wherein a particular row or rows from a table are locked by some application/users and it causes our queries to not run if our query also requires the row to be locked. So here is a function which will exclude the rowids of those rows which are locked when used within ...

7 Comments

Understanding Latches in Oracle

Published by

simply_dba

One of most imortant structures of Oracle Architectures is the Oracle Latching mechanism. from my experiance I have seen that a major portion of Oracle Performance tuning revolves round the latching mechanism of Oracle. In this article I will try explain this mechanism.
Types of Locks
...

5 Comments

Oracle Developer Examples, Tutorials and Articles

Article Categories