Posts Tagged ‘Oracle’

Oracle Database Structure

Posted: May 12, 2010 in Database
Tags: ,

Each running Oracle database is associated with an Oracle instance. When a database is started on a database server, the Oracle software allocates a shared memory area called the System Global Area (SGA) and starts several Oracle background processes. This combination of the SGA and the Oracle processes is called an Oracle instance. After starting [...]

Creating an Oracle Database

Posted: April 25, 2010 in Database
Tags: ,

What we want to learn here is creating a database using Database Configuration Assistant. I created this tutorial as simple as possible :] A standard installation can be completed on a computer with 1 GB of RAM and 1.5 GB of swap space or larger. Depending on the activity level of the machine on which [...]

Oracle Login Problem

Posted: February 20, 2010 in Database
Tags:

I got a little stupid thing when i want to login into my Oracle Server. here is the problem, i cannot open login page Nah, after got some time, i found the the solution. When i restart my server, some of Oracle services stopped. A good way to solve this, set all of the Oracle [...]

SQL Function in Oracle

Posted: April 5, 2009 in Database
Tags: , ,

TOP SQL Server: ORACLE: MySQL:

Function for Query ex : SELECT Function for DML ex : UPDATE, DELETE

what we must do first : for opening connection : closing….