SQL – Using DDL Statements Using DDL Statements to Create and Manage Tables A schema is the collection of multiple database objects,which are known as schema objects.These objects have direct access by their owner schema.Below table lists the schema objects. Table – to store data View – to project data in a desired format from […]
Author Archives: user
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. […]
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 […]