Sql and Plsql Developers

The Posts in this blog are exclusively for beginners who want to learn SQL & PL/SQL Easily.

Pages

Your Name *:

E-mail Address *:

Message *:

Subscribe to: Comments (Atom)

SQL - (Structured Query Language)
Sql Commands - (DDL (Data Definition Language), DML (Data Manipulation Language), DCL (Data Control Language), TCL (Transaction Control Language)
DDL- (Data Definition Language)
DML - (Data Manipulation Language )
DCL- (Data Control Language)
TCL- (Transmission Control Language)
Constraints - (Primary key, Unique key, Foreign key, Not null, Check)
Set Operators - (UNION, UNION ALL, INTERSECT and MINUS)
Pseudo Columns - ( SYSDATE, SYSTIMESTAMP, USER, UID, ROWNUM, ROWID, NEXTVAL, CURRVAL,LEVEL)
SQL Functions
Conditional Functions or Control Statements - (Case and Decode)
Aggregate Functions or Group Functions - (Avg,Count,Max,Min,Sum)
Comparison Functions - (GREATEST, LEAST)
General Functions - (NVL, NVL2, NULLIF, COALESCE)
Number Functions - (ROUND, TRUNC, MOD)
Date Functions - (MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, LAST_DAY)
Character Manipulation Function - (CONCAT, LENGTH, REPLACE,REVERSE, TRANSLATE, LPAD, RPAD, LTRIM, RTRIM, TRIM, SUBSTR, INSTR)
Case Manipulation Functions - (UPPER, LOWER, INITCAP)
Analytical Functions - (RANK,DENSE_RANK,ROW_NUMBER,LEAD,LAG,FIRST_VALUE,LAST_VALUE, CUBE & ROLLUP)

Amazon.in Widgets

Name

Email *

Message *