oraclequirks.blogspot.com
Annals of Oracle's Improbable ErrorsWelcome to Flavio Casetta's official Oracle database application development related blog. No Mysql supporters were hurt in the making of this blog.
http://oraclequirks.blogspot.com/
Welcome to Flavio Casetta's official Oracle database application development related blog. No Mysql supporters were hurt in the making of this blog.
http://oraclequirks.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
0.7 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
4
SSL
EXTERNAL LINKS
193
SITE IP
172.217.11.33
LOAD TIME
0.703 sec
SCORE
6.2
Annals of Oracle's Improbable Errors | oraclequirks.blogspot.com Reviews
https://oraclequirks.blogspot.com
Welcome to Flavio Casetta's official Oracle database application development related blog. No Mysql supporters were hurt in the making of this blog.
oraclequirks.blogspot.com
Annals of Oracle's Improbable Errors: Oracle Application Express (APEX) 5.0 available for download
http://oraclequirks.blogspot.com/2015/04/oracle-application-express-apex-50.html
Annals of Oracle's Improbable Errors. Welcome to Flavio Casetta's official Oracle database application development related blog. No Mysql supporters were hurt in the making of this blog. Thursday, April 16, 2015. Oracle Application Express (APEX) 5.0 available for download. The best Oracle Application Express edition of all times has finally landed. Info and details in Apex's official blog. Subscribe to: Post Comments (Atom). We appreciate your support! Who is the dude behind this blog? Apex 4.2.6. My co...
Annals of Oracle's Improbable Errors: About using APEX_COLLECTIONS in a tabular form with INSTEAD OF triggers
http://oraclequirks.blogspot.com/2015/07/about-using-apexcollections-in-tabular.html
Annals of Oracle's Improbable Errors. Welcome to Flavio Casetta's official Oracle database application development related blog. No Mysql supporters were hurt in the making of this blog. Thursday, July 23, 2015. About using APEX COLLECTIONS in a tabular form with INSTEAD OF triggers. Always check out the original article at http:/ www.oraclequirks.com for latest comments, fixes and updates. In case you dreamed of updating an Apex tabular form. Built on top of a view based on APEX COLLECTIONS. Subscribe t...
Annals of Oracle's Improbable Errors: In case you wish to download Apex 5.0 documentation as a zip file
http://oraclequirks.blogspot.com/2015/06/in-case-you-wish-to-download-apex-50.html
Annals of Oracle's Improbable Errors. Welcome to Flavio Casetta's official Oracle database application development related blog. No Mysql supporters were hurt in the making of this blog. Tuesday, June 09, 2015. In case you wish to download Apex 5.0 documentation as a zip file. For some reason the official page for Oracle Application Express release 5.0 doesn't include a download link for its documentation library, while archived releases are all available for download from the following page:. Oracle SQL...
Annals of Oracle's Improbable Errors: Build and use an apex page alias substitution string
http://oraclequirks.blogspot.com/2008/02/build-and-use-apex-page-alias.html
Annals of Oracle's Improbable Errors. Welcome to Flavio Casetta's official Oracle database application development related blog. No Mysql supporters were hurt in the making of this blog. Thursday, February 14, 2008. Build and use an apex page alias substitution string. Always check out the original article at http:/ www.oraclequirks.com for latest comments, fixes and updates. The seasoned developers certainly know that among the apex built-in substitution strings. There isn't any returning a page alias.
TOTAL PAGES IN THIS WEBSITE
4
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...
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”).
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 ...
Presentations – Jeff Kemp on Oracle
https://jeffkemponoracle.com/presentations
Oracle Database: Get it Right. Jeff Kemp on Oracle. Slide decks and associated materials for talks I’ve presented. Building Maintainable Applications in Apex. 8211; presented at the AUSOUG Perth Conference, November 2014. Supplementary materials: Sample TAPI Application. Apex and Virtual Private Database. 8211; presented at the Insync Perth Conference, November 2013. PL/SQL Function Result Cache. 8211; presented at the AUSOUG Perth Monthly Meeting, June 2013. Old Oracle Versions – Top 20 Gotchas. I'm an ...
Other – Jeff Kemp on Oracle
https://jeffkemponoracle.com/category/other
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”).
Tools – Jeff Kemp on Oracle
https://jeffkemponoracle.com/category/oracle/tools-oracle
Oracle Database: Get it Right. Jeff Kemp on Oracle. Top 10 Reasons to Develop in a VM. If everything goes terribly wrong, simply restore to snapshot (duh, obviously). Handle shifting conditions outside your project. As often as I can (e.g. after a few weeks if a lot of development has gone on), I re-run the scripts on a VM based on a fresh copy of Prod – any changes that anyone else has made without my knowing it, which affect my scripts adversely, get picked up early. Drop a couple hundred tables? I can...
Auto-convert field to uppercase – Jeff Kemp on Oracle
https://jeffkemponoracle.com/2015/08/07/auto-convert-field-to-uppercase
Oracle Database: Get it Right. Jeff Kemp on Oracle. Auto-convert field to uppercase. This is just a quick note for my future reference. I needed all items with the class “. 8221; to be converted to uppercase, and I thought it would work with just some CSS:. Uppercase { text-transform:uppercase; }. This makes the items. Uppercase, but when the page is posted it actually sends the values exactly as the user typed. They’d type in “. 8220;, it looks like “. 8221; on screen, but gets posted as “. On TAPI Gene...
2014 November « Sokrates on Oracle
https://marogel.wordpress.com/2014/11
An answer to everything. Annals of Oracle's Improbable Errors. Frank Zhou's collection. Inside the black magic. Sayan's sql observations. Select concepts from sql. Archive for November, 2014. Why is it not possible to raise an exception when handling no data needed? Posted by Matthias Rogel. On 8 November 2014. It seems impossible to raise an exception when handling no data needed. As expected, we handle exception raised by division by zero, there we dbms output some info and then raise program error.
2015 March « Sokrates on Oracle
https://marogel.wordpress.com/2015/03
An answer to everything. Annals of Oracle's Improbable Errors. Frank Zhou's collection. Inside the black magic. Sayan's sql observations. Select concepts from sql. Archive for March, 2015. Overview of all time changes this year via SQL. Posted by Matthias Rogel. On 30 March 2015. Inspired by Laurent Schneider’s remark concerning special time changes in Lord Howe Island. Create a free website or blog at WordPress.com. Follow “Sokrates on Oracle”. Get every new post delivered to your Inbox.
boneist-oracle.livejournal.com
Boneist's Oracle Thoughts
http://boneist-oracle.livejournal.com/tag/puzzles
Alberto Dell'Era's Oracle blog. Annals of Oracle's Improbable Errors. I'm just a simple DBA on a complex production system. Inside the Oracle Optimizer - Removing the black magic. MEEP-90 days in Hell. One size doesn't fit all. Richard Foote's Oracle Blog. Striving for Optimal Performance. Tanel Poder's blog: Core IT for Geeks and Pros. The Tom Kyte Blog. We Do Not Use Blogs. SQL and PL/SQL forum on OTN. List of Oracle Blogs wot I read. Puzzling it out . again? 19 June 2009 @ 11:46 pm. Except the ball on...
TOTAL LINKS TO THIS WEBSITE
193
oraclepw.com
蓬动Oracle学习论坛 - Powered by Discuz!
Oracle10g concepts 中英文对照 . Oracle10g(10.2.0.1-32bit) ISO . GMT 8, 2015-8-12 07:49 , Processed in 0.070746 second(s), 7 queries . 积分 0, 距离下一级还需 积分.
oraclequest | Just another WordPress.com site
Just another WordPress.com site. Script: parallel cpu intensive sql. Going Serverless with AWS Lambda, S3 Website Hosting, API Gateway, Python, Zappa and Oracle. February 12, 2018. I decided to try my hand at serverless by deploying my Oracle database history statistic viewer web application in AWS. This worked out surprisingly well and deployed serverless web application can now be seen at http:/ ora-dbhistory-viewer.s3-website-us-east-1.amazonaws.com. AWS S3 Website Hosting. May 19, 2017. The next call...
Annals of Oracle's Improbable Errors
Annals of Oracle's Improbable Errors. Welcome to Flavio Casetta's official Oracle database application development related blog. No Mysql supporters were hurt in the making of this blog. Monday, August 28, 2017. The amazing ANSI join syntax quirk. The kind of quirks I love: those that you can find a workaround for without having to wait for a patch. You execute the following query and it works. Select f.cuaa,f.id fgra, d.id cons, c.id part, p.id prt,. Pcod na, p.fol, p.part. And pfin val sysdate. Where f...
oraclequizanswers.blogspot.com
Design and Parogramming
Friday, November 2, 2012. If a relationship can be moved between instances of the entities it connects, it is said to be:. A non-transferable relationship is represented by which of the following symbols? Non-transferable relationships can only be mandatory, not optional. True or False? Which of the following pairs of entities is most likely to be modeled as a M:M relationship? When resolving an M:M relationship, the new relationships will always be on the many side. Many to Many Mandatory. Which of the ...
oraclequizquestions.blogspot.com
Oracle Quiz Questions
Oracle Quiz Answers. Oracle Quiz Questions An asterisk (*) indicates a correct answer. Advertise here, prices from $9/mo. Marți, 12 martie 2013. Section 4 Lesson 5: Iterative Control: Nested Loops. Iterative Control: Nested Loops. 1 What statement allows you to exit the outer loop at Point A in the following block? V outer done CHAR(3) := 'NO';. V inner done CHAR(3) := 'NO';. LOOP - outer loop. LOOP - inner loop. EXIT WHEN v inner done = 'YES';. EXIT WHEN v outer done = 'YES';. EXIT outer loop ;. 6 Look ...
植木屋さんへの道！
