• Oracle Database RSS Feed

    by
    kiran.marla
    Published on 02-26-2010 04:47 AM  Number of Views: 915 

    Working Around Mutating Table error with views 


    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 ...
    Read More Read More 5 Comments
    by
    comm_elect
    Published on 12-23-2009 12:28 AM  Number of Views: 726 

    Nested Tables and Varrays (From MetaLink) 


    Nested Tables and Varrays [ID 61745.1]

    --------------------------------------------------------------------------------

    Modified 28-MAY-2009 Type BULLETIN Status PUBLISHED


    Checked for relevance on 28-May-2009

    ...
    Read More Read More 2 Comments
    by
    sabyasachi
    Published on 10-12-2009 09:16 AM  Number of Views: 686 

    We Can Import any text data file into a oracle table 


    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 ...
    Read More Read More 1 Comment
    by
    sabyasachi
    Published on 10-09-2009 09:04 AM  Number of Views: 375 

    Sql tuning 


    USE EXISTS IN PLACE OF DISTINCT
    visit for more information "allmyneed.blogspot . com"

    The DISTINCT combination of deptno and dname columns have to be displayed. Only those rows need be displayed, whose deptno exists in the EMP table.

    Query 1
    Code sql:
    SELECT
    ...
    Read More Read More 1 Comment
    by
    salmankhalid
    Published on 08-03-2009 12:29 AM  Number of Views: 219 

    JAVA class files in oracle PLSQL 


    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"); 
}
    ...
    Read More Read More 1 Comment
    by
    tyro
    Published on 05-26-2009 12:31 PM  Number of Views: 2567 

    Oracle Date Functions 


    Oracle Date Functions

    I wanted to compile a list of all possible DATE functions in oracle. I am listing a few common ones to begin with, and I look forward to other members adding to this list.
    • SESSIONTIMEZONE
    • NLS_DATE_FORMAT
    • TO_DATE
    • TO_CHAR
    • SYSDATE and CURRENT_DATE
    • +/-
    • ADD_MONTHS
    • INTERVAL
    • LAST_DAY
    • MONTHS_BETWEEN
    • TRUNC
    ...
    Read More Read More 1 Comment
    by
    UnixGuru
    Published on 05-04-2009 08:26 AM  Number of Views: 743 

    Monitoring of Flashback Database with Data Dictionary Views 


    Monitoring of Flashback Database with Data Dictionary Views
    • V$FLASHBACK_DATABASE_LOG, GV$FLASHBACK_DATABASE_LOG (for RAC) - displays information about the flashback data. Use this view to help estimate the amount of flashback space required for the current workload.
    • V$FLASHBACK_DATABASE_STAT,
    ...
    Read More Read More
    by
    tyro
    Published on 05-02-2009 11:55 AM  Number of Views: 790 

    SQL*Plus Introduction 


    SQL Plus is the de facto tool to manipulate sql code for the Oracle Database. SQL Plus was initially known as UFI for User Friendly Interface which shipped with Oracle Database upto Oracle Version 4. The next version was Advanced UFI which finally gave way to SQL*Plus as we know today.

    ...
    Read More Read More 2 Comments
    by
    tyro
    Published on 04-18-2009 09:37 AM  Number of Views: 533 

    How to exclude locked rows when selecting from a table 


    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 ...
    Read More Read More 7 Comments
    by
    orafan
    Published on 04-18-2009 09:20 AM  Number of Views: 1115 

    How to Convert from Oracle Standard Edition to Enterprise Edition 


    Recently I needed to change a standard edition database to Enterprise Edition. Here are the steps I followed from documentation

    Since the same "SQL.BSQ" script is used to create the database for each version, the databases are internally almost identical. The conversion process ...
    Read More Read More