{"id":18185,"date":"2024-03-15T16:24:49","date_gmt":"2024-03-15T16:24:49","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/"},"modified":"2024-03-21T12:42:19","modified_gmt":"2024-03-21T12:42:19","slug":"how-can-oracle-apex-obtain-url-parameters","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/","title":{"rendered":"How can Oracle Apex obtain URL parameters?"},"content":{"rendered":"<p>In Oracle Apex, you can use the APEX_UTIL.GET_URL_PARAMETER function to retrieve URL parameters.<\/p>\n<p>The following is an example demonstrating how to retrieve the URL parameter &#8220;p_id&#8221;.<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">DECLARE<\/span>\r\n  l_id NUMBER;\r\n<span class=\"hljs-keyword\">BEGIN<\/span>\r\n  l_id :<span class=\"hljs-operator\">=<\/span> APEX_UTIL.GET_URL_PARAMETER(<span class=\"hljs-string\">'p_id'<\/span>);\r\n  <span class=\"hljs-comment\">-- \u5728\u6b64\u5904\u53ef\u4ee5\u4f7f\u7528l_id\u8fdb\u884c\u540e\u7eed\u5904\u7406<\/span>\r\n<span class=\"hljs-keyword\">END<\/span>;\r\n<\/code><\/pre>\n<p>In this example, the GET_URL_PARAMETER function will retrieve the value of the parameter named &#8220;p_id&#8221; in the URL and assign it to the l_id variable.<\/p>\n<p>Please note that the GET_URL_PARAMETER function can only be used to retrieve URL parameters during page load. If you need to retrieve URL parameters in other parts of the page or through other means, you can use the APEX_APPLICATION.G_F01 to G_F50 collection to retrieve the parameters. For example, you can use the following code to retrieve a URL parameter named &#8220;p_id&#8221;:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">DECLARE<\/span>\r\n  l_id NUMBER;\r\n<span class=\"hljs-keyword\">BEGIN<\/span>\r\n  l_id :<span class=\"hljs-operator\">=<\/span> APEX_APPLICATION.G_F01;\r\n  <span class=\"hljs-comment\">-- \u5728\u6b64\u5904\u53ef\u4ee5\u4f7f\u7528l_id\u8fdb\u884c\u540e\u7eed\u5904\u7406<\/span>\r\n<span class=\"hljs-keyword\">END<\/span>;\r\n<\/code><\/pre>\n<p>In this example, the G_F01 collection corresponds to the values of the URL parameters. It is important to note that the G_F01 to G_F50 collections are all of type VARCHAR2, so if the URL parameters are numerical, a type conversion is necessary.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Oracle Apex, you can use the APEX_UTIL.GET_URL_PARAMETER function to retrieve URL parameters. The following is an example demonstrating how to retrieve the URL parameter &#8220;p_id&#8221;. DECLARE l_id NUMBER; BEGIN l_id := APEX_UTIL.GET_URL_PARAMETER(&#8216;p_id&#8217;); &#8212; \u5728\u6b64\u5904\u53ef\u4ee5\u4f7f\u7528l_id\u8fdb\u884c\u540e\u7eed\u5904\u7406 END; In this example, the GET_URL_PARAMETER function will retrieve the value of the parameter named &#8220;p_id&#8221; in the URL and [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-18185","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can Oracle Apex obtain URL parameters? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can Oracle Apex obtain URL parameters?\" \/>\n<meta property=\"og:description\" content=\"In Oracle Apex, you can use the APEX_UTIL.GET_URL_PARAMETER function to retrieve URL parameters. The following is an example demonstrating how to retrieve the URL parameter &#8220;p_id&#8221;. DECLARE l_id NUMBER; BEGIN l_id := APEX_UTIL.GET_URL_PARAMETER(&#039;p_id&#039;); -- \u5728\u6b64\u5904\u53ef\u4ee5\u4f7f\u7528l_id\u8fdb\u884c\u540e\u7eed\u5904\u7406 END; In this example, the GET_URL_PARAMETER function will retrieve the value of the parameter named &#8220;p_id&#8221; in the URL and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T16:24:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T12:42:19+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"How can Oracle Apex obtain URL parameters?\",\"datePublished\":\"2024-03-15T16:24:49+00:00\",\"dateModified\":\"2024-03-21T12:42:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/\"},\"wordCount\":180,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/\",\"name\":\"How can Oracle Apex obtain URL parameters? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T16:24:49+00:00\",\"dateModified\":\"2024-03-21T12:42:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can Oracle Apex obtain URL parameters?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can Oracle Apex obtain URL parameters? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/","og_locale":"en_US","og_type":"article","og_title":"How can Oracle Apex obtain URL parameters?","og_description":"In Oracle Apex, you can use the APEX_UTIL.GET_URL_PARAMETER function to retrieve URL parameters. The following is an example demonstrating how to retrieve the URL parameter &#8220;p_id&#8221;. DECLARE l_id NUMBER; BEGIN l_id := APEX_UTIL.GET_URL_PARAMETER('p_id'); -- \u5728\u6b64\u5904\u53ef\u4ee5\u4f7f\u7528l_id\u8fdb\u884c\u540e\u7eed\u5904\u7406 END; In this example, the GET_URL_PARAMETER function will retrieve the value of the parameter named &#8220;p_id&#8221; in the URL and [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T16:24:49+00:00","article_modified_time":"2024-03-21T12:42:19+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"How can Oracle Apex obtain URL parameters?","datePublished":"2024-03-15T16:24:49+00:00","dateModified":"2024-03-21T12:42:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/"},"wordCount":180,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/","name":"How can Oracle Apex obtain URL parameters? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T16:24:49+00:00","dateModified":"2024-03-21T12:42:19+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-oracle-apex-obtain-url-parameters\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can Oracle Apex obtain URL parameters?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=18185"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18185\/revisions"}],"predecessor-version":[{"id":51848,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18185\/revisions\/51848"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=18185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=18185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=18185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}