हिंदी में देखें |

Computer Courses

Database

PLSQL



SQL The Structured Query Language (SQL) is a computer language for accessing and manipulating databases.
The fundamental concept is to think of the data as being stored in one or more tables. When a request is made to retrieve data from these tables, which is called a "query", the resultant output is also presented in as table.

There are many different versions of the SQL language, but to be in compliance with the ANSI SQL '92 Standard, they must use and support the same major keywords in a similar manner (such as SELECT, UPDATE, DELETE, INSERT, WHERE, and others.


Contents :-

  • PL SQL

    Introduction to SQL

    What is database
    DBMS
    What is SQL
    SQL data type & operator
    Data Definition Laungauge
    Data Manipulation Laungauge
    Data Control Laungauge

    SQL Commands

    SQL SELECT
    SQL WHERE
    SQL UPDATE
    SQL DELETE
    SQL INSERT INTO

    SQL Advanced

    SQL Order By
    SQL AND & OR
    SQL In
    SQL Between
    SQL Aliases
    SQL Join
    SQL Union . SQL Functions
    SQL Select Into
    SQL Create View
    Nested Queries

    DATA MANIPULATION

    SQL Create table
    SQL Delete Table
    SQL Create index
    SQL Drop index
    SQL Alter Table

    SQL Function

    What is SQL Function?
    Aggregate Function
    Scalar function
    SQL Group By and Having

    PL/SQL

    Basic structure of PL/SQL
    Variables and type
    Simple program in PL/SQL
    Control flow in PL/SQL
    Cursors
    Printing variables

Next Page.....

Tags- Is PL SQL different from SQL? | What is PL SQL purpose of PL SQL? | What is PL SQL variable? | What is PL SQL block structure? | What is procedure in PL SQL? | What is the character limit for variable in PL SQL? | What is T SQL and PL SQL? | What is the difference between SQL and PL SQL? | What are the advantages of PL SQL? | What is the difference between PL SQL and mysql? | Why SQL is called non procedural language? | What is the difference between DML and DDL? | What is DDL and DML in SQL? | What is the difference between SQL and Oracle? | What is the difference between SQL and mysql? | Can PL SQL run mysql? | What is a PL SQL block? | What is PL SQL architecture? | What is PL SQL used for? | What is PL SQL engine? | What is PL SQL in Oracle? | Is PL SQL a scripting language? | What is PL country? | What is PL programming language? | What is type in PL SQL? | What is data type in PL SQL? | Which set of keywords must you include in every anonymous PL SQL block? | What is meant by cursor in PL SQL? | What is the difference between varchar and varchar2? | How many characters can varchar2 hold?



UpImage
Home|Indian Doctors|Indian Hospitals|Utility|Career|Electronics|Family|General|Health|PC Tips|Technology|About Us|About Admin|Feedback|Apply For Job Computer Courses|Login| Created by - Er. Sanjay Singh