DBMS Popularity: A Survey of the use of DBMSs in Polytechnics and Industry
Note: This is based off a study conducted in 2002. What is interesting about it is that although it is 2008, six years later, I notice that, except for slight changes, most of it still holds water. This topic is open to discussion. Please note this is based on the most popular DBMS for educational purposes. I’ll be looking into a more modern study of DBMS popularity.
Oracle Database Related Questions
Here there are very basic still sometime become critical to know concept if you working in Oracle Database related activities.
MySqlgame
While I was looking for more articles to add to the blog I came across this interesting little application called Mysqlgame. Aptly named Mysqlgame is a real time strategy game that only uses a database for an interface and mysql commands.
The PL/SQL Enigma: NO_DATA_FOUND Continued
Hello! Thanks for stopping by. Let’s continue our discussion of NO_DATA_FOUND. Really, the deeper issue is a clearer understanding of the structure of functions and procedures in PL/SQL. To set the stage for our discussion, we often see code that repeatedly wraps ‘begin’ and ‘end’ statements around a sql query, with an exception clause immediately following the query. This is an incorrect use of the language, and in a recent post we discussed the scope of sql versus pl/sql — how sql deals with data at the table level (thus not needing the NO_DATA_FOUND exception handler) but pl/sql deals with it at the record level (and must be told what to do when no data is found). Now, we’ll go beyond that point and shift our attention to the correct way to use NO_DATA_FOUND and its host, the exception clause. To do this justice, we really must take a step back and look at the entire structure of the function or procedure, and break it down into its constituent parts.
The PL/SQL Enigma:No_Data_Found
Hello, and Welcome! Today we’re going to talk about a problem that plagues many Oracle developers. One of the most perplexing aspects of Pl/SQL coding is the NO_DATA_FOUND message, and understanding how — and when — to specifically handle this condition. First, let’s set the foundation for more clearly understanding the language structure, and then from that perspective we’ll be able to answer this question.
