Oracle query an account with multiple users, now to query all below it conform to a field two states (1 and 9) user; Be urgent!!!!!!

CodePudding user response:

Where a field in (1, 9)
And account='XXX'

CodePudding user response:

Now, don't know is which account to find qualified from the database

CodePudding user response:

SELECT a user FROM account table WHERE a certain fields IN (1, 9) AND user='* * *';

CodePudding user response:

Write a stored procedure, iterate through all the tables and all of the fields,,, have a large table can't must be slow