Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Monday, October 27, 2014

Oracle VM VirtualBox

Posted by Suhel Sayyad
Oracle Virtual Box is an open-source, cross-platform virtualization solution provided by Oracle. Oracle VirtualBox is built to support virtualization on x86 and SPARC architecture with different payloads like Windows, Linux, Mac etc.

Virtualization term reaches far into the history of Computer Science. It was first envisioned and implemented in 1960s mainframe computers to logically divide different floating operating system on the same hardware.
It’s an act of creating a virtual machine (guest OS) on host OS without any limit on hardware platform, storage device, or any computer network resources.
Virtualization come into play, when we want to install two or more applications on the same server without interfering with each other. Logically separating them seemed a good idea and now Cloud Computing has taken over the Computing arena with surprise.  Cloud Computing is booming area of Computer Science and will probably release its true potential by 2020. Without Virtualization nothing would have been possible including cloud and powerful server.
Oracle VirtualBox provides a perfect solution for end-users to install OS on host operating system and this leads to multiple OS experience without any issues.
In this tutorial, we are going to use Oracle VirtualBox 4.3.14. You can download it from here.We are going to install Ubuntu latest stable release 14.04.1 desktop 32 bit. Download Ubuntu from here .The other operating system installation follows the same rules when using Oracle VirtualBox.
Let’s back to the actual work.

Step 1: Starting the engine

Oracle VM VirtualBox
Open Oracle VirtualBox and select New on top left corner of the software. You will be surprised by the clean interface provided by the Oracle VirtualBox.

Step 2:  Choosing name and Operating System to be installed.

Oracle VM VirtualBox
After choosing new, you will be prompted by another small window. The small window will ask the user for the name and operating system the user intends to install. The name is crucial as it will help you identify the guest OS. Choosing a well-defined and medium length name won’t hurt until and unless it clearly convey the details of guest OS. 

Step 3: Allocate the memory for the Virtual Machine.

Oracle VM VirtualBox

Memory is very important and should be chosen wisely according to your needs. The metric used is MB and the recommended memory size is 512mb. For a machine of 4 GB RAM, my recommendation would be to allocate 1.5 GB to Guest OS. As my current system memory is 3GB, I went with 1 GB ram.

Step 4: Adding space to your Oracle Virtual Machine and customizing it.

Now, it’s the time to allocate hard disk space to Guest OS. This step provides you with three options:
  • Do not add a virtual hard drive
  • Create a virtual hard drive now
  • Use an existing virtual hard drive file.
In most of the situations, it is suggested to go with the option “Create a virtual hard drive now” or “Use an existing virtual hard drive file” if you have a virtual hard drive present on your Hard Disk.
The recommended size of hard drive is 8.00GB. You can always change the hard drive space later, so take this step easy.
Next, it will ask you to hard drive file types. Choose VDI(VirtualBox Disk Image) for now.

Oracle VM VirtualBox


Click next, and choose dynamically allocated hard drive file as it will make sure that the hard disk space allocated for the Virtual Machine grows when needed. Fixed size is rarely used and should be avoided for most of the practical purposes.

Oracle VM Workstation

The wizard will next point to choose the location to store the VDI and the size to allocate to it. As discussed above, we will go for 8.00 GB size with dynamic allocation.

Step 5: File Location and Size

The wizard allows you to choose the File location and size.

Oracle VM VirtualBox

Step 6: Powering On the Virtual Machine.

Oracle VM VirtualBox

The last step includes powering on the Virtual Machine, in our case Ubuntu. The wizard this time, will ask you to provide the image to install from. After this, normal installation will be executed.

 Oracle VM VirtualBox
                              
This ends our tutorial on Oracle VirtualBox. I hope you guys liked it. Stay tuned for more awesome and details tutorial only on tutorials4tech.com

Read More

Thursday, May 08, 2014

Oracle SQL - A Basic Tutorial

Posted by Suhel Sayyad
Working with Database is need of time. Any Business that adopts Information Technology into its working has database to play a vital role in it.
In this article, we are going to present some fundamentals of Database Technology. While doing so, we would be considering Oracle as a platform. Oracle SQL known as Oracle Structured Query Language is used to manipulate and retrieve data from database. It basically comprises of 
  • Data Definition Language
  • Data manipulation Language
  • Data Control Language

Data Definition Language

Data Definition Language are programming constructs that involve creation of various database objects in Oracle namely Tables, Views, Indexes, Sequences and Synonyms. We can have a sample for Create the table in following screenshot.

Data Definition Langauge

Data Manipulation Language

Data Manipulation Language are programming constructs that involves syntax related to manipulation of data elements within the database. This manipulation can be in terms of adding data in database, updating existing data or removal of data. These three are referred to as Insert, Update and Delete Operation in Oracle SQL. In the screenshot below you can have a look at one of them as a sample example.

Data Manipulation Language

Data Control Language

