Latest version of Oracle database – Oracle 12c

Oracle 12c database

The latest version of Oracle’s database will be released in either December 2012 or January 2013. CEO of Oracle Larry Ellison said in an onstage interview.

In Oracle 12c, ‘c’ stands for Cloud

Oracle in putting more effort on Cloud systems these days. Oracle already released Oracle Enterprise Manager 12c in earlier this year. Now Oracle has the latest database a Oracle 11g release 2. Oracle not release any other information about Oracle 12c, but sure that it will be more ‘cloud’ based than Oracle 11g.

Oracle 12c new features

Oracle is the leading RDBMS available in the market. (www.oracle.com). According to Technology research firm Gartner, Oracle revenue share is higher than 45% in database.

Oracle Corporation   IT server world is curiously waiting to see the power of Oracle database machine supported by SUN hardware systems ( Oracle acquired Sun in 2010 )

Share you comment !

Advertisements

Difference between DELETE and TRUNCATE in Oracle

I have summarized main difference between Truncate and Delete command in Oracle.

Truncate Delete
DDL command DML command
Cannot be rolled back Can be rolled back
Associated with commit Need to commit explicitly after
Will not fire trigger associated with the table Will fire trigger associated with the table
Cannot be used with where clause Where clause can be used
Reset the high water mark No association with high water mark
Generally executes faster than delete Generally executes slower than truncate
Cannot run truncate for a parent table with constraints Delete can be applied after deleting the child records

Note that TRUNCATE table has two variants

1. Truncate table table_name;

or

Truncate table table_name drop storage;

(drop storage is by default)

Here Truncate reset the high water mark

2.  Truncate table table_name REUSE storage;

In this case Oracle will not reset the high water mark and same storage space will allocated for new entries in future.

Notepad++ – Tips and Tricks

Notepad++ arguably one of the best free text editor. Now you can install it in Ubuntu too

( Read – Install Notepad++ in Ubuntu ).

There are many features available in Notepad++.  Few of them are explained here.

( Version — V6.1.5 )

1. Style configuration – Font, Background Color, Syntax highlighting, Font color etc

In the menu click Settings –> Style Configurator

Notepad++ style configurator

There are many options for Setting style as your favourite language, default style,font etc.

Global style is applicable for all files. You can set each language different style.

See below example for an SQL and C program file Syntax highlighting

abc.sql

Notepad++ syntax highlighting

abc.c

Notepad++ syntax highlighting

 

 

 

 

 

 

 

 

 

2. Column editing ( Vertical editing )

Column editing feature is very useful. I think many of the modern text editors lack this feature.

Keyboard Shortcuts –  press Alt+Mouse or Alt+Shift+Down Arrow Key

Menu – Edit –> Column mode

Notepad++ column mode

This is very useful when you have many line items with similar text items.

3. Clipboard History

Clipboard History shows all text copied recently.

Menu — Edit –> Clipboard History

Clipboard History

4. ASCII Chart

Many developers like ASCII Chart handy. Notepad++ has it.

Menu — Edit –> Character Panel

5. Multiple Tabs

Can open files in different tabs

Menu —  View –>

Move/Clone Current Document

6. Google search integration

Suppose I need some help on a keyword  “stdio.h”. No need to open a browser separately and Notepad++ will do it for you. Just highlight the word you want to google and click Run –> Google Search or press Alt+F2.

Also you have many other features in Run menu. Wikipedia Search, Open in many browsers etc.

7. Bookmarks

You can set bookmarks and go through bookmarks.

Menu – Search –> Bookmark –>

8. Find in files

This is an operating system command tool. You can find files in a directory for a word or something

Menu — Search –> Search in Files

Keyboard — Ctrl+Shift+F

9. Upper-case and Lower-case

Menu — Edit –> Convert Case to

Upper-Case – Ctrl+Shift+U

Lower-Case – Shift+U

10. Zoom (Increase/Decrease the Font size dynamically )

Zoom up and down using

Mouse — Ctrl+Mouse+Wheel Up and Don

Keyboard — Ctrl+Num+/-

Menu — View –> Zoom –>

Note :-If you are running Notepad++ in Ubuntu, some of the features may not work as in Windows.

Difference between Trunc and Round functions Oracle

TRUNC and ROUND function looks similar but not exactly.

ROUND function used to round the number to the nearest while TRUNC used to truncate/delete the number from some position. Some cases both returns same result.

SQL> select trunc(25.67),round(25.67) from dual;

TRUNC(25.67)    ROUND(25.67)
————                      ————
25                                    26

