Daily Archives: September 6, 2013

SQL is a most common uses database for small and medium size database. Some times we are fetching problem for generate report from SQL database, here I will show to you how How Generate SQL Report from Table.This is a very simple query & it is also for beginner. stay with us & search the blog for more SQL related post.
Lets See…..
we will generate report from the table name is :emp.dept and others are table field. So data will be generate from emp.dept table.

select ename,job,dept.dname,sal from emp.dept
where dept.DEPTNO=emp.DEPTNO
and upper(dept.DNAME)=upper(:dname);