Setting Up an Oracle Environment
If you want to set up a typical PL/SQL environment, you need the following components: [more…]
Knowing Just Enough about Relational Databases
Building a system in Oracle or some other relational database product does not automatically make it a relational database. Similarly, you can design a perfectly good relational database and implement [more…]
What Is PL/SQL Good For?
PL/SQL is the language to use when writing code that resides in the database. In the following article, you'll see different situations in which you'll find PL/SQL useful. [more…]
The Scoop on SQL and PL/SQL
As a database application developer, you interact with the Oracle DBMS by using the programming languages Structured Query Language (SQL, pronounced sequel [more…]
More SQL Server 2005 Express Troubleshooting Tips
Predicaments are possible with SQL Server 2005. Here's a smattering of those that you're likely to encounter. [more…]
Where Does SQL Server Express 2005 Work Best?
SQL Server 2005 Express brings a lot to the table, but when does it make sense to choose it as your data storage platform? Some insight follows. . . . [more…]
A Few SQL Server 2005 Express Troubleshooting Tips
As an entry-level database server that is built on the same platform as the entire SQL Server product family, SQL Server 2005 Express combines simplicity with great power and a massive set of features. [more…]
Working with Code after Installing an Oracle PL/SQL Database
After you have the database installed, the next question is, "Where will you run all these PL/SQL programs?" The answer isn't as simple as you might think. The ultimate goal is productivity, and you can [more…]
Getting Down to Business with SQL Server 2005 Express
If you're wondering how you can get started using the product, that's what this article is all about. [more…]
