procedure creates insert statements
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: procedure creates insert statements

  1. #1
    Join Date
    Mar 2001
    Posts
    5
    Hello Sir

    How R u I am Fine With My Health and Grat Oracle DBA Job i need Help From U sir I want Script From U

    That Is procedure Take value user(table name ) that is i have some tables ok tables have rows ok ,
    i want out put from the that procedure is if the table have the 100 rows ok that should create or
    out put should be 100 insert statement all actual values from what table name i have submitted so
    i want script because our clients dont knows the sql loader and exp imp utilities they are technically
    not that much sound so i will spool the whatever out from this script i will send them they can run this
    script ok and another thing is condition is the we have to avoid bad characters like &, ' etc
    single code and ampersant and pls send script to me i am tryinfg here



    Yours Site team Member

    Email:rkodag@yahoo.com
    Rakesh
    Oracle DBA

  2. #2
    Join Date
    Mar 2001
    Posts
    17

    Cool

    Hi rakesh,

    You can use dynamic SQL to accomplish your task. But still i am not clear what exactly you want.

    Kancha

  3. #3
    Join Date
    Feb 2001
    Posts
    184
    Hi I would suggest you to Download any third part tool and can have as many scripts as you want for all your need.

    It's very hard to have that kind of Script. Use any third part tool and then easy to have like
    Insert into Emp (Id, name,....)
    Values(100,'Name',.....)...

    Easy way.

    Try This
    [url]http://www.quest.com[/url] Get SQL Navigator, or TOAD.. Good Tools
    Thanks

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