export problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: export problem

  1. #1
    Join Date
    Oct 2000
    Posts
    90

    Lightbulb

    Hi people,
    I have a table called mech_engine which has the following columns, due_date, start_date, ref_date, end_date. I want to take an export of that table where the start_date is between 08/18 and 12/1.
    Can any one please tell me how to do that?

    regards,
    dorothy

  2. #2
    Join Date
    Jun 2000
    Location
    Santa Clara, CA, USA
    Posts
    12

    Cool

    Hey Dorothy,

    First of all I do not know which DB version you are using. If you have 8i as a DB then you can just use QUERY clause to export data, only specific to your query .

    Naresh

  3. #3
    Join Date
    Oct 2000
    Posts
    90
    I am running Oracle 8i(8.1.5) on unix

  4. #4
    Join Date
    Jun 2000
    Location
    Santa Clara, CA, USA
    Posts
    12
    just use QUERY clause.

  5. #5
    Join Date
    Nov 2000
    Posts
    169

    Arrow

    can any one show the example using the querry clause assuming the export is to be taken from the mech_engine table as described, so that I can also see how it's done?

    [Edited by learn on 12-02-2000 at 11:27 AM]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width