New answers tagged

0

The dba group name is registered in the oracle binary and can be verified using grep SS_DBA_GRP $ORACLE_HOME/rdbms/lib/config.c Members of this local defined group are normally dba's can connect locally to the database using os authentication and use their sysdba role doing so. This prevents having to work using the software owner's account(often "...


0

As Akina mentioned in the comments, if there's only 4 records total, and you want the top 2, and you're already ordering how you'd want them then you just need to add the LIMIT clause to your query like so: SELECT a.dbsnum, b.chknum, a.name, b.fname FROM sysdbspaces a, syschunks b where a.dbsnum = b.dbsnum GROUP BY 1,2,3,4 ORDER BY 1,2 LIMIT 2; The above is ...


0

select * from (SELECT row_number() over (partition by 1,2,3,4 order by 1,2) as RowNo, a.dbsnum, b.chknum, a.name, b.fname FROM sysdbspaces a, syschunks b where a.dbsnum = b.dbsnum GROUP BY 1,2,3,4) as innerSelect where RowNo <=2


Top 50 recent answers are included