tag:blogger.com,1999:blog-4818542164384221282.post5496771193202677039..comments2024-03-25T17:53:49.828+08:00Comments on Grassroots Oracle: APEX Low code expressionsScott Wesleyhttp://www.blogger.com/profile/18106937181788036683noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4818542164384221282.post-17050403096470124672019-11-26T22:03:52.511+08:002019-11-26T22:03:52.511+08:00By 'on the fly', I mean dynamically execut...By 'on the fly', I mean dynamically executed code, vs code that has already been compiled.<br />https://oracle-base.com/articles/8i/native-dynamic-sql<br /><br />Here is another overview of the potential performance difference.<br />https://asktom.oracle.com/pls/apex/asktom.search?tag=dynamic-sql-vs-static-sqlScott Wesleyhttps://www.blogger.com/profile/18106937181788036683noreply@blogger.comtag:blogger.com,1999:blog-4818542164384221282.post-579637668308142572019-11-20T12:47:18.044+08:002019-11-20T12:47:18.044+08:00" It turns it into just another if statement,..." It turns it into just another if statement, as opposed to a snippet of PL/SQL that's interpreted on the fly "<br /><br />What do you mean, does snippet of PL/SQL are interpreted on the fly ? and the if statements does not get interpreted on the fly ? what is the difference. can you explain please. <br /><br />Thanks and regards.Fahdhttps://www.blogger.com/profile/07830276367604018761noreply@blogger.com