Search results 78

  2. Search results
  3. db
Sorted from new to old.
Card image
Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7
Card image
Most recent in Oracle DB

List the most recently added rows based on a date column.

2020Feb7
Card image
all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

2019Dec22
Card image
Random GUID

Generate a random GUID using oracle db workbench Also add timestamp to ensure ...

2019Dec22
Card image
GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

2019Dec19
Card image
List of Databases

Script to list databases available in a server using ADODB connection From

2019Oct6
Card image
BS Star system

Bootstrap, Font Awesome rating stars system, to replace options for users to ...

2019Sep26
Card image
DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22
Card image
HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

2019May31
Card image
ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14
Card image
ANma_HTML2DB + ANma_DB2HTML + ...

Convert HTML text into DB-safe string, by converting some characters as below. ...

2019Feb7
Card image
DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

2019Feb3
Card image
API in ASP Classic

A simple REST API technique reading record from Access mdb, then generates json ...

2019Feb1
Card image
Admin Counter boxes

4 sets of Admin/Dashboard count boxes, or cards Needed a set for DBRox, and ...

2019Jan31
Card image
Shortner

Create a URL shortner using Web.Config AKA URL Redirect, or Page refresher, ...

2019Jan14
Card image
Shrinking DB

Steps to shrink database in MS SQL

2019Jan6
12345