You may chose to use one of the PL/SQL integrated development environments such as TOAD, PL/SQL Developer or Oracle’s new Raptor . For a new developer we recommend using SQL*Plus because it is simple and will keep you from confusing PL/SQL errors and the tool errors. You will find that the first thing a developer needs to do is understand the Oracle and PL/SQL error messages . Remember, a development tool can make error messages harder to understand.

The first step is to start SQL*Plus and connect to the database. In Windows, open a terminal window. In Linux/Unix go to the command line and ensure that the database environment is set. To start SQL*Plus just enter the “sqlplus” command. If the program is not found, make sure the ORACLE_HOME is set in the path.

SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. However, SQL doesn't include all the things that normal programming languages have, such as loops and IF...THEN...ELSE statements.

Answered by Hemant Singh , an ibibo Master, at 2:25 PM on August 01, 2008

You may chose to use one of the PL/SQL integrated development environments such as TOAD, PL/SQL Developer or Oracle’s new Raptor . For a new developer we recommend using SQL*Plus because it is simple and will keep you from confusing PL/SQL errors and the tool errors. You will find that the first thing a developer needs to do is understand the Oracle and PL/SQL error messages . Remember, a development tool can make error messages harder to understand.

The first step is to start SQL*Plus and connect to the database. In Windows, open a terminal window. In Linux/Unix go to the command line and ensure that the database environment is set. To start SQL*Plus just enter the “sqlplus” command. If the program is not found, make sure the ORACLE_HOME is set in the path.

SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. However, SQL doesn't include all the things that normal programming languages have, such as loops and IF...THEN...ELSE statements.

Answered by R.P. Singh , an ibibo Master, at 6:44 PM on July 24, 2008

You may chose to use one of the PL/SQL integrated development environments such as TOAD, PL/SQL Developer or Oracle’s new Raptor . For a new developer we recommend using SQL*Plus because it is simple and will keep you from confusing PL/SQL errors and the tool errors. You will find that the first thing a developer needs to do is understand the Oracle and PL/SQL error messages . Remember, a development tool can make error messages harder to understand.

The first step is to start SQL*Plus and connect to the database. In Windows, open a terminal window. In Linux/Unix go to the command line and ensure that the database environment is set. To start SQL*Plus just enter the “sqlplus” command. If the program is not found, make sure the ORACLE_HOME is set in the path.

SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. However, SQL doesn't include all the things that normal programming languages have, such as loops and IF...THEN...ELSE statements.

Answered by Rocky , an ibibo Master, at 12:31 PM on July 22, 2008

For a new developer we recommend using SQL*Plus because it is simple and will keep you from confusing PL/SQL errors and the tool errors. You will find that the first thing a developer needs to do is understand the Oracle and PL/SQL error messages . Remember, a development tool can make error messages harder to understand.

The first step is to start SQL*Plus and connect to the database. In Windows, open a terminal window. In Linux/Unix go to the command line and ensure that the database environment is set. To start SQL*Plus just enter the “sqlplus” command. If the program is not found, make sure the ORACLE_HOME is set in the path.

SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. However, SQL doesn't include all the things that normal programming languages have, such as loops and IF...THEN...ELSE statements.

PL/SQL is a normal programming language that includes all the features of most other programming languages. But, it has one thing that other programming languages don't have: the ability to easily integrate with SQL.

Some of the differences:

* SQL is executed one statement at a time. PL/SQL is executed as a block of code.
* SQL tells the database what to do (declarative), not how to do it. In contrast, PL/SQL tell the database how to do things (procedural).
* SQL is used to code queries, DML and DDL statements. PL/SQL is used to code program blocks, triggers, functions, procedures and packages.
* You can embed SQL in a PL/SQL program, but you cannot embed PL/SQL within a SQL statement.

For more details -

http://www.orafaq.com/wik i/PL/ SQL_FAQ#What_is_the_difference _betw een_SQL_and_PL.2FSQL.3F

Answered by Sharad Singh , an ibibo Master, at 3:54 PM on July 21, 2008

You may chose to use one of the PL/SQL integrated development environments such as TOAD, PL/SQL Developer or Oracle’s new Raptor . For a new developer we recommend using SQL*Plus because it is simple and will keep you from confusing PL/SQL errors and the tool errors. You will find that the first thing a developer needs to do is understand the Oracle and PL/SQL error messages . Remember, a development tool can make error messages harder to understand.

The first step is to start SQL*Plus and connect to the database. In Windows, open a terminal window. In Linux/Unix go to the command line and ensure that the database environment is set. To start SQL*Plus just enter the “sqlplus” command. If the program is not found, make sure the ORACLE_HOME is set in the path.

SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. However, SQL doesn't include all the things that normal programming languages have, such as loops and IF...THEN...ELSE statements.

Answered by Raksha , an ibibo Master, at 9:45 AM on July 18, 2008

