Types of Cloud Computing

The different types of Cloud Computing are,

1. Hybrid Cloud Computing Deployment Model
2. Community Cloud Computing Deployment Model
3. Private Cloud Computing Deployment Model
4. Public Cloud Computing Deployment Model

AUTOCOMMIT in SQL- Simple and Useful

DML Statements or Data Manipulation Language statements will not be committed unless they are committed explicitly, But if you use any data definition language (DDL) statement before or after , then Oracle Database issues an implicit COMMIT.

There is a provision in Oracle to commit every DML Transaction automatically once its run. This is called AUTOCOMMIT. We can also turn AUTOCOMMIT on and off based on our requirement.

Below are commands to check for AUTOCOMMIT.

How to do Sorting in UNIX???

UNIX sort allows us to sort data in numeric, alphabetic and reverse order whether it’s of column or multiple columns with delimiters. Sort order can be restricted to individual columns and then merged to one single file. Sorting becomes handy in many situations.

Syntax

sort [options] [files...]

Sort Order Commands

Sort -o	Filename to write sorted output to file, if not given then write to standard output.
Sort –d	Sort in dictionary order
Sort –n	Sort in numeric order(smallest first)
Sort -r	Sort in reverse order (z on top and a on bottom)
Sort –nr	Sort in  reverse numeric order
Sort +1	Sort starting with field 1 (starting from 0)
Sort +0.50	Sort starting with 50th character
Sort +1.5	Sort starting with 5th character of field 1
Sort -c	To see if a file is sorted (error message returned if not)
Sort -u	Suppress duplicate lines and output Identical input lines once.
Sort -M	Sort by month (JAN.FEB, MAR) Note that non-months are sorted first and uppercase letters precede lowercase letters for identical months.
Sort -k 1	Sort starting with the first character of the first field and continuing through the end of the line.

Below we have explained some examples which will make it easy to understand and perform sorting.

1. Simple Sort  .i.e. sort in alphabetical order starting from the first character

Example 1

$ cat sort_number.txt

100

232

3

1

44444

99

$ sort sort_number.txt

1

100

232

3

44444

99

Note: The above records are sorted alphabetically, not mathematically sorted.Same with below

Example 2

$ cat myfile

Saina

Eesto

Jaffer

Michael

$ sort myfile

Eesto

Jaffer

Michael

Saina