Hi all!
So here is a problem refering at empty set:
How i can, first, verify if my column(respecti ve table) is empty, has now rows in it, and, second, after the verification set a value to it.
Example:
Having table: tableA
with columns: id_tableA, columnA, columnB
and no value's in it, absolutly empty.
Need something like this(writing in text language)
IF IS_EMPTY(tableA .columnA)
THEN tableA.column = 0
Also, need to specify that: columnA is 'float' type.
Any help will be greatly apreciated.
Thx in advance!
So here is a problem refering at empty set:
How i can, first, verify if my column(respecti ve table) is empty, has now rows in it, and, second, after the verification set a value to it.
Example:
Having table: tableA
with columns: id_tableA, columnA, columnB
and no value's in it, absolutly empty.
Need something like this(writing in text language)
IF IS_EMPTY(tableA .columnA)
THEN tableA.column = 0
Also, need to specify that: columnA is 'float' type.
Any help will be greatly apreciated.
Thx in advance!
Comment