sqlfail.com
brainteasers – SQLfail
http://www.sqlfail.com/tag/brainteasers
Musings on Oracle and life via the medium of SQL. SQL Brainteasers: Guess the Card Game. In celebration of my trip to Vegas. Last week, here’s clues to card games in SQL form:. Surname first name from. Dishonest act; - Q 3. Atomic number = 79. Hinged barrier; - Q 4. Replace(name, chr(107), chr(116) from. Purpose = 'beating eggs'. Listagg(ingredients, ' ') within group. Name = ( select. County = ( select. Isle of man);. As always, put your answers in the comments. Posted by Chris Saxon. Mammals; - #2.
sqlfail.com
trivia – SQLfail
http://www.sqlfail.com/tag/trivia
Musings on Oracle and life via the medium of SQL. The Database Design Quiz in Numbers: 2014 Review. The results of the first ever database design championship playoff were announced today. Huge congratulations to Sean Molloy, Pavel Zeman and Justin Cave for taking the top three spots. Also thanks to everyone else who’s taken part in the quiz, answering questions, adding to the discusions and pointing out my mistakes ;). How many player were there in total? How many people took every quiz? QUERIES - - - -...
orana.info
OraNA :: Oracle News Aggregator » Andrew Reid
http://orana.info/author/andrew-reid
OraNA : Oracle News Aggregator. Read and monitor Oracle related blogs and news sources, all in one place. SUBSTR Versus LIKE in Oracle 11.2. Database Management and Performance. Aug 24, 2016. I was reading an old SQL tuning book which was printed in 2002. It said that a where. Could often use an index whereas a similar clause using substr. Could not. I wondered if this might still be the case in an Oracle 11.2.0.1 database. To find out, I created a table:. SQL create table tab1 as. Aug 10, 2016. Database...
orana.info
OraNA :: Oracle News Aggregator » Scott Wesley
http://orana.info/author/scott-wesley
OraNA : Oracle News Aggregator. Read and monitor Oracle related blogs and news sources, all in one place. How to debug stuff in Oracle APEX. Aug 25, 2016. Recently a fine young gentleman, who shall remain nameless (let's call him Jerry), asked for some assistance he was getting with an error in Oracle APEX. He had done all the right things in regard to debugging the problem, but didn't know enough about APEX to know which settings to investigate. Application Item Prefix Usage. Jul 28, 2016. Jul 7, 2016.
sqlfail.com
reading – SQLfail
http://www.sqlfail.com/tag/reading
Musings on Oracle and life via the medium of SQL. Database design resources: My reading list. Following the database design championship playoff over on the PL/SQL Challenge. 8220;Could you please advise me some resources (boooks, courses) so that I can improve? Of course I can! This is what I love to hear – people looking for resources they can use to increase their skills. This is information I’m sure others will benefit from, so here goes:. Topic = 'Database design'. Martin Widlake’s IOT series. One k...
sqlfail.com
SQL Brainteasers: Guess the Card Game – SQLfail
http://www.sqlfail.com/2015/04/24/sql-brainteasers-guess-the-card-game
Musings on Oracle and life via the medium of SQL. SQL puzzles: Which tree am I? SQL Brainteasers: Guess the Card Game. In celebration of my trip to Vegas. Last week, here’s clues to card games in SQL form:. Surname first name from. Dishonest act; - Q 3. Atomic number = 79. Hinged barrier; - Q 4. Replace(name, chr(107), chr(116) from. Purpose = 'beating eggs'. Listagg(ingredients, ' ') within group. Name = ( select. County = ( select. Isle of man);. As always, put your answers in the comments. A href= tit...
sqlfail.com
edition-based redefinition – SQLfail
http://www.sqlfail.com/tag/edition-based-redefinition
Musings on Oracle and life via the medium of SQL. Using Edition-Based Redefinition to Bypass Those Pesky Triggers. How do you apply the changes? How can you get out of this dilemma? Fortunately in Oracle 11gR2 and higher there is another way:. To do your dirty work; alter session set edition. To do your dirty work; drop trigger. Which breaks your datafix; update. The table with the trigger set. The data = 'values prevented by your trigger'. Alter session set edition. To do your dirty work cascade;. Using...
sqlfail.com
Quizzes – SQLfail
http://www.sqlfail.com/category/quizzes
Musings on Oracle and life via the medium of SQL. SQL Brainteasers: Guess the Card Game. In celebration of my trip to Vegas. Last week, here’s clues to card games in SQL form:. Surname first name from. Dishonest act; - Q 3. Atomic number = 79. Hinged barrier; - Q 4. Replace(name, chr(107), chr(116) from. Purpose = 'beating eggs'. Listagg(ingredients, ' ') within group. Name = ( select. County = ( select. Isle of man);. As always, put your answers in the comments. Posted by Chris Saxon. Mammals; - #2.
sqlfail.com
quiz – SQLfail
http://www.sqlfail.com/tag/quiz
Musings on Oracle and life via the medium of SQL. The Database Design Quiz in Numbers: 2014 Review. The results of the first ever database design championship playoff were announced today. Huge congratulations to Sean Molloy, Pavel Zeman and Justin Cave for taking the top three spots. Also thanks to everyone else who’s taken part in the quiz, answering questions, adding to the discusions and pointing out my mistakes ;). How many player were there in total? How many people took every quiz? As regular read...
SOCIAL ENGAGEMENT