|
|
-
|
|
The Problem
I was working on an ERP project for an electrical company. As a DBA my main task was to maintain database security and data consistency. A database developer was appointed on the client side to maintain the database. By mistake the developer used an update query in an important monetary......
|
|
-
|
|
SQL BUILT IN FUNCTIONS PART – 2 In my last SQL BUILT IN FUNCTION ARTICLE ASCII & CHAR has been described, today the REPLACE system function provides the functionality of replacing all occurrences of a given value with another value. This system function is valuable for masking processes. If the......
|
|
-
|
|
SQL BUILT IN FUNCTIONS PART –1 The ASCII and CHAR system functions provide the conversion functionality between character values and ASCII code values. These system functions are valuable when iterating through characters, mathematically determining characters and randomly deriving characters. T......
|
|