Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: sql question:
In article <0N1Y8.89801$Bt1.4501707_at_bin5.nnrp.aus1.giganews.com>, "Chris says...
>
>hi all:
>
>I'm trying to figure out SQL to do the following:
>I have an application that tracks SQL that is being sent to the database,
>and one of it's features is the ability to identify whether a query is an
>insert, update, delete, select, select with all rows returned, the query is
>the first in a user session....and many other criteria. Because of the
>nature of SQL, i.e. many of the above could be true, the deisgners made each
>flag a 'bit'. So an example is:
>4 is a select
>8 is insert
>16 is update
>32 is first query in session
>64 is delete
>128 is a cancelled query
>256 is database cancelled query
>
>
where bitand( flag_column, 64 ) = 64
will get them.
>
>Now the SQL that I have to find is 'which of these records is a delete?'
>The values could be 64, 96, 416, 445, 320 and many others. All in all
>there are probably 20 possible values and the permutations are to lengthy to
>put in a 'like', so I need some kind of algorithm. Does anyone have any
>ideas?
>
>email:
>caiell02_at_comcast.net
>
>thanks, Chris
>
>
-- Thomas Kyte (tkyte@oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Sat Jul 13 2002 - 17:45:32 CDT
![]() |
![]() |