Wednesday 3 December 2014

Get insert query from selected data in toad?





Hi,
    Now am here to tell about insert script generation from toad software. here is the steps ...


Step 1 : Write your query in editor window.





Step 2 : Click select all button in script output.














Step 3 : Right click on grid header and click Export Dataset.






















Step 4 : Select export format as Insert statement. Add output path with name. Also provide table name








































Step 5 : Click Ok button . You can get your insert statement from the path you specified.


Thank you. happy coding  :)

No comments:

Post a Comment