New answers tagged unix
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
Related Tags
unix × 42oracle × 12
postgresql × 8
mysql × 7
linux × 6
scripting × 6
performance × 3
oracle-11g-r2 × 3
db2 × 3
permissions × 2
timestamp × 2
sqlplus × 2
sybase × 2
db2-luw × 2
max-connections × 2
sql-server × 1
query-performance × 1
mongodb × 1
security × 1
oracle-11g × 1
view × 1
performance-tuning × 1
sqlite × 1
aws × 1
nosql × 1