Friday, 2 November 2012

SQL STATEMENTS

SQL Introduction :

1). Select statement : is for Data Retrieval Language (DRL)
2). Insert, Update, Delete : Data Manipulation Language (DML)
3). Creation, Alter, Rename, Truncate, Drop :                                                   Data Definition Language  (DDL).
4). Commit, Rollback, Savepoint : Data Control Language (DCL)


No comments:

Post a Comment

Script to update salespersons customer site wise in oracle apps R12

SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'DEENA VISION%'; SELECT * FROM HZ_CUST_ACCOUNTS_ALL WHERE PARTY_ID =94043 ; SE...