Below chart clearly explains the difference

TRUNC ROUND
25.67,0 25 26
25.67,1 25.6 25.7
25.34,1 25.3 25.3
25.34,2 25.34 25.34
25.67,-1 20 30

So next time when you are using TRUNC and ROUND remember that both might give different results !

Difference between DECODE and CASE
Oracle Cursors
Find Nth highest salary
Polymorphism in Oracle
Install Notepad++ in Ubuntu
Oracle 12c New Features
Oracle Interview questions and answers
5 Different ways to delete records Oracle

Remote desktop in ubuntu 12.04

In Ubuntu 12.04 Remmina Remote Desktop Client is the default remote desktop program. But unfortunately I didn’t work well in Ubuntu 12.04 and lot of issues users are logging.

So install Vinagre ( Website ) – which was available in previous Ubuntu Versions. Ubuntu 12.04 you need to install in Manually.

How to install Vinagre

Method 1 : Using Ubuntu Software Center

Open Ubuntu Software Center and search “Vinagre” or “Remote Desktop Viewer” and Install

Remote Desktop Viewer Ubuntu

Remote Desktop Viewer Ubuntu

Method 1 : Using Terminal

Execute below command in Terminal

sudo apt-get install vinagre

Open a remote desktop connection with Ubuntu

Pre-requisites

1. Host computer ( Your System ) and Remote System should have vinagre  installed

2. Required IP Address or Remote System host name ( Note :- If Remote System is connecting internet via Router, you need to find Router IP ( or Service Provide IP – This may be static or dynamic ).

3. Desktop Sharing Settings – This must be done for both Host System and Remote System

Open Desktop Sharing

desktop sharing properties

 

 

 

 

 

 

 

Apply below properties as you require.

setup desktop sharing property ubuntu

 

 

 

 

 

 

 

 

 

 

 

Step 1 – Open Vinagre or Remote Desktop Viewer

Step 2 – Click Connect

Step 3 – Choose

Protocol – VNC

Host –  vnc://xxx.xxx.xxx.xxx::yyyy ( Where xxx.xxx.xxx.xxx is IP of Remote Computer/Router and yyyy is the port )

Remote Desktop Connection Ubuntu

Click Connect

Now Remote System might have received a request from you. Remote system has to accept the connection by entering password ( if required )

Now you can see and operate Remote System

 

Install Skype in Ubuntu

How to install Skype in Ubuntu.

Step 1:

Either google “Skype” or click  Download Skype ( Note that Skype website automatically identify your operating system )

Download Skype

Click Download now button and Choose your Linux Distribution ( I Chosen Ubuntu 10.04 32-bit. Note that if your Ubuntu version is higher than 10.04 you need to choose 10.04 package. Skype package is still old for Ubuntu )

Step 2:

Locate your downloaded file skype-ubuntu_4.0.0.7-1_i386.deb file ( My system it was in Downloads folder ). Right click and open with Ubuntu Software Center and Install.

skype install Ubuntu

Latest version Skype 4.0 successfully installed.

Skype 4.0 for Ubuntu/Linux

 

 

 

 

 

 

 

 

 

 

 

 

 

If you are using Ubuntu 12.04, Search Skype in HUD. Open skype and enjoy video and audio chatting free of cost !

Install Microsoft fonts in Ubuntu 12.04

Microsoft fonts in Ubuntu 12.04

Many developers and programmers might be looking for Microsoft Windows fonts. It is a third part codec for Ubuntu. So sometimes installation will not succeed because third part packages will have some Hash Sum mismatch.

( Hash Sum mismatch :- Ubuntu validates all packages and software which are not in its repository using a Hash value. If this value is not authenticated we cannot install it using apt-get install command or Ubuntu Software center and need to install manually )

So I have provide all methods of installation.

1. Using terminal

Run below command as sudo

$ sudo apt-get install ttf-mscorefonts-installer

2. Using Ubuntu Software Center

Enter ttf-mscorefonts-installer and accept EULA agreement

3. Manual Installation

Go to below website

msttcorefonts debian package

download latest deb package and install using Software Center or Archive Manager.

I have downloaded ttf-mscorefonts-installer_3.4ubuntu3_all.deb

Install it via Ubuntu software Center and enjoy Microsoft Fonts in Ubuntu.

Also read

Install Notepad++ in Ubuntu
Notepad++ – Tips and Tricks
 Remote desktop in ubuntu 12.04
Install Skype in Ubuntu 12.04
Latest version of Oracle database – Oracle 12c
Install Oracle in Ubuntu 12.04

Please comment.