Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
SET FEEDBACK OFF SET SERVEROUTPUT ON SIZE UNLIMITED FORMAT WRAPPED SET LINESIZE 32767 SET DEFINE OFF SET TRIMOUT ON SET HEADING OFF SELECT BUF FROM ( SELECT ROWNUM SEQ, t.BUF FROM ( SELECT 'Data^B' || REPLACE(UPPER(ttttt), '"') || '^B' || REPLACE(aaaaa, '"') || '^B' || REPLACE(bbbbb, '"')|| '^B' || REPLACE(ccccc, '"')|| '^B' || REPLACE(ddddd, '"')|| '^B' || REPLACE(eeeee, '"')|| '^B' || USECOUNT BUF FROM NAME WHERE aaaaa LIKE '$a%' AND bbbbb LIKE '$b%' AND ccccc LIKE '$c%' AND eeeee LIKE '$d%' AND fffff = 'dd' ORDER BY USECOUNT DESC ) t WHERE ROWNUM < $RLIMIT ) s WHERE s.SEQ >= $PSTART;
|Ways to write the SQL||6||53|
|CRM Solution Specifically Designed for Non Profit Organisation||7||73|
|consolidate 4 lines of oracle query output to 1 line||4||24|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!