Analytic SQL CAST & VALIDATE_CONVERSION () Function for Data Validation Oracle 12c

HappyCode #0004 : Analytic SQL CAST & VALIDATE_CONVERSION () Function for Data Validation Oracle 12c

 We can currently use the SQL CAST function to convert one datatype to another, 
although currently there is NULL data or it will return a conversion error.

 Which, in the previous version, a data condition containing a NULL value returns an error.



A new function VALIDATE_CONVERSION () can be used to identify if there is a conversion failure will appear, 
we use the value = 0, to validate if there is a possibility of returning an error / containing NULL data



Github : https://github.com/happycodingkoe/database_oracle/tree/master/Readmeshare_0004_ORA_SQLValCast
Blog : https://happycodingkoe.blogspot.com/
IG : @happycodingkoe
FB : https://web.facebook.com/happycoding.koe.3

Komentar

Posting Komentar

Postingan populer dari blog ini

Application can't connect to Oracle 12c Database

Gambar
HappyCode 0001 : Application can't connect to Oracle 12c Database At that time, we received mail that app client can't connect to ORCLPDB which is Oracle DB 12c ,  with this error "ORA-01033: ORACLE initialization or shutdown in progress".  Based on that error code, seems DB is down, so we just crosscheck using DBA access and Yes, DB ORCLPDB is down. So, these are the ways that we used to check and bringup the ORCLPDB database. Github : https://github.com/happycodingkoe/database_oracle Blog : https://happycodingkoe.blogspot.com/ IG : @happycodingkoe FB : https://web.facebook.com/happycoding.koe.3
Baca selengkapnya

Create invisible column in Database Oracle 12c

Gambar
HappyCode #0003 : Create invisible column in Database Oracle 12c Invisible column, in some cases it can help to keep data invisible in general queries (*).  We can take a look from this sample to get some ideas. DROP TABLE city_t ; CREATE TABLE city_t (   id          NUMBER,   name VARCHAR2(100) INVISIBLE,   city VARCHAR2(100)  ); insert into city_t values (1,'my city 1'); insert into city_t (id, name, city) values (2,'Tony','my city 2'); commit ; select * from city_t ; select id, name, city from city_t;  Github : https://github.com/happycodingkoe/database_oracle/tree/master/Readmeshare_0003_ORA_InvisbleCol Blog : https://happycodingkoe.blogspot.com/ IG : @happycodingkoe FB : https://web.facebook.com/happycoding.koe.3
Baca selengkapnya