We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
THE ABOVE RETURNS A FEW HUNDRED MORE ROWS THAN THE BELOW
SELECT COUNT(*) FROM table a WHERE type = '102' OR type = '103' AND SEQ = '1' --current row of data, if desired AND STATUS = 'A' --active ('I' = inactive), if desired
SELECT COUNT(*) FROM TABLE A WHERE TYPE IN ('102','103') AND SEQ = '1' --current row of data, if desired AND STATUS = 'A' --active ('I' = inactive), if desired
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|ORA-00972: identifier is too long from Unix but not from Windows in SQLPLUS||17||108|
|Retreiving column names in Windows but not in Unix||11||75|
|Oracle DB monitor SW||21||72|
|Oracle Function Based Index and Non-Function Based Index on Same Column||36||18|