Results 1 to 2 of 2

Thread: Tips of the Day

  1. #1
    Contributing Member
    Join Date
    Nov 2007
    Answers
    53

    Tips of the Day

    Dear Team,

    Good Morning

    Display Database version, installed options and port string

    select banner
    from sys.v_$version;


    select ' With the '||parameter||' option'
    from sys.v_$option
    where value = 'TRUE';


    select ' The '||parameter||' option is not installed'
    from sys.v_$option
    where value <> 'TRUE';



  2. #2
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Tips of the Day

    The SQL*Plus COPY command can copy data between two databases via SQL*Net. The preferred method of doing this is to use SQL*Plus on the host where the database resides. If performing the copy command from a client SQL*Net connection, the data is transferred through the client machine.
    The copy command copies data from one Oracle instance to another. The data is simply copied directly from a source to a target. The format of the copy command is:

    COPY FROM database TO database action -
    destination_table (column_name, column_name...) USING query

    The action can include:

    create – If the destination table already exists, copy will report an error, otherwise the table is created and the data is copied.

    replace – If the destination table exists, copy will drop and recreate the table with the newly copied data. Otherwise, it will create the table and populate it with the data.

    insert – If the destination table exists, copy inserts the new rows into the table. Otherwise, copy reports an error and aborts.

    append– Inserts the data into the table if it exists, otherwise it will create the table and then insert the data.

    SQL> copy from scott/tiger@ORCL92 -
    to scott/tiger@ORCL92-
    create new_emp –
    using select * from emp;


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact