Never Ever Do That »
ALTER TABLE sys.dual ADD (dummy2 VARCHAR2(1));
Tom Kyte:
You never, never never never, as in never ever – touch any of the SYS tables – not to insert into them, not to delete from them, not to update them and especially not to alter them.Leave a comment | Filed in Oracle, Tips | Tags: sql
The Oracle Cloud Cookbook »
By Roddy Rodstein:
The Infrastructure as a Service (IaaS) chapters review how to plan, design, deploy and support Oracle VM for x86 with Oracle Linux, Solaris, and Windows virtual machines Managed by Oracle VM Manager and Oracle Enterprise Manager. The Platform as a Service (PaaS) chapters review how to plan, deploy and support Oracle Database and Oracle Fusion Middleware technologies on the aforementioned IaaS platform. The Software as a Service (SaaS) chapters review how to plan, deploy, support and deliver Oracle Applications in internal and external clouds.Leave a comment | Filed in Oracle | Tags: iaas, paas, saas
11 Interesting Things You May Have Missed This Week
- What Type of Business Conference Cliché Are You?
- Here is how you can learn #Oracle ADF online
- #Oracle 11gR2 RAC Quick Reference
- All you need to know (and more) about #Oracle Database 11g Release 2 is on this Portal
- The Permissions Your Database Users Really Need (Video)
- SQL Health-Check (SQLHC) 3-minutes video: “…a small tool for big problems!” #Oracle
- Linux Command Line Cheat Sheet
- Oracle Apex Listener jdbc/security setup tips
- Group by != order by – #oracle #sql
- Big Data University: Free Database And Hadoop Courses
- Oracle SQL Developer shared setup from any machine
8 Interesting Things You May Have Missed This Week
- Hallmarks of a Great Developer
- The Best of Linux Software
- How to be a Programmer: A Short, Comprehensive, and Personal Summary
- Getting started with Oracle SQL Developer in less than 5 minutes
- The Simplicity of the Oracle Stack [video]
- Oracle Applications Framework (OAF) related articles
- To ADF or to OAF? or Can I use ADF with Oracle E-Business Suite?
- Top 10 Things Every Software Engineer Should Know
Do You Know the History of These Oracle Database Performance Related Features? Take the Quiz
2 Comments | Filed in Oracle | Tags: quizIf You Have Oracle Database You Have Oracle Application Express; Use it or Lose it
I’m starting to like Oracle Application Express (APEX) more and more every day.
I have used APEX to build a dashboard to monitor and report on all Oracle E-Business Suite (EBS) interfaces with external systems.
I am currently working on another dashboard for EBS concurrent programs. For that one I used APEX charts. They are really powerful and versatile. Here is a tutorial on how to use them.
The best thing of all, if you know SQL and PL/SQL you’ll be up to speed on APEX in no time.
Oracle recently published the Oracle Application Express statement of direction (SOD). I am very happy to see that Oracle continues to invest in the development and support of APEX and that new versions of APEX will be released annually.
In fact, the next new version will be 4.2 and according to the SOD, this upcoming version is planned to incorporate the following features:
4 Comments | Filed in Oracle | Tags: apex“Best Practices” Should Be Renamed “Contextual Practices”
I think a best practice is really a contextual practice. I’m borrowing this term from Eric Ries, author of The Lean Startup. Ries writes that we should strive to understand the context which we find ourselves in, and then apply the practice which is best within that context. I couldn’t agree more. It’s not about blindly following steps or guidelines that may, or may not, be applicable and particularly useful in your situation. It’s about understanding. You’ve got to understand your situation and take steps that make sense in that context. Not simply take steps that worked for some other person, in some other context, at some other time, just because it is labeled as a “best practice”.
I couldn’t agree more.
Leave a comment | Filed in OracleUse SQL to Create a Calendar in Mutliple Languages
In his post titled learning foreign languages with Oracle SQL, Matthias Rogel shares the following query (I slightly modified and formatted it for clarity):
2 Comments | Filed in OracleFusion is just like E-Business Suite… Not!
For all of you EBS gurus out there, take comfort in knowing that there are similarities between Fusion and EBS. Not everything is similar though, and in some cases, it may be easier to forget your knowledge of “how EBS does it” and learn “how Fusion does it” without trying to translate.
via Oracle Fusion Financials Blog.
Leave a comment | Filed in Oracle | Tags: EBSThe Power of SQL
Frank Zhou recently posted these entries on OraQA.com:
- How to transform a RefCursor query resultset into HTML table in SQL
- How to convert a RefCursor query resultset to CSV format in SQL
- How to transform a CSV file into HTML table in SQL
- How to transform a database table dataset into HTML table in SQL
- How to convert a table dataset to CSV format in SQL
Frank combines many techniques in his queries to solve problems that many of us think they can only be solved procedurally, using PL/SQL for example.
Some of the techniques/features used in his queries:
These queries are examples of the power of SQL and a demonstration of Tom’s rule:
a) if you can do it in SQL – DO IT, period.
b) if you cannot do it in SQL (and you probably can) do it in as little PL/SQL as possible.
