ANSI Compliance checking in Oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ANSI Compliance checking in Oracle

  1. #1
    Join Date
    Aug 2002
    Posts
    3

    ANSI Compliance checking in Oracle

    Hi,
    I need to check my developer's sql statements are whether belongs to ANSI standard or not.Flagger attribute in sql*plus provides the same.But developers are connecting thro JDBC,so i want to set that check at database level.Whenever developer violating ANSI standard,db has to give warning message to them,that's requirement.Please help to achieve this.Thanks in advance.

    Regards,
    msv_krishn

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    How about using ...

    ALTER SESSION SET FLAGGER = ON

    ... in your code.

    Check this out..
    http://download-west.oracle.com/docs...h8.htm#1002090

    http://download-west.oracle.com/docs...18.htm#2053134

    HTH.

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