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 Execution...
What is PLSQL
Sunday, December 28, 2014
Forward Declaration
In the Event that you have more than one local declared procedure orFunction within a block of Pl sql and the procedure must reference eachOther, 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 specifythe interface...
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 the...
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 oneor more columns.SyntaxThe syntax for the oracle group by clause isselect expression1,expression2,......expression_n,aggregate_function(expression)from tableswhere conditionsgroup 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 ComputerConcate Function:--The syntax for the oracle concat function is :concat(string1,string2)Parameters...
Sunday, December 14, 2014
Replace Function 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 ComputerConcate Function:--The syntax for the oracle concat function is :concat(string1,string2)Parameters...
Tuesday, December 9, 2014
Learn - Sql-Queries
SQL TutorialSQL (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 myknowledge on SQL and help you learn SQL better. The sql concepts discussed in this tutorial can be applied...
