In this tutorial, you will learn about the PL/SQL block structure and how to write and execute the first PL/SQL block in SQL*PLUS.Let’s examine the PL/SQL block structure in Detail
[DECLARE]
Declaration statements;
BEGIN
...
What is PLSQL
Sunday, December 28, 2014
Forward Declaration
In the Event that you have more than one local declared procedure or
Function within a block of Pl sql and the procedure must reference each
Other, you won't be able to compile your code without getting an error.
Each local procedure must be declared before the other.
To get around this problem, you can use a forward declaration to specify
the...
Monday, December 22, 2014
What is a PLSQL Block
In
this tutorial, you will learn about the PL/SQL block structure and how
to write and execute the first PL/SQL block in SQL*PLUS.Let’s examine
the PL/SQL block structure in Detail
[DECLARE]
Declaration statements;
BEGIN
...
Months_between Function In Oracle
The months_between function calculates the number of months between two dates. When the two dates have the same day component or are both last day of the month,then the return value is a whole number.otherwise ,the return value includes a fraction that considers the differance in the days based on a day-month.Syntax:-The syntax for the...
MOnths_between
The months_between function calculates the number of months between two dates. When the two dates have the same day component or are both last day of the month,then the return value is a whole number.
otherwise ,the return value includes a fraction that considers the differance in the days based on a day-month.
Syntax:-
The syntax for...
Thursday, December 18, 2014
Group By Clause In SQL
The oracle group by clause is used in a select statement to gather data across multiple records and group the results by one
or more columns.
Syntax
The syntax for the oracle group by clause is
select expression1,expression2,......expression_n,
aggregate_function(expression)
from tables
where conditions
group by expression1,expression2,......expression_n;
Arguments...
Tuesday, December 16, 2014
Cursor With Parameter in Oracle
-- In PLSQL we can pass the parameters into a cursor and use them in to query.
Pl/sql parameterized cursor define only datatype of parameter and not need to define it's length.
The following example introduce the cursor with parameter.
DECLARE
CURSOR EMPCUR(deptno NUMBER)
IS
SELECT EMPLOYEE_ID,HIRE_DATE,SUM(SALARY)...
Monday, December 15, 2014
Functions in sql
Trim :- Removes leading and /or trailing blanks(or other characters ) from a string.
Syntax:- TRim([[<trim_spec >] char ]
SQL> select trim(' Aptech Computer') from dual;
Returns the following result.
TRIM('APTECHCOM
---------------
Aptech Computer
Concate Function:--
The syntax for the oracle concat function is :
concat(string1,string2)
Parameters...
Tuesday, December 9, 2014
Learn - Sql-Queries
SQL Tutorial
SQL (Structured Query Language) is used to modify and access data or information from a storage area called database.
This beginner sql tutorial website teaches you the basics of SQL and how to write SQL queries. I will be sharing my
knowledge on SQL and help you learn SQL better. The sql concepts discussed in this tutorial can...
