(Lewis R Cunningham) Recently, Sudhat read my Introduction to Basic SQL and had this to say: The article is very interesting. Too Good! And also please describe what is the difference between SQL and Oracle and PL/SQL.
Tag: Oracle
Should Oracle fear open source?
(Candace Lombardi) Oracle continues to dominate the database software market but challenges lie ahead from open source, analysts say.
Presenting XML and SQL Analytics
(Lewis R Cunningham) The Suncoast Oracle User Group (SOUG) First Annual Tech Day is over. I had presentations on XML in Oracle and SQL Analytics in 10g. It was a great day and I think most people felt it was a truly worthwhile day. Attendance was good at about 175 people. It was a free day so I’m no
Applications for Real-Time Access
(Ari Kaplan) Database applications for wireless handhelds have an important role for business IT because they can increase productivity and lower costs for an enterprise. Let’s look at an experience I had designing and deploying a wireless application where access was the key.
Oracle RMAN Backup and Recovery Script Example
Oracle database backup and recovery becomes a lot easier when you use RMAN. This script is indicative of the ease and should not be considered a full script for RMAN backup management in Oracle.
Regular expressions in Oracle
(René Nyffenegger) With 10g, regular expressions are finally available in SQL. That is, they were already supported through the owa_pattern package.
Oracle 10G Development: Oracle-MS SQL Server Integration Tips
(Boris Makushkin) Two Worlds, two different ideologies, two constant rivals – is it possible to give more precise description for two RDBMS World giants – Oracle Database and MS SQL Server? Mountains of TPC tests, proving superiority of one or the other side. Legions of supporters for one product
Oracle: Deleting Duplicate Rows Efficiently
(Tim Procter) If you’ve made the mistake of forgetting a primary key on your table, it can be frustrating to find a way to delete all of the duplicate rows without deleting the initial instances.
Finding and Setting SQL*Plus Settings
(Steve Callan) SQL*Plus offers several handy features you can use to control your SQL*Plus session. The SHOW command works the same in both UNIX and Windows environments, and SHOW ALL can be used to display the settings or values of nearly 70 items. Instead of just showing these settings, SQL*Plus o
Understand Oracle 10g’s new Hierarchical Query options
(Scott Stephens) Oracle 10g adds new pseudo columns to the SQL Hierarchical Queries that use START WITH . . . CONNECT BY . . . clauses. For more than a decade, Oracle SQL has had the ability to cause a query to follow a hierarchical relationship. For instance, you could specify a starting condition
