12c Oracle in Hindi

Table of Contents

12c Oracle Database Administrator in Hindi

Chapter 1: Introducing
Relational Database Management
Systems Characteristics of a Relational Database
Oracle’s Implementation of RDBMS and
ORDBMS The Oracle Database 12c Oracle
Database 12c
Implementations Connecting
to Oracle Database Database
Management Tools Oracle
Database 12c in the Cloud
Familiarizing SQL*Plus
Summary
Chapter 2: Introducing SQL
SQL Fundamentals
Oracle Datatypes
Operators and Literals
Writing SimpleQueries
Using the SELECT Statement
Filtering Rows
Sorting Rows
SortingNULLs
Limiting Rows
Using
Expressions
Accepting Values at Runtime
Using Ampersand Substitution Variables
Saving a Variable for a Session
Using Positional Notation for Variables
Summary
Chapter 3: Using Single-Row Functions
Single-Row Function
Fundamentals Functions for
NULL Handling
Contents
Using Single-RowCharacter
Functions Character Function
Overview Character Function
Descriptions
Using Single-Row Numeric
Functions Numeric Function
Overview Numeric Function
Descriptions
Using Single-Row Date
Functions Date Format
Conversion Date
Function Overview Date
Function Descriptions
Using Single-Row Conversion
Functions Conversion Function
Overview Conversionn Function
Descriptions
Using Other Single-Row Functions
Miscellaneous Function Overview
Miscellaneous Function Descriptions
Summary
Chapter 4: Using Group Functions
Group Function Fundamentals
Utilizing Aggregate Functions
Grouping Data with GROUP BY
Group Function Overview
Group Function Descriptions: Part 1
Group Function Descriptions: Part 2
Limiting Grouped Data with
HAVING
Creating Superaggregates with CUBE and
ROLLUP Nesting Functions
Summary
Chapter 5: Using Joins and Subqueries

Chapter 6: Manipulating Data

Chapter 7: Creating Tables and Constraints