Category Archives: Oracle
Getting Session Environment Parameters in Oracle
To display all environment variable values for a given oracle session, run the following code: begin FOR i IN 1..owa.num_cgi_vars LOOP htp.p(owa.cgi_var_name(i)||’ : ‘||owa.cgi_var_val(i)); END LOOP; end; The name of the environment variable and value will be displayed. To reference … Continue reading
Oracle ApEx Request That Will Submit Requested Page Though Link
There is a very useful Oracle ApEx REQUEST constant called BRANCH_TO_PAGE_ACCEPT. If included in a URL, the request will process the page as if it was submitted. Now think about this for a minute because this is a useful tool … Continue reading
Loading a File Into a BLOB Object in Oracle
Loading a file into a BLOB object in Oracle is easy. All we need to do is use the DBMS_LOB package to load the file into a temporary LOB object. This is demonstrated in the following example. This example assumes … Continue reading
Oracle VARCHAR2(1) vs CHAR(1)?
Well, minimum size for both Oracle datatypes is 1 byte. So in terms of storage, they’ll both consume either null or 1 byte in storage space. So, when declaring a character datatype with a length of 1, it doesn’t really … Continue reading
“Typo” in Oracle ApEx Manage Services Page
Could a developer in Oracle please fix the “typo” in the Manage Services page in Oracle Application Express. I’ve been looking at the error for some time now and was hoping that it will be fixed on the latest ApEx … Continue reading