Oracle


SQL Basic:
ORACLE SQL 1: Giới thiệu và cài đặt
ORACLE SQL 2: SQLPlus & SQL Developer
ORACLE SQL 3: SQL Commands
ORACLE SQL 4: HR Schema
ORACLE SQL 5: Select
ORACLE SQL 6: Distinct & Count
ORACLE SQL 7: Quote
ORACLE SQL 8: Sử dụng ký tự ghép xâu
ORACLE SQL 9: WHERE
ORACLE SQL 10: BOOLEAN, AND, OR
ORACLE SQL 11: LIKE, IN, BETWEEN
ORACLE SQL 12: ORDER BY
ORACLE SQL 13: ASC & DESC
ORACLE SQL 14: Define Variables, &, &&
ORACLE SQL 15: Set define, verify on,off
ORACLE SQL 16: AVG, SUM, MIN, MAX
ORACLE SQL 17: Group by
ORACLE SQL 18: Nested group functions
ORACLE SQL 19: Group multiple functions
ORACLE SQL 20: Having
ORACLE SQL 21: LOWER, UPPER, CONCAT, INITCAP
ORACLE SQL 22: SYSDATE
ORACLE SQL 23: ADD_MONTHS, MONTHS_BETWEEN
ORACLE SQL 24: NEXT_DAY, LAST_DAY
ORACLE SQL 25: Join
ORACLE SQL 26: Join with Using and On
ORACLE SQL 27: (Left, Right, Full) Outer join
ORACLE SQL 28: Sefl join
ORACLE SQL 29: Create table
ORACLE SQL 30: Insert
ORACLE SQL 31: Delete
ORACLE SQL 32: Update
ORACLE SQL 33: Rollback & Commit
ORACLE SQL 34: Tạo table từ subquery
ORACLE SQL 35_Truncate & Drop Table
ORACLE SQL 36: Primary key & Foreign key
ORACLE SQL 37_Constraint
ORACLE SQL 38: Add, Rename, Modify column
ORACLE SQL 39: Drop column, Read only table
ORACLE SQL 40: View
ORACLE SQL 41: Create & Drop View
ORACLE SQL 42: Insert Update View With Check Option
ORACLE SQL 43: Synonym
ORACLE SQL 44: Sequence
ORACLE SQL 45: Create & Drop Sequence

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: