RandyDBA | Database - Tips & Techniques

Many Similarities, But Different? RDBMSs: There are allot of different relational database management systems (RDBMS) out there. You may have heard about Microsoft Access, Sybase, and MySQL but the two most famous and widely used are MS SQL Server and Oracle. Although there are many common things between the two RDBMSs there are also a number of key differences.  In this blog, I will take a look at several in peculiar, in the areas of their command language, how they manage transaction control and their management of database objects. LANGUAGE: Perhaps the foremost obvious distinction between the 2 RDBMS is the language they use. Though each systems use a version of Structured Query Language, or SQL, MS SQL Server uses Transact SQL, or T-SQL, which is an extension of SQL originally developed by Sybase and used by Microsoft. Oracle, meanwhile, uses PL/SQL, or Procedural Language/SQL. Both are different "flavors" or dialects of SQL and both languag...

I recently read an article that have an SQL prompt displyaing "user@hostname". As DBAs we frequently use SQL*Plus to perform daily administrative tasks. Often, you'll work on servers that contain multiple databases. Obviously, each database contains multiple user accounts. When connected to a database, you can run the following commands to verify information such as your username, database connection, and hostname:   SQL> show user;  SQL> select name from v$databae;   A more efficient way to determine your username and SID is to set you SQL prompt to display that information; for example,   SQL> SET SQLPROMPT '&_USER.@&_CONNECT_IDENTIFIER.> '   An even more efficient way to configure your SQL prompt is to have it automatically run the SET SQLPROMPT command when you log in to SQL*Plus.   Follow these steps to fully automate this:  1. Create a file named login.sql, and place in it the SET SQLPRO...