SELECT '["' ||
Max(LONGDESCRIPTIONID) || '"],' /*, COUNT(*)*/
FROM ( SELECT LONGDESCRIPTIONID,
NTILE(30) OVER (ORDER BY LONGDESCRIPTIONID) AS nt FROM MAXIMO.LONGDESCRIPTION )
AS subquery
GROUP BY nt
ORDER BY nt;
Dream Always Dream , if you don't work on it : Real-world Oracle DBA troubleshooting guides for RAC, Data Guard, RMAN, performance tuning, upgrades, backups, and cloud migration. Tested in production environments.
Client → TNS Resolution → Network → Listener → Database Service → Database Instance Common Oracle TNS Listener Errors Error Code Error Messa...
save my life , thank you very much
ReplyDelete