I had to do a small update on a site for work with an Oracle back end.\u00a0 I don’t work with Oracle so I ran into a little snag.\u00a0 I needed to find the Oracle equivalent of SQL Server’s “SELECT TOP”.\u00a0 So, here it is:<\/p>\n
MS SQL<\/strong> ORACLE<\/strong> I had to do a small update on a site for work with an Oracle back end.\u00a0 I don’t work with Oracle so I ran into a little snag.\u00a0 I needed to find the Oracle equivalent of SQL Server’s “SELECT TOP”.\u00a0 So, here it is: MS SQL SELECT TOP 10 field1, field2 FROM tablename ORDER … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_cloudinary_featured_overwrite":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[68],"tags":[29,16],"class_list":["post-288","post","type-post","status-publish","format-standard","hentry","category-developer","tag-oracle","tag-sql"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/pbVg43-4E","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/posts\/288","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/comments?post=288"}],"version-history":[{"count":0,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/posts\/288\/revisions"}],"wp:attachment":[{"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/media?parent=288"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/categories?post=288"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/csimmons.dev\/blog\/wp-json\/wp\/v2\/tags?post=288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\nSELECT TOP 10
\nfield1, field2
\nFROM
\ntablename
\nORDER BY
\nfield1
\n<\/code><\/p>\n
\n
\nSELECT *
\nFROM
\n(SELECT
\nfield1, field2
\nFROM
\ntablename
\nORDER BY field1)
\nWHERE
\nROWNUM <= 10
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"