Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
(snippet)... TYPE counted_assets IS RECORD (asset_filename varchar2(64)); counted_assets_record counted_assets; proceed:='Y'; FOR counted_assets_record IN counted_assets LOOP IF (SUBSTR(bookpagekey_record.file_name, 1, 7) = SUBSTR(counted_assets_record.asset_filename, 1, 7)) AND (bookpagekey_record.content_category LIKE '%Primary Image%') THEN proceed:='N'; END IF; END LOOP;
|Oracle 10g - Count Rows excluding 0's||4||47|
|Move index to different tablespace in oracle||7||48|
|Format Number Field||10||34|
|consolidate 4 lines of oracle query output to 1 line||4||25|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!