Dear community,
I have to make a "simple" query on ORACLE 11g DB who will output ONLY numbers in field1 who exceeded a specific threshold.
In other words, assuming I have the following data in database.
I want to output only number in field1 with occurrences >= 3, so the query output will be:
Doesn't matter the output order, the important thing is that only occurrences >= 3 based on FIELD1.
Now, this works perfect on MySQL:
But on ORACLE 11g I got:
Please help!
Thanks
Lucas
Well, first of all thanks for reply, this is a very interesting approach, totally new for me.
Anyway, I got the following error:
Maybe due to a large ammount of data in DB?
Well, first of all thanks for reply, this is a very interesting approach, totally new for me.
Anyway, I got the following error:
Maybe due to a large ammount of data in DB?
Increase the size of your TEMP tablespace - it's not big enough ..
I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'.
I've tried the following with no success.
su - oracle -c "<< EOF1
sqlplus -s "/ as sysdba" << EOF2
whenever sqlerror exit sql.sqlcode;... (2 Replies)