Programs: 34 | Andy Archer homepage
 |
This is a stored procedure for Oracle SQL servers for limiting user result views
|
21 October 2010, 20:05 GMT
Downloads: 210 |
 |
This is an Oracle DB SQL script to find the highest and/or lowest values inside a table column
|
21 August 2010, 22:39 GMT
Downloads: 233 |
|
This is a package of Oracle DB SQL scripts to find duplicate values among table rows
|
21 August 2010, 21:14 GMT
Downloads: 223 |
|
This is a Oracle DB-complaint SQL script to search the database and return the names of all tables with a particular column data value
|
21 August 2010, 17:12 GMT
Downloads: 254 |
|
This SQL Oracle-complaint script will scan a database and return all table names containing a specific column
|
20 August 2010, 23:54 GMT
Downloads: 222 |
|
This is an SQL script for the Oracle databases to find unique data values stored in different tables
|
20 August 2010, 03:46 GMT
Downloads: 247 |
|
This is an Oracle DB compliant SQL script to find a particular character in a database column
|
18 August 2010, 20:13 GMT
Downloads: 258 |
|
These are 12 very simple examples of how to perform SELECT statements in Oracle DB and limit the number of rows the query returns
|
17 August 2010, 06:57 GMT
Downloads: 235 |
|
This is an Oracle DB procedure to check and see of a table row exists
|
16 August 2010, 08:51 GMT
Downloads: 233 |
|
This is a n SQL stored procedure for Oracle DB to customize number rendering formats
|
01 August 2010, 20:34 GMT
Downloads: 238 |
|
This Oracle SQL script will count the number of decimal and integer places of any number
|
30 July 2010, 00:40 GMT
Downloads: 284 |
|
This is a stored procedure for Oracle DB to generate random numbers
|
12 July 2010, 08:58 GMT
Downloads: 235 |
|
This Oracle DB script will modify the permission structure of the user pool
|
27 June 2010, 13:06 GMT
Downloads: 282 |
|
These are two SQL*Plus scripts to run SQL and find all privileges and roles granted to a specified user or role
|
13 June 2010, 04:26 GMT
Downloads: 400 |
|
This is an Oracle hack to display table Selects in PL/SQL via DBMS_OUTPUT without using any INTO variables
|
09 June 2010, 14:21 GMT
Downloads: 310 |
|
This is a job scheduler for the Oracle database
|
09 June 2010, 13:03 GMT
Downloads: 280 |
|
This is an script to append the date and time to a SQL*Plus output filename
|
05 June 2010, 19:14 GMT
Downloads: 265 |
|
This is an Oracle package to build and run SQL scripts to recompile a schema's invalid server PL/SQL objects
|
17 May 2010, 16:10 GMT
Downloads: 334 |
|
This SQL-Plus (Oracle) script provides a way to log on as another user without having to know their password
|
15 May 2010, 19:09 GMT
Downloads: 355 |
|
This is a Oracle hack to prevent users from accessing the database
|
15 May 2010, 18:58 GMT
Downloads: 323 |
|
This SQL-Plus Oracle script executes a PL/SQL block to kill all sessions except those with an exempt
|
11 May 2010, 02:05 GMT
Downloads: 379 |
|
This is an Oracle script to identify and kill a user session
|
11 May 2010, 00:03 GMT
Downloads: 306 |
|
This is an Oracle script which allows to easily find server object dependencies
|
06 May 2010, 23:03 GMT
Downloads: 425 |
|
This is an Oracle procedure to return details on why and how a procedure has been or is blocked from working
|
06 May 2010, 22:19 GMT
Downloads: 345 |
|
This is an SQL stored procedure to shut down the PC locally or remotely
|
18 April 2010, 21:03 GMT
Downloads: 324 |
|
This is an Oracle PL/SQL script to validate a date to the ISO format of YYYYMMDD, also allowing for an all-zero month and an all-zero day
|
10 April 2010, 00:52 GMT
Downloads: 266 |
|
This is an Oracle PL/SQL script to validate a date to the ISO format of YYYYMMDD
|
09 April 2010, 23:59 GMT
Downloads: 500 |
|
This is an SQL script to round the time values to specific intervals
|
02 April 2010, 21:50 GMT
Downloads: 394 |
|
This PL/SQL stored procedure shows whether or not in_date1 is within a certain number of days (in days), plus or minus, of in_date2
|
02 April 2010, 15:14 GMT
Downloads: 281 |
|
This is an Oracle built-in date functionality which makes it easy to find, for a given date, the first and last days of the week
|
30 March 2010, 13:17 GMT
Downloads: 356 |
|
This PL/SQL stored procedure returns the count of Mondays, Tuesdays, etc. between the two input dates
|
28 March 2010, 02:28 GMT
Downloads: 305 |
|
This PL/SQL stored function returns the number of days between two dates
|
26 March 2010, 20:48 GMT
Downloads: 285 |
|
This is an PL/SQL procedure to compute the difference between two dates
|
26 March 2010, 19:42 GMT
Downloads: 360 |
|
This PL/SQL stored procedure adds time intervals to a stored date
|
23 March 2010, 18:14 GMT
Downloads: 287 |
|
Find us on Google+