You may chose to use one of the PL/SQL integrated development environments such as TOAD, PL/SQL Developer or Oracle’s new Raptor . For a new developer we recommend using SQL*Plus because it is simple and will keep you from confusing PL/SQL errors and the tool errors. You will find that the first thing a developer needs to do is understand the Oracle and PL/SQL error messages . Remember, a development tool can make error messages harder to understand.

The first step is to start SQL*Plus and connect to the database. In Windows, open a terminal window. In Linux/Unix go to the command line and ensure that the database environment is set. To start SQL*Plus just enter the “sqlplus” command. If the program is not found, make sure the ORACLE_HOME is set in the path.

SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. However, SQL doesn't include all the things that normal programming languages have, such as loops and IF...THEN...ELSE statements.

Answered by Ni .. , an ibibo Master, at 12:50 AM on July 18, 2008

You may chose to use one of the PL/SQL integrated development environments such as TOAD, PL/SQL Developer or Oracle’s new Raptor . For a new developer we recommend using SQL*Plus because it is simple and will keep you from confusing PL/SQL errors and the tool errors. You will find that the first thing a developer needs to do is understand the Oracle and PL/SQL error messages . Remember, a development tool can make error messages harder to understand.

The first step is to start SQL*Plus and connect to the database. In Windows, open a terminal window. In Linux/Unix go to the command line and ensure that the database environment is set. To start SQL*Plus just enter the “sqlplus” command. If the program is not found, make sure the ORACLE_HOME is set in the path.

SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. However, SQL doesn't include all the things that normal programming languages have, such as loops and IF...THEN...ELSE statements.

PL/SQL is a normal programming language that includes all the features of most other programming languages. But, it has one thing that other programming languages don't have: the ability to easily integrate with SQL.

Some of the differences:

* SQL is executed one statement at a time. PL/SQL is executed as a block of code.
* SQL tells the database what to do (declarative), not how to do it. In contrast, PL/SQL tell the database how to do things (procedural).
* SQL is used to code queries, DML and DDL statements. PL/SQL is used to code program blocks, triggers, functions, procedures and packages.
* You can embed SQL in a PL/SQL program, but you cannot embed PL/SQL within a SQL statement.

For more details -

http://www.orafaq.com/wiki/PL/ SQL_FAQ#What_is_the_difference_betw een_SQL_and_PL.2FSQL.3F

Answered by Nagendra , an ibibo Master, at 7:17 PM on July 17, 2008

well, SQL is a standard interactive and programming language for querying and modifying data and managing databases. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language. The core of SQL is formed by a command language that allows the retrieval, insertion, updating, and deletion of data, and performing management and administrative functions. SQL also includes a Call Level Interface (SQL/CLI) for accessing and managing data and databases remotely.

The first version of SQL was developed at IBM by Donald D. Chamberlin and Raymond F. Boyce in the early 1970s. This version, initially called SEQUEL, was designed to manipulate and retrieve data stored in IBM's original relational database product, System R. The SQL language was later formally standardized by the American National Standards Institute (ANSI) in 1986. Subsequent versions of the SQL standard have been released as International Organization for Standardization (ISO) standards.

Originally designed as a declarative query and data manipulation language, variations of SQL have been created by SQL database management system (DBMS) vendors that add procedural constructs, control-of-flow statements, user-defined data types, and various other language extensions. With the release of the SQL:1999 standard, many such extensions were formally adopted as part of the SQL language via the SQL Persistent Stored Modules (SQL/PSM) portion of the standard.

Answered by Romi , an ibibo Master, at 12:17 PM on July 16, 2008

Well Tanu , Both SQL and PL/SQL are languages used to access data within Oracle databases.

SQL is a limited language that allows you to directly interact with the database. You can write queries (SELECT), manipulate objects (DDL) and data (DML) with SQL. However, SQL doesn't include all the things that normal programming languages have, such as loops and IF...THEN...ELSE statements.

PL/SQL is a normal programming language that includes all the features of most other programming languages. But, it has one thing that other programming languages don't have: the ability to easily integrate with SQL.

Some of the differences:

* SQL is executed one statement at a time. PL/SQL is executed as a block of code.
* SQL tells the database what to do (declarative), not how to do it. In contrast, PL/SQL tell the database how to do things (procedural).
* SQL is used to code queries, DML and DDL statements. PL/SQL is used to code program blocks, triggers, functions, procedures and packages.
* You can embed SQL in a PL/SQL program, but you cannot embed PL/SQL within a SQL statement.

For more details , Please visit the source site :

http://www.orafaq.com/wiki/PL/ SQL_FAQ#What_is_the_difference_betw een_SQL_and_PL.2FSQL.3F

Answered by Alok Gupta , an ibibo Guru, at 12:14 PM on July 14, 2008

SQL is a standard interactive and programming language for querying and modifying data and managing databases. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language. The core of SQL is formed by a command language that allows the retrieval, insertion, updating, and deletion of data, and performing management and administrative functions. SQL also includes a Call Level Interface (SQL/CLI) for accessing and managing data and databases remotely.

Answered by Reeta K , an ibibo Master, at 7:47 PM on July 12, 2008