SQL – Get Data from Multiple Tables Displaying Data from Multiple Tables The related tables of a large database are linked through the use of foreign and primary keys or what are often referred to as common columns. The ability to join tables will enable you to add more meaning to the result table that […]
Author Archives: user
Oracle Database 11g – SQL Exams Syllabus (Oracle Certified Oracle Database 11g Administrator) Oracle Database 11g: SQL Fundamentals certification exams has a defined Syllabus to check your expertise. As per Oracle Official website, following is the list of chapters and covered topic to be examined in the certification exams. Retrieving Data Using the SQL SELECT […]
SQL – Using Conditional Expressions General Functions General functions are used to handle NULL values in database. The objective of the general NULL handling functions is to replace the NULL values with an alternate value. We shall briefly see through these functions below. NVL The NVL function substitutes an alternate value for a NULL value. […]