Edu Flee | Online Learning Portal

Statements in Oracle DCL Statements in Oracle DCL is one of the subset in Oracle, DCL is Data Control Language, which is mainly used to get and give access to the other users. In the previous session, that we have discussed about the DML (Data Manipulation Language) , DDL (Data Define Language) , to access those this DCL command is required. In other words we can say giving authorization to the objects and data which are stored in the database. List of Commands of DCL GRANT REVOKE GRANT => Grant is used to giving permission or privileges to other schema. REVOKE => Revoking (removing) the permission that was given to any user or schema. Syntax for DCL GRANT GRANT privileges ON Objects to schema; For example:   privileges :  SELECT, UPDATE, DELETE, INSERT objects are : Table, view, Materialized views etc. ------ Updating permission in orders table for devuser2 schema. GRANT UPDATE ON orders TO devuser2; This grant permission is mainly used by the admin to give access only for the

Statements in Oracle DML In this session that we are going to see about statements in oracle DML (Data Manipulation Language). So it's better to read the post of Class 2 Statements in Oracle DDL , after read this article. DML => Data Manipulation Language. Difference Between statements in Oracle DDL and DML Data Define Language Data Manipulation Language It is used to build the structure for the table It is used to change or add the data in the form of records  It is an Auto Commit Statement, so wherever we use DDL it will get committed and save the transaction. It is a Manual Commit Statement, so manually we should commit the statements else it will rollback to the implicit save point. As per the Performance wise it has more speed than DML. Performance wise DML is slow because it makes the transaction to store in undo table space until we giving commit for that particular transaction If any changes happen it will affect the structure of the table. If any changes happen it means

Statements in Oracle Statements in Oracle is very much important topic to understand rest other topics better, so there will be lot of important interview questions will be there in this chapter. This statements in Oracle is also called as Subset of oracle statements. Before entering in to the statements in oracle, everyone should know the basic understanding about Data types in Oracle  with that clear content will be much used to understand this subset concept will be easy to learn. Overview of Statements in Oracle At the end of this chapter you will get clear Understanding about the statements of oracle With the help of this statements, you can easily create database objects like Tables Able to create tables, columns, filling the data and merging and other privileges related parts will be seen here. DDL, DML , DCL , TCL are explained very well in this post.     POINTS TO REMEMBER: Always use underscore while naming any table or columns. Example: Instead of using customer name , use

  BASIC UNIX COMMANDS  Every developers must know this basic Unix commands, if you are from computer background or if your going to work as a support or in testing team, this are the some important basic commands will be used especially cat, grep, vi editor etc. mkdir   Create a new directory.  mkdir oracle_retail ls It is used to list the content of directories like files and directory of that directories. cd Change to directory cd oracle_retail It will move to oracle_retail directory when you are in created folder Ubuntu/home/documents$ cd oracle_retail moves oracle retail folder Ubuntu/home/documents/oracle_retail$ cd.. Ubuntu/home/documents$ ----- it will return to the one previous directory. touch It is used to create empty content files, just it will create a new file name only not any content in that file,  touch newfile1.txt pwd It will display the present working directory Home/documents/oracle_retail/ Importance of Cat Unix command cat command is used in three purposes.