oracleplsqlintroduction

                                                             Basics about Oracle pl/sql tutorial - Day 1

Oracle
Sql basic
Plsql basic
Sql advanced
Plsql advanced
Performace tuning basic
Performance tuning advanced

Introduction of SQL

1. Introduction
2. Commands
3. Data types
4. Clauses
5. Constraints
6. Operators
7. Functions
8. Joins
9. Subqueries
10. Other DB objects

Oracle history

Below version are DBMS based:

 Version       Date

2    June       1979
3    Mar        1983
4    Oct         1984
5.0 Apr         1985
6.0 Jul          1988
7.0 June        1992
7.1 May        1994
7.2 May        1995
7.3 Feb         1996

Below version are RDBMS based:

8.0 Jun 1997 Oracle 8 - Inbuilt JVM is included in oracle database
Internet based applications like we can interact with internet Without using browser.
Sending mail/Receiving email/downloading attachment.

Version     Date           Release Name

8.1.5          Feb  1999    Oracle 8i Release1 - i -stands for internet
8.1.6          Nov 1999    Oracle 8i Release2
8.1.7          Aug  2000   Oracle 8i Release3
9.0.1          Jun   2001   Oracle 9i Release1
9.2             May 2002   Oracle 9i Release2

                                         Thank you & wait for our next blog !!!

Comments

Post a Comment

Popular posts from this blog

Decode function in Oracle pl/sql

Image
DECODE function in Oracle pl/sql As part of Oracle pl sql training , we will see this DECODE function in Oracle plsql. a> This DECODE function is available in Oracle plsql. b> This function is not available in MySQL and SQl server. DECODE syntax : SELECT DECODE ("Column_name", "search_value_1","result_1",                                                                "search_value_2","result_2",                                                                "search_value_3","result_3"                                             ...
Read more

SUBSTR function in Oracle pl/sql 

Image
SUBSTR function in Oracle Pl Sql In real time projects the requirement might come like to extract the length of data from the particular data. In this blog, we will see how we can execute this requirement through Oracle pl sql by using Oracle/PLSQL SUBSTR function.   Syntax of SUBSTR function in Oracle PL SQL is: SUBSTR( string, starting_position [, Total length of the data ] ) Parameters of SUBSTR string Input data which we are going to use for extraction process. starting position It denotes the starting position of length of the data. The position of the string will always start from 1. length Optional. It denotes the length of the character to extract. If this parameter is not given, then the SUBSTR function will return the entire string from the starting position which we given in syntax. The SUBSTR function is used to returns a string value. If length of the data is a negative number, then the SUBSTR function will return a NULL value. Rule of...
Read more

StoredprocedureinOracleplsql

​                                                 Learn Stored procedure concept in Oracle plsql Here in this blog just we are going to see stored procedure concept in Oracle plsql. We will include further topics in Oracle plsql training in separate blogs. 1. Stored procedure is also called as PL/SQL block 2.   Stored procedure receive input in the form of parameters and performs some task and it may or may not returns a value. 3.   Procedures are created to perform one or more DML operations over database.     (Ex: To create one or more DML operation (Insert or Delete or update) over database, we are creating        Stored procedure) SYNTAX for Stored procedure: CR...
Read more