Data Control Language are programming constructs that involves syntax related to access control. It involves the Granting and revoking the privileges to or from the user. It also has a concept of Role. Role is a collection of privileges which can be used to group the categories of privileges that are likely to be distributed amongst the group of users. Following screenshot shows some sample examples for Data Control Language.

Apart from these Languages, the Oracle SQL comprises of Clauses. These clauses are basically operated when user is working for retrieval of data elements from databases. Following mentioned are the clauses and their significance
Select Clause- It is used to specify what Columns data you wish to display. It can also take expression as input. If you wish to display all columns data then you can make use of asterisk * mark. To remove duplicate data in the domain of the column you can use distinct keyword in select clause.
From Clause – It is used to specify from which table you wish to display the data. You can also put multiple tables here and perform a join operation.
Where Clause- It is used to apply restriction on the data elements that are needed as per the user criteria. The Where Clause comes with some special options namely Between And, Like, IN. We can make use of these features as and when required. Demonstration of these options you can find the video below.
Group By Clause – You can create the group of data and apply group functions on them by making use of this Clause.
Having Clause – To restrict the grouped Data you can make use of Having Clause. It is different from that of Where Clause.
Order By Clause – You can align the data as per your requirement using Order By Clause. You can make apply it for ascending and descending sorting of data.

 

Conclusion

Hope you have found this preliminary article informative. Many more of such articles on the way. If you really like the efforts behind this article, then please share this on your social networking accounts. It means a lot for me.
Read More

Sunday, May 04, 2014

Oracle SQL Developer : Free Tool for Oracle Database Developer

Posted by Suhel Sayyad
Oracle has really done a fantastic job by presenting to its developer community a fantastic tool in terms of Oracle SQL Developer. Oracle SQL Developer basically is a free tool that can be used for database development. One can use Oracle SQL Developer to check various database objects, execute different SQL statements and SQL Scripts written and stored at your disk. You can also edit and debug various Programming Language SQL statements. One can execute reports and create and save reports of their own using Oracle SQL Developer. Oracle SQL Developer helps us to increase the productivity and simplifies the process of database development tasks. Oracle SQL Developer is available in different platforms namely Windows, Macintosh, Linux (including rpm, deb, etc). Oracle SQL Developer also supports migration of third party database products to Oracle database. These features of integration provide its users a single point to check database objects and data in 3rd party databases and to migrate from these external databases to Oracle.

Oracle SQL Developer also works hand in hand with Oracle Application Express. This Oracle Application Express allows you to browse different application and perform other Oracle Application Express activities. With help of Oracle SQL Developer you can browse, import and export, or deploy different applications as per your need. You can build your own custom reports using Application Express.

Download Oracle SQL Developer 4.0, released in Feb 2014, from OTN.
Below are some features of Oracle SQL Developer 4.0

Create Connections


Connect Oracle SQL Developer

  • Create and test connections 
    • For multiple databases
    • For multiple schemas
  • Store connections that are often used.
  • Export and Import connections
  • Store password or ask for prompt of password on connection
  • Import details for connection from tnsnames.ora
  • Connections MySQL, Microsoft SQL Server, Microsoft Access, Sybase, IBM DB2.

Browse Database Objects


Browse Database Objects SQL Developer

  • Tables, Indexes and Views
  • Types, Sequences, Procedures, Triggers, Functions
  • Packages, Materialized Views and Logs
  • XML Schemas, Directories, Public Synonyms and Private Synonyms
  • Database Links

Export and Import Data


Export and Import using Oracle SQL Developer


You can export the data using Oracle SQL Developer in any of the output form
  • XML
  • CSV
  • Text
  • HTML
  • XLS
You can also import the data using Oracle SQL Developer from
  • XLS
  • CSV
You can also import data and create tables.

Work with PLSQL


PLSQL Oracle SQL Developer


The Oracle SQL Developer comes with following features for PLSQL Editor
  • Code Formatter
  • Function Snippet Viewer
  • Code Folding
  • Inline Error Reporting
  • Code Bookmarking
  • Syntax Highlighting
You can also debug and execute the Oracle PLSQL Blocks using the Oracle SQL Developer
  • Run Procedures, Functions and Packages
  • Function Return Values
  • OUT Parameters
  • Run the PLSQL Block with specified target
  • Shows parameter information

Migration of Third Party Database Products

Manage Database Connections for
  • MySQL
  • Microsoft SQL Server
  • Microsoft Access
  • IBM DB2
  • Teradata
You can also browse the third party databases. You can also go for step by step migration by applying following models
  • Capture Third Party Model
  • Convert to Oracle Model
  • Execute DDL
  • Migrate Data to Oracle

Conclusion

So, finally we can conclude that Oracle SQL Developer is a fantastic tool for Oracle Database developers. It comes with many features, but we were able to only state and provide screens of few of those in the above article. Please let us know in the comment section below which part of this you would like to have an elaborate description so that we can write a detailed article for our readers.


Read More