Results 1 to 5 of 5

Thread: SQL History

  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: SQL History

    Trying to find the SQL stmt to view previously executed SQL statements? Could someone please help? I tried several searches which came up with nothing.

    Thanks,
    Chuck

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    It depends upon which User Interface tool you are using to actually invoke the SQL.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2003
    Posts
    1,074
    Cold Fusion

  4. #4
    Join Date
    Apr 2004
    Posts
    246
    select * from v$sql
    -- all previously executed statements which have not been aged out of the sga yet

  5. #5
    Join Date
    Dec 2003
    Posts
    1,074
    Would this include only executed statements, or all those submitted?

    I'm looking for a statement which errors out when submitted from Cold Fusion, but executes if the stmt is cut & pasted into SQL Plus.

    Thanks,
    Chuck

Posting Permissions

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