Edu Flee | Online Learning Portal

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.