No man. Never in apex (at least since 5.0, never worked with lower versions) any sql code of any kind was exposed to the DOM or is served in any static file.
If you want limit yourself to only use Apex for "in-house" use, good for you. But the things that you are saying just don't make any kind of sense.

i have a problem with variables in javascript, i have the correct url in variable, but when i pass the value througth javascript, its dont take.... any suggestion?

i have this code:
<script type="text/javascript">
 function foortiawindows(pURL){
  if(!pURL){pURL = 'https://google.com';}
 
   var pURL;

   window.open(pURL);

   
   }

and i call in dynamic option like this:

foortiawindows('&P6_URL');

the value of P6_URL is an  correct url, but the javascript don take and show google, what`s happening?? if i put in the code:

foortiawindows('https://xxxxxx.xx'); its works correctly, but when i put de variable its doesnt work.

i have oracle apex 20.2.

i write the result on a P0 variable but its the same

Not next to my pc at the moment, have you tried use $v('P6_URL') instead of &P6_URL. ? Sometimes it does a trick, especially in DA.

About the use of $v, it's better to use apex.item("P6_URL").getValue(); (as is shown on the Apex javascript documentation)
The $v might get deprecated.

And the problem here is:
Substitution strings are parsed on page load. So the foortiawindows('&P6_URL'); will parse the submited value of the item P6_URL, not the client side value.

If that item is null when page is loaded, your function will call an empty string foortiawindows('');
If you put some value in the item and submit the page, the function will call whatever value was submited when page reload.

So if you want to use the client side value of the item, it should be:
foortiawindows(apex.item("P6_URL").getValue());

Yep, does make sense to me.👍 it will be sad if the $v('') and $s('') will be deprecated, we using it a lot in our development ..

Hi ,
•Microsoft
•AWS
•google
•oracle
•juniper
•cisco
•SAP
•linux
•comptia
•VMware
•salesforce
•huawei

Contact : @Viral_boy0

All dumps are Available and latest
Ping me/DM me ...

Did anyone used the ora_hash function for data mining?

Thank you!!!! its works perfect!!!!

Hi ,  
•Microsoft  
•AWS  
•google  
•oracle  
•juniper  
•cisco  
•SAP  
•linux  
•comptia  
•VMware  
 
All dumps are Available and latest  
Ping me/DM me ...

How can I hide the URL in the browser?

Hi, I'm on apex 20.1. I have a pl/sql dynamic region. I want to display a pdf file. Which is the maximum file size supported? Because if I point to a file which is more than 3 MB size it is not displayed. But if I point to a file under 3 MB size it is displayed correctly. Is there some properties to set? Thanks

Mobile or desktop?

Desktop