christopherbeck.wordpress.com
Parsing a CSV file in PL/SQL | Christopher Beck's Blog
https://christopherbeck.wordpress.com/2012/04/03/parsing-a-csv-file-in-plsql
Christopher Beck's Blog. Yet another tech blog on Oracle, APEX and PL/SQL development ( and other rants, just to keep it interesting ). Parsing a CSV file in PL/SQL. Parsing a CSV file in PL/SQL. April 3, 2012. The ability to parse a CSV. 8216;ing and instr. 8216;ing can really hurt your head after a while. If you tried option B, then you probably discovered that there are some solutions out there, but they all seems to either incomplete, or just overly complex. And NO calls to instr(). And here is a lit...
suppler.blogspot.com
PPLab: февраля 2015
http://suppler.blogspot.com/2015_02_01_archive.html
Oracle DB, Oracle APEX, Linux etc. Воскресенье, 22 февраля 2015 г. Oracle APEX: разбивка на страницы интерактивных отчётов. Благодаря дискуссии на SQL.RU. Решил проверить, как на самом деле происходит выдача страницы данных для интерактивного отчёта в Oracle APEX. Использовал версию 4.2.5, но не думаю, что что-то будет сильно отличаться вплоть до 4.1 включительно. Создал приложение с простым интерактивным отчётом, у которого в качестве источника данных был следующий запрос:. Select * from emp. Какие из п...
damir-vadas.blogspot.com
Damir Vadas, Oracle as I learned: Retrieve Oracle password from Toad for Oracle
http://damir-vadas.blogspot.com/2013/06/retrive-oracle-password-from-toad-for.html
Monday, June 3, 2013. Retrieve Oracle password from Toad for Oracle. One of the oldest feature Dell Toad has is saving login passwords. This is accomplish easy with enabling check box "Save passwords" on login screen. The whole connection process is defined through three files located in %USERPROFILE% AppData Roaming Quest Software Toad for Oracle 11.6 User Files. Where "11.6" is Toad version and may vary in your cases:. Connect in Toad as any user for which you DO NOT WANT TO RETRIEVE. For me this is mo...
suppler.blogspot.com
PPLab: мая 2013
http://suppler.blogspot.com/2013_05_01_archive.html
Oracle DB, Oracle APEX, Linux etc. Пятница, 31 мая 2013 г. Oracle: запрос для отображения комментариев к таблице в виде DDL. Простой запрос для получения готовых DDL-операторов COMMENT с комментариями к таблице и её столбцам:. Полезен как заготовка в ситуациях, когда нужно создать скрипт добавления или изменения комментариев к таблице. Ссылки на это сообщение. Подписаться на: Сообщения (Atom). Здесь я пишу об Oracle DB, Oracle APEX, Linux и обо всём по чуть-чуть. Иногда интересно. Блоги, которые я читаю.
jeffkemponoracle.com
Avoiding Lost Updates – Jeff Kemp on Oracle
https://jeffkemponoracle.com/category/other/avoiding-lost-updates
Oracle Database: Get it Right. Jeff Kemp on Oracle. Category: Avoiding Lost Updates. Avoiding Lost Updates #3: The Solution. Background: see my earlier posts Avoiding Lost Updates. And Avoiding Lost Updates #2: Updateable Views. I’ve discussed this problem with my colleagues and have come up with a number of potential solutions, one of which we believe is bulletproof. Use ORA ROWSCN instead of version. Cause an update on the view to. Do at least one update of one of the non-outer-joined tables (even if i...
christopherbeck.wordpress.com
My First APEX Plug-In – Color Picker. | Christopher Beck's Blog
https://christopherbeck.wordpress.com/2010/07/02/my-first-apex-plug-in-color-picker
Christopher Beck's Blog. Yet another tech blog on Oracle, APEX and PL/SQL development ( and other rants, just to keep it interesting ). My First APEX Plug-In – Color Picker. My First APEX Plug-In – Color Picker. July 2, 2010. For anyone who does not know by now, APEX 4.0. Has been released. And if you have not yet downloaded and upgraded, I say, “What are you waiting for? 8221; Click here NOW. And download it. I’ll wait. Insert jeopardy music here*. There are a ton of new features. The Plug-In I built wa...
munkyben.wordpress.com
The Magic Shed – munky on oracle
https://munkyben.wordpress.com/2013/03/14/the-magic-shed
March 14, 2013. March 14, 2013. In keeping with my last post, this is another ‘back to basic’s kind of thing. It’s basically a small metaphor of why we should use constraints, datatypes and other normal database design fundamentals when storing data and is aimed either at the complete newbie to database design or as a handy explanation to your Excel loving business users for more experienced developers…. The first weekend she carefully placed her pots on one shelf, her compost bags in one corner, her too...
jeffkemponoracle.com
Estimating Apex Development – Jeff Kemp on Oracle
https://jeffkemponoracle.com/2015/07/30/estimating-apex-development
Oracle Database: Get it Right. Jeff Kemp on Oracle. You’ve finished the design for an Apex application, and the manager asks you “when will you have it ready to test”. You resist the temptation to respond snarkily “how long is a piece of string” – which, by the way, is often the only appropriate answer if they ask for an estimate. The design work has started. I plan all my projects using Trello. Recording estimates using the Scrum for Trello. My points system looks roughly like this:. 8220;6 weeks”).
jeffkemponoracle.com
AUSOUG – Jeff Kemp on Oracle
https://jeffkemponoracle.com/category/other/ausoug
Oracle Database: Get it Right. Jeff Kemp on Oracle. AUSOUG 2014 Perth Conference. It’s that wonderful time of year again – no, not talking about springtime, when I’m stalked by airborne grass pollens causing me to choke and gag all day. The sound of a lawnmower is enough to elicit a sneezing fit – and in Aussie springtime, that’s most weekends. The “wonderful time of year” I referred to earlier is that time when the excitement of OpenWorld has petered a bit and AUSOUG have released the program. If I wasn...
jeffkemponoracle.com
Tabular Form – set default values with jQuery – Jeff Kemp on Oracle
https://jeffkemponoracle.com/2015/07/22/tabular-form-set-default-values-with-jquery
Oracle Database: Get it Right. Jeff Kemp on Oracle. Tabular Form – set default values with jQuery. I tried basing the default on a hidden page item which I kept updated based on the values entered, but it seems the tabular form only gets the item’s value on page load and doesn’t re-examine the item’s value when you click the “Add” button. Instead, I had to turn to javascript and jQuery to get the job done. 1 Add a class to the tabular form column by setting the Element CSS Classes. July 22, 2015. Jochen ...
SOCIAL ENGAGEMENT