DBA

Tasks typically handled by a database administrator, such as installation, patching, configuration, migration, security, troubleshooting, monitoring, backup, recovery.

Rename Column in an Oracle Table

Rename Column in an Oracle Table

Post 9i Oracle gives you a direct command to rename column in an Oracle table. Here’s how to do it. Bonus: workaround to rename a table column in older versions of Oracle.

Read the Full Article →
Thumbnail image for The BOOLEAN Datatype in Oracle

The BOOLEAN Datatype in Oracle

Oracle database has a BOOLEAN datatype only in PL/SQL, not in SQL. There is no direct way to represent that a column value is TRUE or FALSE. However, the BOOLEAN datatype can be easily simulated in Oracle with these implementation ideas.

Read the Full Article →
Thumbnail image for The Difference between CHAR, VARCHAR and VARCHAR2

The Difference between CHAR, VARCHAR and VARCHAR2

Oracle has three datatypes to store strings. – CHAR, VARCHAR and VARCHAR2. How do they differ from each other? When should you use which? This article gives you the lowdown on the subject.

Read the Full Article →
Thumbnail image for The Difference between DELETE, TRUNCATE and DROP

The Difference between DELETE, TRUNCATE and DROP

DELETE, TRUNCATE and DROP – all three commands get rid of table data. How exactly are they different? When should you use which?

Read the Full Article →
Thumbnail image for How to Validate Email Address in SQL

How to Validate Email Address in SQL

In applications that take user email id as input, there is a need to check for email id validity. Here is a an way to validate email address, using regular expressions in Oracle SQL.

Read the Full Article →
Thumbnail image for Auto-Increment Columns: FAQ

Auto-Increment Columns: FAQ

Auto-increment columns indatabase tables help to maintain uniqueness and track recency. Answers to frequently asked questions about auto-increment columns.

Read the Full Article →
Thumbnail image for How to Set ORACLE_HOME Path

How to Set ORACLE_HOME Path

Answers to frequently asked questions about ORACLE_HOME: what is ORACLE_HOME, how to check if ORACLE_HOME path is set, and how to set or unset it.

Read the Full Article →
Thumbnail image for Oracle Database Express Edition (Oracle XE)

Oracle Database Express Edition (Oracle XE)

Oracle Database Express Edition, or Oracle XE, is a free, lightweight version of Oracle. If you are a small enterprise with modest database needs or someone looking to learn Oracle on your home computer, Oracle XE is just right for you.

Read the Full Article →
Thumbnail image for SCOTT Schema in Oracle

SCOTT Schema in Oracle

The old familiars EMP and DEPT – tables used for demos and examples in earlier versions of Oracle – live in the SCOTT schema, the default Oracle schema in those days.

Read the Full Article →
Page 4 of 4
1
2
3
4