This Training is built with the purpose of sharing the knowledge of PLSQL with others.
Please let us know if you need any specific information in this training.
You are most welcome to share your knowledge with me, send me
your comments about this training.
or any suggestions to improve the site to below mentioned email id.
...
Tuesday, December 23, 2014
Select Clause In sql
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...
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...
Months_between in Sql
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...
SQL COMMAND IN ORACLE
1.Group By Clause
1.Group By Clause
2. Months_between
3.Select Clause
4. Create User In Oracle
5.View In Oracle
6. Conversion Function In Oracle
7.Add Comments On a Table
8.How to find the Nth highest salary from a table in SQL?...
Alter Table In Sql
SQL ALTER TABLE Statement
The SQL ALTER TABLE command is used to modify the definition (structure) of a table by modifying the definition of its columns. The ALTER command is used to perform the following functions.
1) Add, drop, modify table columns
2) Add and drop constraints
3) Enable and Disable constraints
Syntax to add a column
ALTER TABLE...
Tuesday, December 16, 2014
Anonymous blocks
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
...
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)...
Contact Us
This tutorial is built with the purpose of sharing the knowledge of PLSQL/SQL with others. Let us know ,if you need any specific opic to be added in this tutorial.You can also share your knowledge with us,send your comments,feedback about this tutorial,any suggestion on how to be improve the site to below mentined email-id
Email-id:- hemalatamm...
Sunday, December 14, 2014
Text Function/Replace Function In Oracle
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...
Replace Function In Oracle
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...
Sql substring Function in oracle
Substr: The oracle substr function allows you to extract a substring .
The syntax for the oracle substr is as follows:-
substr(string,start_position,[ length])
SQL> select substr('santosh chaurasia',2,6) from dual;
SUBSTR
------
antosh
sql> select substr('priyaseth',4) from dual;
SUBSTR
------
antosh
SQL> select substr('avinashkare',-4)...
Friday, December 12, 2014
Invoke Procedure From Procedure
CREATE OR REPLACE PROCEDURE ANNSAL(P_SAL IN NUMBER,P_ANNSAL OUT NUMBER)
IS
BEGIN
P_ANNSAL :=P_SAL*12;
END ANNSAL;
/
CREATE OR REPLACE PROCEDURE EMPSAL(P_ID IN NUMBER)
IS
V_SAL NUMBER;
V_ANNSAL NUMBER;
BEGIN
SELECT SALARY INTO V_SAL FROM EMPLOYEES WHERE EMPLOYEE_ID=P_ID;
ANNSAL(V_SAL,V_ANNSAL);
DBMS_OUTPUT.PUT_LINE('SALARY...
Thursday, December 11, 2014
C programming Example
(adsbygoogle = window.adsbygoogle || []).push({});
-- Write a c Program to find largest among three numbers.
#include<stdio.h>
#include<conio.h>
void main()
{
int num1,num2,num3,highest;
clrscr();
printf("Enter first number");
scanf("%d",&num1);
printf("Enter second number");
scanf("%d",&num2);
printf("Enter...
Tuesday, December 9, 2014
Create Views ,Sequences in oracle,Simple Views,Complex Views
CREATING
OTHER SCHEMA OBJECTS
There are several
objects in a database in addition to tables.In this blog you will learn
About indexes,and
synonyms.
You can present logical separation of data by creating views
of tables.
With views,you can
represent and hide data from tables.
You can use
sequence to produce unique numbers.
A...