Net lo Java

Pages

HOME
CORE JAVA
SQL
PL/SQL
UML
PROJECTS
DOWNLOADS

What is Oracle Database?

What is Oracle Software?

How to store your form data to MySQL?

What is database Actually?

What is Database Management System?

DatabaseModels?

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Dear Visitor your comment make us happy, so don't forget to leave a Comment.

SQL

**Components of SQL**
SQL/DRL
Select
DML
Insert
Update
Delete
DDL
Create
Alter
Drop
Truncate
Rename
DCL
Grant
Revoke
TCL
Commit
Rollback
Savepoint

Net lo Oracle Popular Posts

demobld.sql

-- -- Copyright (c) Oracle Corporation 1988, 1999. All Rights Reserved. -- -- NAME -- demobld.sql -- -- DESCRIPTION -- This s...
DROP

DROP: This command is used to drop entire data from database. It removes the definition of the oracle table. The command no...
Transaction Control Language(TCL)

Transaction Control Langauage: · A transaction is a logical unit of work. All changes made to the database can be referred t...
SELECT

SELECT: This command is used to retrieve the data from the existing table. Using this command we can retrieve all records and also ...
UPDATE

UPDATE: Update is used to modify the existing values in Table or in the base table of View. The Table must be in the Own schema. UP...
Data Definition Language(DDL)

Data definition Language: This is the first sub language in SQL which is used to define the database objects such as table, view, synon...
COMMIT

i) Commit: This command is used for save the transactions explicitly from the moment by user logon to the databas...
ALTER

ALTER: This command is used to modify the structure of the table. Using this command we can perform four different operations. This ...
TRUNCATE

TRUNCATE: This command is use delete records permanently from the existing table. It is used to remove all rows from a table...
Data Retrieval/Query Language(DRL/DQL)

Data Retrieval Language: Data Retrieval Language(DRL) or Data Query Language(DQL) is the ability to search for and locate ingormat...

Search This Blog

Translate

Blog Archive

▼ 2013 (29)
- ► October (21)
- ► August (4)
- ▼ July (4)

Net lo Java

About Me

net lo oracle

View my complete profile

Simple theme. Powered by Blogger.

Copyright © 2014 Net Lo Java. All Rights Reserved.