Scripts used to manipulate, verify and work with Date Columns in the database
Scripts
In this Category :
BETWEEN VALUES
- While using between operator, only values in ascending order are accepted. If values in descending order are given, you get no rows. However, if you use >= and <= operators, you have the privilege to use the range of values either in ascending order or descending order.
new
(Added: 3-Nov-2008 Hits: 0 Rating: 0 Votes: 0) Rate It
Find out what database you are connected to
- This Script will help you to find out which Database you are presently Connected to? If You are working on multiple Databases on different Servers using SQL*Net or Net8
pop
(Added: 9-Apr-2000 Hits: 12208 Rating: 4.92 Votes: 12) Rate It
Removing duplicate rows
- Removes duplicate data from a table.
pop
(Added: 11-May-2000 Hits: 14700 Rating: 8.21 Votes: 19) Rate It
The performing of the above four transactions can be written using the 'if..elsif condition' but the following code is short and simple.
(Added: 6-Jan-2003 Hits: 3148 Rating: 6.08 Votes: 12) Rate It
Alternative for Count(*)
- The script below depicts the use of Rownum
(Added: 26-Jul-2003 Hits: 6207 Rating: 2.00 Votes: 5) Rate It
Bitwise functions
- I got sick and tired of not having bitwise functions for numbers in Oracle so I went ahead and wrote my own.
(Added: 14-Feb-2001 Hits: 5489 Rating: 7.00 Votes: 1) Rate It
Bitwise Math and Masking Functions
- This script performs bitwise math and masking operations on numbers. Performs the bitwise operations "AND", "OR", "XOR" and "NOT"; Turns a mask of bits ON or OFF in a larger array of bits; Tests whether a number is a "single bit" number; Tests whether a mask of bits is ON in a larger array of bits.
(Added: 31-May-2006 Hits: 2147 Rating: 1.00 Votes: 1) Rate It
Comma seperated values - tokenizer
- Procedure for string tokenizer To delimit the string of comma separated values from a string while is comma delimited.
(Added: 20-Jan-2003 Hits: 4083 Rating: 10.00 Votes: 1) Rate It
