Global Temporary Tables in Oracle
Global temporary table is also a similar table like normal Oracle table but the data in this table is session restricted. Such that data inserted… Read More »Global Temporary Tables in Oracle
Oracle SQL
How to use DML Statements in a Function
We can not place any DML statement inside a function simply and also a function with a DML statement cannot be used inside a SELECT… Read More »How to use DML Statements in a Function
Backward ‘Like’ Statement
SELECT e.empno, e.ename , e.deptno , d.dname FROM emp e, dept d WHERE 1 = 1 AND e.deptno=d.deptno;SELECT e.empno, e.ename , e.deptno , d.dname FROM… Read More »Backward ‘Like’ Statement
SQL Query and Information about Sales Order Line Number
Sales order line number field automatically defaults to 1.1 if this is the first line entered on the order. This field is for display purposes… Read More »SQL Query and Information about Sales Order Line Number
SQL Query to find out Duplicate Customer Contacts
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25… Read More »SQL Query to find out Duplicate Customer Contacts
Oracle SQL Query to list all Form Personalizations
/********************************************************** *PURPOSE: To list all forms personalizations * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT ffv.form_id , ffv.form_name , ffv.user_form_name , ffv.description "Form Description", ffcr.sequence ,… Read More »Oracle SQL Query to list all Form Personalizations
Demobld.sql – Oracle Database seeded table scripts – EMP – DEPT – BONUS – SALGRADE – DUMMY
— — Copyright (c) Oracle Corporation 1988, 2000. All Rights Reserved. — — NAME — demobld.sql — — DESCRIPTION — This script creates the SQL*Plus… Read More »Demobld.sql – Oracle Database seeded table scripts – EMP – DEPT – BONUS – SALGRADE – DUMMY
Oracle SQL Query to list Months and Years
Here is the Query to list Months and Years. I developed this query to prepare a LOV for Credit Card Expiration date. 1 2 3… Read More »Oracle SQL Query to list Months and Years
- « Previous
- 1
- 2