<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-1680224933495022809</id><updated>2026-10-21T08:25:38.426-07:00</updated><category term="Apex"/><category term="Oracle"/><category term="html db"/><category term="AI"/><category term="Gemini"/><category term="JSON"/><category term="Mobile"/><category term="Webkit"/><category term="android"/><category term="application express"/><category term="dynamic SQL"/><category term="interactive reports"/><category term="ios"/><title type='text'>Scott&#39;s Oracle Blog</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://scottieho.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://scottieho.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Scott Horowitz</name><uri>http://www.blogger.com/profile/02718570294395766354</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbsCWdmSePUHwQTXmUtud4XRjPbuT1Kr4zCy2pOnISwVVQ2b03mXLiMvzu-0YpbUawHxOD4-7L_qB_GrRkS1xoLEyvmiJqcb7VLhLl-5vhG8_gqSiMY-rbUZSDScWkCw/s220/scott_jsb.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>7</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-1680224933495022809.post-9048809208552749206</id><published>2026-02-22T14:50:00.000-08:00</published><updated>2026-02-22T14:50:42.343-08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="AI"/><category scheme="http://www.blogger.com/atom/ns#" term="Apex"/><category scheme="http://www.blogger.com/atom/ns#" term="Gemini"/><category scheme="http://www.blogger.com/atom/ns#" term="JSON"/><category scheme="http://www.blogger.com/atom/ns#" term="Oracle"/><title type='text'>How Generative AI can save you time programming menial tasks</title><content type='html'>&lt;p&gt;&amp;nbsp;To paraphrase the rock band Staind, It&#39;s been a while since I blogged.&amp;nbsp; And since every tech blog these days is talking about AI, I figured I&#39;d join the bandwagon.&lt;/p&gt;&lt;p&gt;If you&#39;re a novice to AI, the first thing you always want to do is protect any sensitive data.&amp;nbsp; Unless, your company has privatized their LLM, never send any PII (Personally Identifiable Information) to a public LLM.&lt;/p&gt;&lt;p&gt;With my Google One membership, I have access to Gemini Pro, so that&#39;s the provider I&#39;ve been using to assist with my coding.&amp;nbsp; &amp;nbsp;I&#39;m currently using Oracle Database 19c with Oracle APEX 24.2.&lt;/p&gt;&lt;p&gt;Where I started this was when I had to re-write an integration to a REST API.&amp;nbsp; The payload is in JSON.&amp;nbsp; As any one can tell you, one of the most time consuming tasks is parsing JSON because every payload is different, it&#39;s a standard that everyone uses slightly differently.&amp;nbsp; &amp;nbsp;So, I took the test payload and told Gemini &quot;For the attached JSON file, write a pl/sql parser.&amp;nbsp; Assume an Oracle 19c database and ensure that the parser can be used for any data within this JSON structure&quot;.&amp;nbsp; Within seconds, a pl/sql procedure was presented to me, with the following notes&lt;/p&gt;&lt;p&gt;&lt;/p&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEitSlLH5wRaVWjsWiKo_0mIEioSeMXhKjspptuh0ksKEKDc05ghiXCdyAiMYoDI_9stB2nJlX02dnxM8hGCEywNwlzqpGhYCxE-7s3ZUBVzKMMQbMh106w-ysQEgQMIznLn-zYJceqmhM3gABXhPPVkYLsXs9YmcLl-XwZv_htW7Esjgko9aYQ6viuKoNdS&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img alt=&quot;&quot; data-original-height=&quot;451&quot; data-original-width=&quot;727&quot; height=&quot;361&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEitSlLH5wRaVWjsWiKo_0mIEioSeMXhKjspptuh0ksKEKDc05ghiXCdyAiMYoDI_9stB2nJlX02dnxM8hGCEywNwlzqpGhYCxE-7s3ZUBVzKMMQbMh106w-ysQEgQMIznLn-zYJceqmhM3gABXhPPVkYLsXs9YmcLl-XwZv_htW7Esjgko9aYQ6viuKoNdS=w579-h361&quot; width=&quot;579&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;One of the main issues with the JSON payload provided is that each element could potentially have children and each child can have their own children (and repeat forever).. The first iteration didn&#39;t handle this, so I had to tweak my prompts slightly to get the exact results I wanted.&amp;nbsp;&amp;nbsp;&lt;p&gt;&lt;/p&gt;&lt;p&gt;While the initial code would work, it wasn&#39;t the most efficient use of parsing.. It used JSON_TABLE, so I simply asked it to use JSON_QUERY&lt;/p&gt;&lt;p&gt;&lt;/p&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEhbP7gMPBVczWAP_TtPxK5Vz7PkzfnRq6WCBXNIXo2YNwGvgRGMM2xVgXdaCkRaCayHKIPmjFtJqBjf1DsixdnKHHFA87NMlNit2QrBIVJC8O3M4djCeUrtd1wqkkx_hGJdLII9rhy3hoqofUPmqLZ43EabeV6QyukXdfVOsXHB6ov6sgihUP4DoTNZx0wT&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img alt=&quot;&quot; data-original-height=&quot;374&quot; data-original-width=&quot;773&quot; height=&quot;252&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEhbP7gMPBVczWAP_TtPxK5Vz7PkzfnRq6WCBXNIXo2YNwGvgRGMM2xVgXdaCkRaCayHKIPmjFtJqBjf1DsixdnKHHFA87NMlNit2QrBIVJC8O3M4djCeUrtd1wqkkx_hGJdLII9rhy3hoqofUPmqLZ43EabeV6QyukXdfVOsXHB6ov6sgihUP4DoTNZx0wT=w520-h252&quot; width=&quot;520&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;JSON Payloads typically contain much more info than needed, so I was able to prompt Gemini to only give me the data I required.&amp;nbsp; Once the code was done, I tested and received an error.. So I told Gemini the error, and it corrected it.&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEgBPMdbAcMZ8l6wxS8DAwxZA2dHs3yOoaGX55ftaqxvpmVY5Xng3h527rY38sKDOllBoZ88u_oyqrKFIdd7-DCZc-PxLayA_5oBAbhqC2XwnFgBhsX0Nm9iaACXTvT5rnGsha5BqYOb1ptZSYcDm4OVipwVesdUhYkJgk39kGu8guIPX8TQLGTlCouZXjDj&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img alt=&quot;&quot; data-original-height=&quot;439&quot; data-original-width=&quot;825&quot; height=&quot;267&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEgBPMdbAcMZ8l6wxS8DAwxZA2dHs3yOoaGX55ftaqxvpmVY5Xng3h527rY38sKDOllBoZ88u_oyqrKFIdd7-DCZc-PxLayA_5oBAbhqC2XwnFgBhsX0Nm9iaACXTvT5rnGsha5BqYOb1ptZSYcDm4OVipwVesdUhYkJgk39kGu8guIPX8TQLGTlCouZXjDj=w503-h267&quot; width=&quot;503&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Any other errors I received, I sent and it fixed quickly.. clearly it doesn&#39;t compile and test :).&amp;nbsp; I even was able to tell it to re-write code using my system&#39;s coding standards and the code was generated instantly.&amp;nbsp;&amp;nbsp;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;b&gt;THE MOST IMPORTANT THINGs TO REMEMBER WHEN USING AI TO CODE ARE REVIEW AND TEST!! &lt;/b&gt;AI can make mistakes, you need to ensure the codes works exactly as you need it to, and ensure it&#39;s written to your standards.&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Using Gemini to process these files was a major time saver to me, and allowed me to focus on other things.&amp;nbsp; Learning the correct way to prompt Gemini is key to delivering the desired results.&amp;nbsp; What could have taken me several hours to write, took under an hour (with testing an error handling).&lt;br /&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;br /&gt;&lt;br /&gt;&lt;p&gt;&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://scottieho.blogspot.com/feeds/9048809208552749206/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/1680224933495022809/9048809208552749206' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/9048809208552749206'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/9048809208552749206'/><link rel='alternate' type='text/html' href='http://scottieho.blogspot.com/2026/02/how-generative-ai-can-save-you-time.html' title='How Generative AI can save you time programming menial tasks'/><author><name>Scott Horowitz</name><uri>http://www.blogger.com/profile/02718570294395766354</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbsCWdmSePUHwQTXmUtud4XRjPbuT1Kr4zCy2pOnISwVVQ2b03mXLiMvzu-0YpbUawHxOD4-7L_qB_GrRkS1xoLEyvmiJqcb7VLhLl-5vhG8_gqSiMY-rbUZSDScWkCw/s220/scott_jsb.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/a/AVvXsEitSlLH5wRaVWjsWiKo_0mIEioSeMXhKjspptuh0ksKEKDc05ghiXCdyAiMYoDI_9stB2nJlX02dnxM8hGCEywNwlzqpGhYCxE-7s3ZUBVzKMMQbMh106w-ysQEgQMIznLn-zYJceqmhM3gABXhPPVkYLsXs9YmcLl-XwZv_htW7Esjgko9aYQ6viuKoNdS=s72-w579-h361-c" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1680224933495022809.post-4409897317880346897</id><published>2024-11-06T14:27:00.000-08:00</published><updated>2024-11-06T14:27:49.596-08:00</updated><title type='text'>How Do I initialize/deploy data to production using Liquibase?</title><content type='html'>&lt;p&gt;&amp;nbsp;I encountered a situation recently where I added a field to a table, and needed to update data due to that field.&lt;/p&gt;&lt;p&gt;I realized manually doing this when I deployed was obviously a bad idea, so I did some research into how liquibase works, and my solution was pretty easy using &lt;a href=&quot;https://docs.liquibase.com/change-types/sql-file.html#xml_example&quot;&gt;this method&amp;nbsp;&lt;/a&gt;&lt;/p&gt;&lt;p&gt;But, I had some challenges&lt;/p&gt;&lt;p&gt;&lt;/p&gt;&lt;ol style=&quot;text-align: left;&quot;&gt;&lt;li&gt;How do I ensure that my script won&#39;t get overwritten when someone is working on a separate branch?&lt;/li&gt;&lt;li&gt;How do I ensure that my script will only be run once and not multiple times?&lt;/li&gt;&lt;/ol&gt;&lt;div&gt;Here is my solution:&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;We have a requirement that all branches be named after the support/dev ticket # you&#39;re working on.&amp;nbsp; &amp;nbsp;So, for argument sake, let&#39;s pretend I&#39;m working on Ticket 1234, and my branch is called Ticket_1234.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Our back-end liquibase changelogs are stored in GIT in CHANGELOGS\DB folder.&amp;nbsp; &lt;/div&gt;&lt;div&gt;There are 4 steps I did&lt;/div&gt;&lt;div&gt;&lt;ol style=&quot;text-align: left;&quot;&gt;&lt;li&gt;Created a folder within my CHANGELOGS\DB&amp;nbsp;called SCRIPTS&lt;/li&gt;&lt;li&gt;Added a line at the end of my controller.xml&lt;br /&gt;&lt;div style=&quot;background-color: #1f1f1f; color: #cccccc; font-family: Consolas, &amp;quot;Courier New&amp;quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;&quot;&gt;&lt;span style=&quot;color: grey;&quot;&gt;&amp;lt;&lt;/span&gt;&lt;span style=&quot;color: #569cd6;&quot;&gt;include&lt;/span&gt; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;file&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;scripts.xml&quot;&lt;/span&gt;&lt;span style=&quot;color: grey;&quot;&gt;/&amp;gt;&lt;/span&gt; &lt;/div&gt;&lt;/li&gt;&lt;li&gt;To ensure uniqueness, our format for a script file is script_&amp;lt;ticket#&amp;gt;_&amp;lt;script#&amp;gt;.sql.&amp;nbsp; So in this example, my first script would be script_1234_1.sql.&amp;nbsp; If I made a second one, script_1234_2.sql, etc., and we save the script in the SCRIPTS directory&lt;/li&gt;&lt;li&gt;Created a new file called scripts.xml.&amp;nbsp; We match the changeset ID # to the script #, so when liquibase runs it, it stores it in the DBCHANGELOG table, and this way, we won&#39;t encounter any duplications when deploying.&amp;nbsp;&amp;nbsp;Sample File Below&lt;br /&gt;&lt;br /&gt;&lt;div style=&quot;background-color: #1f1f1f; color: #cccccc; font-family: Consolas, &amp;quot;Courier New&amp;quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;&quot;&gt;&lt;div&gt;&lt;span style=&quot;color: grey;&quot;&gt;&amp;lt;?&lt;/span&gt;&lt;span style=&quot;color: #569cd6;&quot;&gt;xml&lt;/span&gt;&lt;span style=&quot;color: #9cdcfe;&quot;&gt; version&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;1.0&quot;&lt;/span&gt;&lt;span style=&quot;color: #9cdcfe;&quot;&gt; encoding&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;UTF-8&quot;&lt;/span&gt;&lt;span style=&quot;color: grey;&quot;&gt;?&amp;gt;&lt;/span&gt; &lt;/div&gt;&lt;div&gt;&lt;span style=&quot;color: grey;&quot;&gt;&amp;lt;&lt;/span&gt;&lt;span style=&quot;color: #569cd6;&quot;&gt;databaseChangeLog&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;xmlns&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;http://www.liquibase.org/xml/ns/dbchangelog&quot;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;xmlns:xsi&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;http://www.w3.org/2001/XMLSchema-instance&quot;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;xsi:schemaLocation&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;http://www.liquibase.org/xml/ns/dbchangelog&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;color: #ce9178;&quot;&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd&quot;&lt;/span&gt;&lt;span style=&quot;color: grey;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp;&lt;/div&gt;&lt;div&gt;&amp;nbsp; &lt;span style=&quot;color: grey;&quot;&gt;&amp;lt;&lt;/span&gt;&lt;span style=&quot;color: #569cd6;&quot;&gt;changeSet&lt;/span&gt; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;author&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;scott&quot;&lt;/span&gt; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;id&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;script_1234_1&quot;&lt;/span&gt;&lt;span style=&quot;color: grey;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;span style=&quot;color: grey;&quot;&gt;&amp;lt;&lt;/span&gt;&lt;span style=&quot;color: #569cd6;&quot;&gt;sqlFile&lt;/span&gt; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;dbms&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;!h2, oracle, mysql&quot;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;encoding&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;UTF-8&quot;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;endDelimiter&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;/&quot;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;path&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;SCRIPTS/script_1234_1.sql&quot;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;relativeToChangelogFile&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;true&quot;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;splitStatements&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;true&quot;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;span style=&quot;color: #9cdcfe;&quot;&gt;stripComments&lt;/span&gt;=&lt;span style=&quot;color: #ce9178;&quot;&gt;&quot;true&quot;&lt;/span&gt;&lt;span style=&quot;color: grey;&quot;&gt;/&amp;gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&amp;nbsp; &lt;span style=&quot;color: grey;&quot;&gt;&amp;lt;/&lt;/span&gt;&lt;span style=&quot;color: #569cd6;&quot;&gt;changeSet&lt;/span&gt;&lt;span style=&quot;color: grey;&quot;&gt;&amp;gt;&lt;/span&gt;&lt;/div&gt;&lt;div&gt;&lt;span style=&quot;color: grey;&quot;&gt;&amp;lt;/&lt;/span&gt;&lt;span style=&quot;color: #569cd6;&quot;&gt;databaseChangeLog&lt;/span&gt;&lt;span style=&quot;color: grey;&quot;&gt;&amp;gt;&lt;/span&gt; &lt;/div&gt;&lt;/div&gt;&lt;/li&gt;&lt;/ol&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Happy Coding!&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;p&gt;&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://scottieho.blogspot.com/feeds/4409897317880346897/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/1680224933495022809/4409897317880346897' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/4409897317880346897'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/4409897317880346897'/><link rel='alternate' type='text/html' href='http://scottieho.blogspot.com/2024/11/how-do-i-initializedeploy-data-to.html' title='How Do I initialize/deploy data to production using Liquibase?'/><author><name>Scott Horowitz</name><uri>http://www.blogger.com/profile/02718570294395766354</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbsCWdmSePUHwQTXmUtud4XRjPbuT1Kr4zCy2pOnISwVVQ2b03mXLiMvzu-0YpbUawHxOD4-7L_qB_GrRkS1xoLEyvmiJqcb7VLhLl-5vhG8_gqSiMY-rbUZSDScWkCw/s220/scott_jsb.jpg'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1680224933495022809.post-2838185766213525067</id><published>2024-11-05T06:29:00.000-08:00</published><updated>2024-11-05T06:29:49.610-08:00</updated><title type='text'>Discipline, Patience and Confidence or How I Learned to Stop Worrying and Love Git and Liquibase</title><content type='html'>&lt;p&gt;It&#39;s been a while since I updated for 2 reasons&lt;/p&gt;&lt;p&gt;&lt;/p&gt;&lt;ol style=&quot;text-align: left;&quot;&gt;&lt;li&gt;I&#39;m extremely lazy with posting and keeping up with things&lt;/li&gt;&lt;li&gt;I really haven&#39;t done anything that warranted a blog post&lt;/li&gt;&lt;/ol&gt;&lt;div&gt;That all changed a few months ago, but before we get into that, let me bring you up to speed.&amp;nbsp;&amp;nbsp;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;I&#39;ve been working with the Oracle Database since 2004.&amp;nbsp; I co-created an application for the mortgage industry utilizing Oracle Application Express (then HtmlDB version 4) and Oracle Database 10g.&amp;nbsp; We didn&#39;t use source control at all with that application, and honestly, at that time, I wasn&#39;t even sure what it was.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;My next career path took me to an ISV with an Apparel ERP.&amp;nbsp; &amp;nbsp;We were using MS Visual Sourcesafe on our code base, but we didn&#39;t really have a great way of promoting code in an easy way.&amp;nbsp; We also had hundreds of customers with customization and custom code that really made auto-deployment extremely difficult.&amp;nbsp; &amp;nbsp;I also wasn&#39;t the best with remembering to check-in/check-out code, and had to be reminded frequently.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;For the last several years, I&#39;ve been a member of a small team working on replacing a legacy system.&amp;nbsp; Our application is an &quot;evolutionary&quot; approach to replacement.&amp;nbsp;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Sometimes during this process, I&#39;d feel more like a firefighter than a developer.&amp;nbsp; Fixing errors as quickly as possible.&amp;nbsp; &amp;nbsp;I&#39;d rush changes out to production without remembering to update development or doing proper testing.&amp;nbsp; This would work for the immediate, but with the next update, bam that fix would be lost for obvious reasons.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Obviously, this is not a great way to work.&amp;nbsp; &amp;nbsp;We had been mandated by management to enforce version control, and deployment logging.&amp;nbsp; As, we were using some Oracle Cloud products, we were given free access to &lt;a href=&quot;https://www.oracle.com/application-development/visual-builder-studio/&quot;&gt;Oracle&#39;s Visual Builder Studio Cloud Service&lt;/a&gt;.&amp;nbsp; This provided us with a hosted GIT service similar to Github.&amp;nbsp; &amp;nbsp;So, I proceeded to set us up with GIT for managing our code base.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Honestly, understanding GIT terminology was a bit difficult for me.&amp;nbsp; &quot;Checking Out&quot; has a completely different meaning on SourceSafe than it does in GIT.&amp;nbsp; &amp;nbsp;And, I wasn&#39;t too familiar with the command-line interface, so I began using the GIT integration in &lt;a href=&quot;https://www.oracle.com/database/sqldeveloper/&quot;&gt;Oracle SQL Developer&lt;/a&gt;.&amp;nbsp; &amp;nbsp;However, I didn&#39;t understand branches and merges, so all I was doing was making a change, and committing it to the Master, just for basic source control.&amp;nbsp; The other issue was that the other developers on the team weren&#39;t using GIT, so the potential for disaster was real.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Obviously, there was a need for change... So, earlier this year, I was poking around on Twitter (I refuse to call it &quot;x&quot;), and saw this post from &lt;a href=&quot;https://www.thatjeffsmith.com/&quot;&gt;SQL Product Manager Jeff Smith&amp;nbsp;&lt;/a&gt;&lt;/div&gt;&lt;div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEj9uSfwBobdmVjC5ODOXrQPPS0nBnEnmftkE_Tv2lJscOuEeu6w_t3dzqWWRBu7Gh3REkJlL1nWjAGuSaCGImFgEbcmKlVpEkhU_ivtzvD66pW7fxeeXwPEdvwptbdhYDL4X9KPEp_Vj8ToKJm_U0Qq3ndakW2jv1SI2tB8fJ897UnVrThrMhYmoB2Y3Y5d&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img alt=&quot;&quot; data-original-height=&quot;224&quot; data-original-width=&quot;597&quot; height=&quot;198&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEj9uSfwBobdmVjC5ODOXrQPPS0nBnEnmftkE_Tv2lJscOuEeu6w_t3dzqWWRBu7Gh3REkJlL1nWjAGuSaCGImFgEbcmKlVpEkhU_ivtzvD66pW7fxeeXwPEdvwptbdhYDL4X9KPEp_Vj8ToKJm_U0Qq3ndakW2jv1SI2tB8fJ897UnVrThrMhYmoB2Y3Y5d=w529-h198&quot; width=&quot;529&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Having nothing to lose, I sent an email asking for some assistance with CI/CD (Continuous Integration/Continuous Deployment).&amp;nbsp; &amp;nbsp;Within 30 minutes, Jeff replied to me, and introduced me to &lt;a href=&quot;https://www.talke.tech/&quot;&gt;Zachary Talke&lt;/a&gt;, another Product Manager on the Database Tools team.&amp;nbsp; &amp;nbsp;Zach setup a video call with my development team, and demonstrated Liquibase to us, and how we can use it to promote our changes.&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;Of course, as things always do, I got busy for a few months, so didn&#39;t pick this up again for 2 more months.&amp;nbsp; &amp;nbsp;And, by then, I had forgotten everything I had learned.&amp;nbsp; Zach had sent me a few Workshops that I&#39;m linking here, which were very useful&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;ul style=&quot;text-align: left;&quot;&gt;&lt;li&gt;&lt;span face=&quot;Calibri, sans-serif&quot; style=&quot;background-color: white; font-size: 14.6667px;&quot;&gt;&lt;a href=&quot;https://apexapps.oracle.com/pls/apex/f?p=133:180:114304590435284::::wid:3692&quot;&gt;SQLcl Liquibase Concept Overview Workshop&lt;/a&gt;&lt;/span&gt;&lt;/li&gt;&lt;li&gt;&lt;span face=&quot;Calibri, sans-serif&quot; style=&quot;background-color: white; font-size: 14.6667px;&quot;&gt;&lt;a href=&quot;https://apexapps.oracle.com/pls/apex/r/dbpm/livelabs/view-workshop?wid=3793&amp;amp;clear=RR,180&amp;amp;session=114304590435284&quot;&gt;Deploying a Full Stack Development Project With SQLcl Liquibase Workshop&lt;/a&gt;&lt;/span&gt;&lt;/li&gt;&lt;/ul&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;So, I did what everyone does when they need to learn something, they go on YouTube.&amp;nbsp; I found a pretty detailed video specifically regarding Oracle APEX and Liquibase that I also highly recommend.&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: left;&quot;&gt;&lt;ul style=&quot;text-align: left;&quot;&gt;&lt;li&gt;&lt;a href=&quot;https://youtu.be/P3La7ig37CU?si=I4AOGKoXtmQBytqN&quot;&gt;Continuous Integration &amp;amp; Delivery (CI/CD) for Oracle Database and APEX Development&lt;/a&gt;&lt;/li&gt;&lt;/ul&gt;&lt;div&gt;During the setup for our implement, I had many questions arise that looked weird to me.&amp;nbsp; Zach and Jeff would typically reply to emails within 1 to 2 business days, which is a great turn-around for basically &quot;free support&quot;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Our process while it seems complicated, actually became fairly simple&lt;/div&gt;&lt;div&gt;&lt;ul style=&quot;text-align: left;&quot;&gt;&lt;li&gt;Ticket must be created in our separate ticketing system&lt;/li&gt;&lt;li&gt;Branch name must be ticket_&amp;lt;ticket_number&amp;gt;&lt;/li&gt;&lt;li&gt;all DDL types (packages,views,functions,triggers,etc) must be saved as .sql files in the file system and commited on save&lt;/li&gt;&lt;li&gt;LIQUIBASE changelogs must be generated for all objects to move between DBS (and committed to GIT)&lt;/li&gt;&lt;li&gt;If new additions, update changelog.xml to include any new liquibase changelogs&lt;/li&gt;&lt;li&gt;End-User Testing must be done on separate test system&lt;/li&gt;&lt;li&gt;Once testing is complete, merge request must be made on cloud&lt;/li&gt;&lt;li&gt;Merge can only be done after another developer and manager approve request&lt;/li&gt;&lt;li&gt;Only way to deploy to production is via Liquibase&lt;/li&gt;&lt;/ul&gt;&lt;div&gt;Here are some helpful Liquibase command&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;ul style=&quot;text-align: left;&quot;&gt;&lt;li&gt;lb generate-db-object -object-type &amp;lt;OBJECT_TYPE&amp;gt; -object-name &amp;lt;NAME&amp;gt; -ovf&lt;/li&gt;&lt;ul&gt;&lt;li&gt;replace &amp;lt;OBJECT_TYPE&amp;gt; with PACKAGE_SPEC,PACKAGE_BODY,VIEW,TABLE,ETC&lt;/li&gt;&lt;li&gt;replace &amp;lt;NAME&amp;gt; with the name of the object&lt;/li&gt;&lt;li&gt;-ovf is for overwriting files..this will update an existing file instead of creating a new one&lt;/li&gt;&lt;/ul&gt;&lt;li&gt;lb generate-apex-object -applicationid &amp;lt;ID#&amp;gt;-skipexportdate -exporiginalids -split -ovf -runalways&lt;/li&gt;&lt;ul&gt;&lt;li&gt;replace &amp;lt;ID#&amp;gt; with your applicationid&lt;/li&gt;&lt;li&gt;-skipexportdate will not add an export date in your files, making sure only updated ones have changes&lt;/li&gt;&lt;li&gt;-exporiginalids will emit ids as they were when app was imported, again to only update files that have changed&lt;/li&gt;&lt;li&gt;-split will split the application into several files so you have 1 file per page, and will only update that page instead of the whole app&lt;/li&gt;&lt;li&gt;-ovf same as above&lt;/li&gt;&lt;li&gt;-runalways - whenever you export apex, it has the same changelog ID INSTALL_ID#.. this will ensure the app will run no matter if the changelog id is in the table&lt;/li&gt;&lt;/ul&gt;&lt;/ul&gt;&lt;div&gt;Before going live, I created a new branch for setup and did an &quot;LB generate-schema&quot; from our production system.. this created a changelog for every object in the schema.&amp;nbsp; &amp;nbsp;I then did a datapump export/import from production to our live and test systems.&amp;nbsp; &amp;nbsp;Once the import was done.. to ensure everything was &quot;in sync&quot; ... I performed lb -changelog-sync -chf controller.xml... this updated the databasechangelog table to ensure that all changelogs in live were applied to test and dev, this way only future changelogs would be affected&lt;/div&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;As of now, our system stability has increased significantly... I no longer fear deploying software.&amp;nbsp; I can view where mods are without having to read code, and just check the commit logs.&amp;nbsp; We have full auditability for deployment, which is great.&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;Here are a few challenges I still face&lt;/div&gt;&lt;div&gt;&lt;ul style=&quot;text-align: left;&quot;&gt;&lt;li&gt;I have subscribed my APEX plugin settings to a master app, but when I install my app from dev-&amp;gt;live, it takes the plugin settings, and then I have to unsubscribe, change the settings, and re-subscribe&lt;/li&gt;&lt;li&gt;There seems to be inconsistent behavior when I change a page that has user saved Interactive Reports and Interactive Grids.&amp;nbsp; I&#39;m trying to isolate the exact situation here to report it, but I have had a few reports of saved reports/settings disappearing&lt;/li&gt;&lt;li&gt;We are doing all our liquibase commands manually and have to type them in.. I want to investigate a full automatic deployment system to simplify this process&lt;/li&gt;&lt;/ul&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;I also need to give a shout out to my friend &lt;a href=&quot;https://mwrynn.blogspot.com/&quot;&gt;Mark Wrynn&lt;/a&gt;.&amp;nbsp; He&#39;s the one that hired me 20 years ago, and shaped my career with Oracle.&amp;nbsp; His advice and help was invaluable specifically on the GIT side.&lt;/div&gt;&lt;/div&gt;&lt;br /&gt;&lt;br /&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;p&gt;&lt;/p&gt;</content><link rel='replies' type='application/atom+xml' href='http://scottieho.blogspot.com/feeds/2838185766213525067/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/1680224933495022809/2838185766213525067' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/2838185766213525067'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/2838185766213525067'/><link rel='alternate' type='text/html' href='http://scottieho.blogspot.com/2024/11/discipline-patience-and-confidence-or.html' title='Discipline, Patience and Confidence or How I Learned to Stop Worrying and Love Git and Liquibase'/><author><name>Scott Horowitz</name><uri>http://www.blogger.com/profile/02718570294395766354</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbsCWdmSePUHwQTXmUtud4XRjPbuT1Kr4zCy2pOnISwVVQ2b03mXLiMvzu-0YpbUawHxOD4-7L_qB_GrRkS1xoLEyvmiJqcb7VLhLl-5vhG8_gqSiMY-rbUZSDScWkCw/s220/scott_jsb.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/a/AVvXsEj9uSfwBobdmVjC5ODOXrQPPS0nBnEnmftkE_Tv2lJscOuEeu6w_t3dzqWWRBu7Gh3REkJlL1nWjAGuSaCGImFgEbcmKlVpEkhU_ivtzvD66pW7fxeeXwPEdvwptbdhYDL4X9KPEp_Vj8ToKJm_U0Qq3ndakW2jv1SI2tB8fJ897UnVrThrMhYmoB2Y3Y5d=s72-w529-h198-c" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1680224933495022809.post-1507668238080736079</id><published>2018-08-28T09:06:00.003-07:00</published><updated>2018-08-28T09:06:50.226-07:00</updated><title type='text'>Separating Production and development apps</title><content type='html'>I had an issue the other day where one of my users logged into a development app accidentally instead of production.&lt;br /&gt;
&lt;br /&gt;
So, I wanted something to let the user know they weren&#39;t in production, but not something I&#39;d have to change when I migrated the app to production.&lt;br /&gt;
&lt;br /&gt;
My development and test apps share a domain name, my production is on a separate domain.&lt;br /&gt;
&lt;br /&gt;
Javascript has a helpful function that returns your host name &quot;window.location.hostname&quot;&lt;br /&gt;
&lt;br /&gt;
So, I created a dynamic &quot;onLoad&quot; action on my login page.. with a true action of &quot;Execute Javascript&quot;&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhySazehpwP3T5n3WHtDjqaUygmFPuBZ7RLnwHYHWhcp2gFLt0mhSlz1kG2dsEhQYu4j96HBbE41F0_dtn64ugUKJkrmayyrRZjAcLiJv94Lued5Id6F2ZEVlggbMbWymD6YAeAUNOdgss8/s1600/Screenshot_1.png&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; data-original-height=&quot;202&quot; data-original-width=&quot;511&quot; height=&quot;126&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhySazehpwP3T5n3WHtDjqaUygmFPuBZ7RLnwHYHWhcp2gFLt0mhSlz1kG2dsEhQYu4j96HBbE41F0_dtn64ugUKJkrmayyrRZjAcLiJv94Lued5Id6F2ZEVlggbMbWymD6YAeAUNOdgss8/s320/Screenshot_1.png&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
2 lines below are all that were needed (replace hostnaame and text as needed)&lt;br /&gt;
&lt;br /&gt;
if (window.location.hostname == &quot;hostname.com&quot;)&lt;br /&gt;
&amp;nbsp; &amp;nbsp; window.alert(&quot;This is the development system.&amp;nbsp; Any changes made here will not be made in live.&quot;);&lt;br /&gt;
&lt;br /&gt;
Simple and efficient.&lt;br /&gt;
&lt;br /&gt;
Cheers,&lt;br /&gt;
Scott&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;</content><link rel='replies' type='application/atom+xml' href='http://scottieho.blogspot.com/feeds/1507668238080736079/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/1680224933495022809/1507668238080736079' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/1507668238080736079'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/1507668238080736079'/><link rel='alternate' type='text/html' href='http://scottieho.blogspot.com/2018/08/separating-production-and-development.html' title='Separating Production and development apps'/><author><name>Scott Horowitz</name><uri>http://www.blogger.com/profile/02718570294395766354</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbsCWdmSePUHwQTXmUtud4XRjPbuT1Kr4zCy2pOnISwVVQ2b03mXLiMvzu-0YpbUawHxOD4-7L_qB_GrRkS1xoLEyvmiJqcb7VLhLl-5vhG8_gqSiMY-rbUZSDScWkCw/s220/scott_jsb.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhySazehpwP3T5n3WHtDjqaUygmFPuBZ7RLnwHYHWhcp2gFLt0mhSlz1kG2dsEhQYu4j96HBbE41F0_dtn64ugUKJkrmayyrRZjAcLiJv94Lued5Id6F2ZEVlggbMbWymD6YAeAUNOdgss8/s72-c/Screenshot_1.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1680224933495022809.post-2140139758005997606</id><published>2011-06-10T11:58:00.000-07:00</published><updated>2011-06-10T11:58:54.705-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Apex"/><category scheme="http://www.blogger.com/atom/ns#" term="dynamic SQL"/><category scheme="http://www.blogger.com/atom/ns#" term="html db"/><category scheme="http://www.blogger.com/atom/ns#" term="interactive reports"/><category scheme="http://www.blogger.com/atom/ns#" term="Oracle"/><title type='text'>Dynamic Interactive Reports</title><content type='html'>Within our ERP package, we have what are called &quot;Viewers&quot;.. these are basically, a list of Views we&#39;ve created to allow customers to view data and download to excel. &amp;nbsp;On Apex, I needed a way to dynamically show these in interactive reports. &amp;nbsp;One of the issues I was facing, is that interactive reports require Static SQL, not functions returning SQL.&lt;br /&gt;
&lt;br /&gt;
I found this site which came in real handy for achieving what I wanted&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://www.oracleapplicationexpress.com/tutorials/71&quot;&gt;http://www.oracleapplicationexpress.com/tutorials/71&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
One limitation that was hard though was the 50 column maximum.. however, thinking in Web based verses client based.... loading a report with more than 50 columns will be extremely slow.</content><link rel='replies' type='application/atom+xml' href='http://scottieho.blogspot.com/feeds/2140139758005997606/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/1680224933495022809/2140139758005997606' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/2140139758005997606'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/2140139758005997606'/><link rel='alternate' type='text/html' href='http://scottieho.blogspot.com/2011/06/dynamic-interactive-reports.html' title='Dynamic Interactive Reports'/><author><name>Scott Horowitz</name><uri>http://www.blogger.com/profile/02718570294395766354</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbsCWdmSePUHwQTXmUtud4XRjPbuT1Kr4zCy2pOnISwVVQ2b03mXLiMvzu-0YpbUawHxOD4-7L_qB_GrRkS1xoLEyvmiJqcb7VLhLl-5vhG8_gqSiMY-rbUZSDScWkCw/s220/scott_jsb.jpg'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1680224933495022809.post-5894790930702979858</id><published>2011-04-12T06:28:00.000-07:00</published><updated>2011-04-12T06:58:01.480-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="android"/><category scheme="http://www.blogger.com/atom/ns#" term="Apex"/><category scheme="http://www.blogger.com/atom/ns#" term="application express"/><category scheme="http://www.blogger.com/atom/ns#" term="html db"/><category scheme="http://www.blogger.com/atom/ns#" term="ios"/><category scheme="http://www.blogger.com/atom/ns#" term="Mobile"/><category scheme="http://www.blogger.com/atom/ns#" term="Oracle"/><category scheme="http://www.blogger.com/atom/ns#" term="Webkit"/><title type='text'>Building a mobile site in Oracle Application Express</title><content type='html'>&lt;div&gt;&lt;div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;So.. it&#39;s been quite a while since I&#39;ve blogged.. yeah I&#39;m a little lazy, but I finally found a topic to blog about.&lt;/div&gt;&lt;div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre; &quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;The technology world is a constantly changing place. Our current ERP system is written in Oracle Forms and Reports. While that works for a good percentage of customers, there are some that are ready to explore the new. Tablet/Mobile Processing is the current &quot;trend&quot; in technology. Our customers were looking for a lightweight solution that integrates with our product for salespeople.&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre; &quot;&gt;&lt;br /&gt;&lt;/span&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;We had a few criteria:&lt;/div&gt;&lt;div&gt;&lt;ol&gt;&lt;li style=&quot;text-align: left; &quot;&gt;Ease of Use&lt;/li&gt;&lt;li style=&quot;text-align: left; &quot;&gt;Multiple Hardware/OS Capability&lt;/li&gt;&lt;li style=&quot;text-align: left; &quot;&gt;Look and Feel&lt;/li&gt;&lt;/ol&gt;&lt;div style=&quot;text-align: left; &quot;&gt;Due to the Multiple Hardware/OS, we did not feel like creating an &quot;app store&quot; app, so we decided to go with the web app approach. I have been using Apex for about 7 years now, and I decided to look into using this to get what I needed.&lt;/div&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;Doing some web searches, let me to the mobile site for the &lt;a href=&quot;http://mobile.philadelphiacricketleague.com/&quot;&gt;Philadelphia Cricket League&lt;/a&gt; this is a site done in Apex using the &lt;a href=&quot;http://snippetspace.com/&quot;&gt;iWebkit &lt;/a&gt;framework. Reading the documentation I began experimenting.&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;To start, I chose Apex Theme 10 at first, but then switch to 13 as my starting point. I extracted the iWebkit and saved it in the images folder for Apex.&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;I chose the No Tabs page as my default and edited my page layout and added tags for the iwebkit stylesheet and javascript so that it can be called.&lt;/div&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;/div&gt;&lt;blockquote&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;html lang=&quot;&amp;amp;BROWSER_LANGUAGE.&quot; xmlns=&quot;http://www.w3.org/1999/xhtml&quot; xmlns:htmldb=&quot;http://htmldb.oracle.com&quot;&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;head&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;meta content=&quot;yes&quot; name=&quot;apple-mobile-web-app-capable&quot; /&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;meta content=&quot;text/html; charset=iso-8859-1&quot; http-equiv=&quot;Content-Type&quot; /&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;meta content=&quot;minimum-scale=1.0, width=device-width, maximum-scale=0.6667, user-scalable=no&quot; name=&quot;viewport&quot; /&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=utf-8&quot;&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;meta name = &quot;viewport&quot; content = &quot;width=device-width&quot;&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;meta name = &quot;format-detection&quot; content = &quot;telephone=no&quot;&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;link rel=&quot;apple-touch-icon&quot; href=&quot;#IMAGE_PREFIX#A2000.ICO&quot;/&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;link href=&quot;#IMAGE_PREFIX#iwebkit/css/style.css&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot; /&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;script src=&quot;#IMAGE_PREFIX#iwebkit/javascript/functions.js&quot; type=&quot;text/javascript&quot;&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;/script&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;link rel=&quot;stylesheet&quot; href=&quot;#IMAGE_PREFIX#iwebkit/sw/spinningwheel.css&quot; type=&quot;text/css&quot; media=&quot;all&quot; /&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;script type=&quot;text/javascript&quot; src=&quot;#IMAGE_PREFIX#iwebkit/sw/spinningwheel-min.js?v=1.4&quot;&amp;gt;&amp;lt;/script&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;link rel=&quot;stylesheet&quot; href=&quot;#IMAGE_PREFIX#themes/theme_13/theme_4_0.css&quot; type=&quot;text/css&quot; /&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;#HEAD#&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;title&amp;gt;#TITLE#&amp;lt;/title&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;/head&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;body #ONLOAD#&amp;gt;&amp;lt;noscript&amp;gt;&amp;amp;MSG_JSCRIPT.&amp;lt;/noscript&amp;gt;#FORM_OPEN#&amp;lt;a name=&quot;PAGETOP&quot;&amp;gt;&amp;lt;/a&amp;gt;&lt;/div&gt;&lt;/blockquote&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;blockquote&gt;&lt;/blockquote&gt;I also changed the body to have the default look and feel I want&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;/div&gt;&lt;blockquote&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;!--&amp;lt;table summary=&quot;&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; border=&quot;0&quot; width=&quot;100%&quot;&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;tr&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;td valign=&quot;top&quot;&amp;gt;&amp;lt;a id=&quot;t13Logo2&quot; href=&quot;#&quot;&amp;gt;#LOGO#&amp;lt;/a&amp;gt;&amp;lt;br /&amp;gt;#REGION_POSITION_06#&amp;lt;/td&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;td width=&quot;100%&quot; valign=&quot;top&quot;&amp;gt;#REGION_POSITION_07#&amp;lt;/td&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;td valign=&quot;top&quot;&amp;gt;#NAVIGATION_BAR#&amp;lt;br /&amp;gt;#REGION_POSITION_08#&amp;lt;/td&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;/tr&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;/table&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;div id=&quot;t13BreadcrumbTop&quot;&amp;gt; &amp;lt;/div&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;table class=&quot;t13Layout&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; border=&quot;0&quot; summary=&quot;&quot; width=&quot;100%&quot;&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;tr&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;td class=&quot;t13BreadcrumbRegion&quot;&amp;gt;&amp;lt;div class=&quot;t13Breadcrumbs&quot;&amp;gt;#REGION_POSITION_01#&amp;lt;span id=&quot;t13Customize&quot;&amp;gt;#CUSTOMIZE#&amp;lt;/span&amp;gt;&amp;lt;/div&amp;gt;&amp;lt;/td&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;/table&amp;gt; --&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;div id=&quot;topbar&quot;&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre; &quot;&gt; &lt;/span&gt;&amp;lt;div id=&quot;title&quot;&amp;gt;A2000 Mobile&amp;lt;/div&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space: pre; &quot;&gt; &lt;/span&gt;&amp;lt;div id=&quot;leftnav&quot;&amp;gt;&amp;lt;a href=&quot;f?p=&amp;amp;APP_ID.:1:&amp;amp;APP_SESSION.&quot;&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;img alt=&quot;home&quot; src=&quot;#IMAGE_PREFIX#iwebkit/images/home.png&quot; /&amp;gt;&amp;lt;/a&amp;gt;&amp;lt;/div&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;/div&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;a name=&quot;SkipRepNav&quot;&amp;gt;&amp;lt;/a&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;div id=&quot;t13MessageHolder&quot;&amp;gt;#SUCCESS_MESSAGE##NOTIFICATION_MESSAGE##GLOBAL_NOTIFICATION#&amp;lt;/div&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;div class=&quot;t13BodyMargin&quot;&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;table summary=&quot;&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; border=&quot;0&quot; height=&quot;70%&quot;&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;tr&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;td valign=&quot;top&quot; width=&quot;100%&quot;&amp;gt;#BOX_BODY##REGION_POSITION_02##REGION_POSITION_04#&amp;lt;/td&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;td class=&quot;t13ColumnSep&quot;&amp;gt;&amp;lt;div class=&quot;t13ColumnSep&quot;&amp;gt;&amp;lt;br /&amp;gt;&amp;lt;/div&amp;gt;&amp;lt;/td&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;td valign=&quot;top&quot;&amp;gt;&amp;lt;div style=&quot;float:right;&quot;&amp;gt;#REGION_POSITION_03#&amp;lt;/div&amp;gt;&amp;lt;/td&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;/tr&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;/table&amp;gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&amp;lt;/div&amp;gt;&lt;/div&gt;&lt;/blockquote&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;/div&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;I then used this template on all my pages.&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;iWebkit works entirely in unorganized lists, which are all pretty well documented in their documentation... Apex works with Table Structure... how to overcome this?&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;To do &quot;reports&quot; was pretty simple. I used a pl/sql Region to dynamically output html in the format I wanted&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;/div&gt;&lt;blockquote&gt;&lt;div style=&quot;text-align: left; &quot;&gt;htp.p(&#39;&amp;lt;div id=&quot;content&quot;&amp;gt;&amp;lt;span class=&quot;graytitle&quot;&amp;gt;Choose Color&amp;lt;/span&amp;gt;&amp;lt;ul class=&quot;pageitem&quot;&amp;gt;&#39;);&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;for rec in (select cc.color_no,nvl(cc.color_descr,c.descr) col_descr&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;from color_style cc&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;inner join color_mast c&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;on cc.color_no = c.color_no&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;where cc.style = :p7_style&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;and cc.active = &#39;Y&#39;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;order by color_no)&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;loop&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;htp.p(&#39;&amp;lt;li class=&quot;menu&quot;&amp;gt;&#39;);&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;htp.p(&#39;&amp;lt;a href=&quot;f?p=&amp;amp;APP_ID.:2:&amp;amp;APP_SESSION.::NO:RP,2:P2_STYLE,P2_COLOR_NO,P2_LAST_PAGE:&#39; || :P7_STYLE ||&#39;,&#39; || REC.COLOR_NO ||&#39;,7&quot;&amp;gt;&#39;);&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;htp.p(&#39;&amp;lt;span class=&quot;name&quot;&amp;gt;&#39; || REC.COLOR_NO || &#39; - &#39; || REC.col_DESCR || &#39;&amp;lt;/A&amp;gt;&amp;lt;/span&amp;gt;&#39;);&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;htp.p(&#39;&amp;lt;span class=&quot;arrow&quot;&amp;lt;/span&amp;gt;&amp;lt;/li&amp;gt;&#39;);&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;end loop;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;htp.p(&#39;&amp;lt;li class=&quot;menu&quot;&amp;gt;&amp;lt;a href=&quot;f?p=&amp;amp;APP_ID.:14:&amp;amp;APP_SESSION.&quot;&amp;gt;&amp;lt;span class=&quot;name&quot;&amp;gt;Back&amp;lt;/span&amp;gt;&amp;lt;/a&amp;gt;&amp;lt;/li&amp;gt;&#39;);&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;htp.p(&#39;&amp;lt;/ul&amp;gt;&amp;lt;/div&amp;gt;&#39;);&lt;/div&gt;&lt;/blockquote&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;/div&gt;&lt;div&gt;Outputting form elements was a little trickier... What I needed to do here was have the elements in 1 Region, and setting all elements in the same column/row&lt;/div&gt;&lt;div&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgO4JsmAhT2YGISspKb8oMIaPfjTpDz5bypOt7XvzMfHqosxOlnWwUU77rLLW_a4ZxfOhSscaPsAnQK9Gnx0NbhBNe8dzIl9VaMp28j4SKmiGOQVXSRitGdoL5af0Ni-pXPV5km4JUoUP_v/s1600/display_properties.JPG&quot; onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot;&gt;&lt;img src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgO4JsmAhT2YGISspKb8oMIaPfjTpDz5bypOt7XvzMfHqosxOlnWwUU77rLLW_a4ZxfOhSscaPsAnQK9Gnx0NbhBNe8dzIl9VaMp28j4SKmiGOQVXSRitGdoL5af0Ni-pXPV5km4JUoUP_v/s400/display_properties.JPG&quot; border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5594695206411025442&quot; style=&quot;cursor: pointer; width: 400px; height: 109px; &quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;Then to add the list elements, I used the pre-element and post-element properties to get the correct format&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeGKxYLBiF-F19OY9TsaQuY0l3ccEucLwCH2PvUu9s4KUppUjO7T8pS1Jp9iUKU1hD1JmQb6TbkWEPuXf3jfb0fyHbh5pgoofqJ_KUjGLl8bg75XI_5j3XmvToSLtcRH8MTYbYRs8nMYG-/s1600/element.JPG&quot; onblur=&quot;try {parent.deselectBloggerImageGracefully();} catch(e) {}&quot;&gt;&lt;img style=&quot;cursor:pointer; cursor:hand;width: 400px; height: 234px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeGKxYLBiF-F19OY9TsaQuY0l3ccEucLwCH2PvUu9s4KUppUjO7T8pS1Jp9iUKU1hD1JmQb6TbkWEPuXf3jfb0fyHbh5pgoofqJ_KUjGLl8bg75XI_5j3XmvToSLtcRH8MTYbYRs8nMYG-/s400/element.JPG&quot; border=&quot;0&quot; alt=&quot;&quot; id=&quot;BLOGGER_PHOTO_ID_5594695628561563490&quot; /&gt;&lt;/a&gt;&lt;br /&gt;&lt;div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;I hope this helps you with your Mobile development until Apex comes out with a full mobile layout.&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;br /&gt;&lt;/div&gt;&lt;div style=&quot;text-align: left; &quot;&gt;&lt;span class=&quot;Apple-tab-span&quot; style=&quot;white-space:pre&quot;&gt; &lt;/span&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://scottieho.blogspot.com/feeds/5894790930702979858/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/1680224933495022809/5894790930702979858' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/5894790930702979858'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/5894790930702979858'/><link rel='alternate' type='text/html' href='http://scottieho.blogspot.com/2011/04/building-mobile-site-in-oracle.html' title='Building a mobile site in Oracle Application Express'/><author><name>Scott Horowitz</name><uri>http://www.blogger.com/profile/02718570294395766354</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbsCWdmSePUHwQTXmUtud4XRjPbuT1Kr4zCy2pOnISwVVQ2b03mXLiMvzu-0YpbUawHxOD4-7L_qB_GrRkS1xoLEyvmiJqcb7VLhLl-5vhG8_gqSiMY-rbUZSDScWkCw/s220/scott_jsb.jpg'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgO4JsmAhT2YGISspKb8oMIaPfjTpDz5bypOt7XvzMfHqosxOlnWwUU77rLLW_a4ZxfOhSscaPsAnQK9Gnx0NbhBNe8dzIl9VaMp28j4SKmiGOQVXSRitGdoL5af0Ni-pXPV5km4JUoUP_v/s72-c/display_properties.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-1680224933495022809.post-1705733261888526764</id><published>2007-04-26T07:54:00.000-07:00</published><updated>2007-04-26T07:59:47.642-07:00</updated><title type='text'>My first database post</title><content type='html'>Wow, since I do everything that Mark does (&lt;span style=&quot;font-size:100%;&quot;&gt;&lt;a href=&quot;http://mwrynn.blogspot.com/&quot;&gt;http://mwrynn.blogspot.com/&lt;/a&gt;)  I&#39;ve decided to start my own Oracle Blog.  This will discuss my experiences dealing with Oracle database, Forms/Reports, and ApEx.    I plan to write more when I have some time.&lt;br /&gt;&lt;br /&gt;-Scott&lt;br /&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://scottieho.blogspot.com/feeds/1705733261888526764/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/1680224933495022809/1705733261888526764' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/1705733261888526764'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/1680224933495022809/posts/default/1705733261888526764'/><link rel='alternate' type='text/html' href='http://scottieho.blogspot.com/2007/04/my-first-database-post.html' title='My first database post'/><author><name>Scott Horowitz</name><uri>http://www.blogger.com/profile/02718570294395766354</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbsCWdmSePUHwQTXmUtud4XRjPbuT1Kr4zCy2pOnISwVVQ2b03mXLiMvzu-0YpbUawHxOD4-7L_qB_GrRkS1xoLEyvmiJqcb7VLhLl-5vhG8_gqSiMY-rbUZSDScWkCw/s220/scott_jsb.jpg'/></author><thr:total>0</thr:total></entry></feed>