Open SQL
A. Accessing Database in R/3 system
B. STANDARD SQL
C. Database interface
D. Open SQL
i. Types of Command
1. Data Definition Language
2. Data Manipulation Language
a. Changing Data
(INSERT, UPDATE,
MODIFY, DELETE)
b. Reading Data
i. SELECT
ii. SELECT SINGLE Vs SELECT UP TO 1 ROW
iii.INNER JOIN
iv.OUTER JOIN
v. FOR ALL ENTRIES
3. DCL (Data Control Language)
a. COMMIT WORK
b. ROLLBACK WORK
0 comments:
Post a Comment