Results 1 to 3 of 3

Thread: sp_executesql

  1. #1
    Join Date
    Jul 2004
    Posts
    34

    Unanswered: sp_executesql

    hi everybody
    How can we execute a string of sql statements in Oracle ,similar to sp_executesql in sql server.
    ie a string can contain insert into a table statement,delete a row from a table statement, update etc.
    Thanks all of You

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I think you'd have more luck in an Oracle forum...

    Maybe

    http:\\www.OracleTeam.com
    Last edited by Brett Kaiser; 09-03-04 at 15:23.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Oh....and look up

    EXECUTE IMMEDIATE

    and DBMS_SQL
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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