Results 1 to 3 of 3

Oracle Inbuild function to create INSERT script ?

This is a discussion on Oracle Inbuild function to create INSERT script ? within the Databases forums, part of the category; Hi, i need a function in which i ll pass (table_name,col_wanted,col_unwanted) and this function will create a insert scripts for that tables having columns which is passed as col_wanted for ...

  1. #1
    Junior Member
    Join Date
    Feb 2007
    Answers
    17

    Oracle Inbuild function to create INSERT script ?

    Hi, i need a function in which i ll pass (table_name,col_wanted,col_unwanted) and this function will create a insert scripts for that tables having columns which is passed as col_wanted for all data which is available in table . Is there any oracle inbuild function which wll create insert scripts for that table and for that data. Waititng


  2. #2
    Expert Member
    Join Date
    Dec 2006
    Answers
    204

    Re: Oracle Inbuild function to create INSERT script ?

    I don't think Oracle is having an inbuild function for this. But you can easily do this using TOAD. (This is a quest software available for Oracle.)
    Open a Scheme browser in TOAD and choose the table and go to Data tab. there right click and choose create insert for all rows. In the dialogue box opened, you can give the row and column constraints.


  3. #3
    Moderator
    Join Date
    Jun 2007
    Answers
    2,075

    Re: Oracle Inbuild function to create INSERT script ?

    There is no inbuilt function available in oracle. You third party tools as already suggested by our valuable member or try to write your own function for the purpose.


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

SEO by vBSEO 3.6.0 ©2011, Crawlability, Inc.