اموزش و تدریس خصوصی پایگاه داده و بانک اطلاعاتی oracle
توسط استاد مانی
۰۹۳۸۶۷۸۵۲۵۵
مباحث :
Dbms
Ddbms
Sql
Nosql
Rac
Sqlplus
User
Sys
Sysdba
Connect system
Startup
Shutdown
Creat table
Pk
Fk
Check
Alter table
Drop column
Constraint
Disable
Insert into
Delete
Update
Select
Select distinic
Orderby
Groupby
Having
Where
Subquery
Like
Nolike
Join
Inner join
Natural join
Cross join
Left right pull outerjoin
Self join
Union
Minues
Functions
Chr
Trim
Case
Revers
Lenght
Round
Abs
Sqrt
Date
Sum
Avg
Max
Min
Count
View
Creat view
Sequence
Currval
Nextval
Tbs
Tablespace
Datafile
User
Role
Grant
Revoke
Profile
Plsql
Declare
Type
Rowtype
Dbms_output.put_line
Print
If
Case
Loop
For
While
Cursor
Close
Isopen
Notfound
Found
Rowcount
Trigger
Dml
Before
After
Instead of
Statment
Rowlevel
Alter trigger
Raise_application_error
Function
In out
Return
Procedure
Execute
Drop function
Drop procedure
Index
Creat bitmap index
Partition by range
List
Hash
