Learn Oracle

Information

The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation.

Website: http://iwillstudy.com/group/oracle
Location: Database
Members: 36
Latest Activity: May 15

Like

4 members like this

Introduction

Overview:

Oracle is a multi-user database management system - A software package specializing in managing a single, shared set of information among many concurrent users. Oracle is one of many database servers that can be plugged into a client/server equation. Oracle works to efficiently manage its resource, a database of information, among the multiple clients requesting and sending dta in the network.

Oracle has many important freatures that make it not only an exceptional database management system, but also an excellent database server choice for client/server computing. Oracle supports all major operating systems for both clients and servers, including MSDOS, NetWare, UnixWare, OS/2 and most Unix flavors. Oracle networking software, SQL*Net, also supports all major network communication protocols, including TCP/IP, SPX/IPX, Named Pipes and DEC-Net. Therefore, Oracle can be the link which joins the many data stores and networks throughout the heterogeneous computing systems prevalent in most corporations.

Official Website: http://www.oracle.com

Official Documentation: http://www.oracle.com/pls/db102/homepage

Videos: Click Here

Oracle is a multi-user database management system - A software package specializing in managing a single, shared set of information among many concurrent users. Oracle is one of many database servers that can be plugged into a client/server equation. Oracle works to efficiently manage its resource, a database of information, among the multiple clients requesting and sending dta in the network.

Oracle has many important freatures that make it not only an exceptional database management system, but also an excellent database server choice for client/server computing. Oracle supports all major operating systems for both clients and servers, including MSDOS, NetWare, UnixWare, OS/2 and most Unix flavors. Oracle networking software, SQL*Net, also supports all major network communication protocols, including TCP/IP, SPX/IPX, Named Pipes and DEC-Net. Therefore, Oracle can be the link which joins the many data stores and networks throughout the heterogeneous computing systems prevalent in most corporations.

Discussion Forum

What are different modes of parameters used in functions and procedures? 4 Replies

There are three different modes of parameters: IN- The IN parameter allows you to pass values in to the module, but will not pass anything out of the module and back to the calling PL/SQL block.In…Continue

Tags: Procedures, Parameters, Oracle

Started by Jignesh Patel. Last reply by I m programmer I don't have life May 15.

TRUNCATE , DROP, DELETE.....EASY COMPARISION. 6 Replies

DELETEDelete is the command that only remove the data from the table.It is DML statement.Deleted data can be rollback.By using this we can delete whole data from the table(if use without where…Continue

Started by Avinash. Last reply by Avinash Apr 24, 2011.

What are the difference between DDL, DML and DCL commands?

DDL Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:CREATE - to create objects in the databaseALTER - alters…Continue

Tags: Database, Command, DDL, TCL, DML

Started by Jignesh Patel Apr 23, 2011.

Join Us as Author/Blogger

Once rightly said by William Pollard "It is the responsibility of leadership to provide opportunity, and the responsibility of individuals to contribute."We are providing you an opportunity to shake…Continue

Tags: author

Started by Tech Manager Apr 9, 2011.

View All

Comment Wall

Comment

You need to be a member of Learn Oracle to add comments!

Comment by I m programmer I don't have life on May 15, 2012 at 2:40pm: Hay any one, how do i add single apostrophes or single quotes (') in strings ?