Posts by Andrey Hideki Nakano • 141 points
6 posts
-
0
votes0
answers314
viewsQ: Oracle conversion of LONG RAW to BLOB
I tried to use TO_LOB to convert the value LONG RAW in the insert but returns: ORA-00932 inconsistent datatypes tips Fate is a column BLOB of a table already in use of the system and its type cannot…
oracleasked Andrey Hideki Nakano 141 -
1
votes2
answers5894
viewsA: How to display the status on a geochart?
google.load('visualization', '1', { 'packages': ['geochart', 'table'] }); google.setOnLoadCallback(drawRegionsMap); function drawRegionsMap() { var data = google.visualization.arrayToDataTable([…
google-chartsanswered Andrey Hideki Nakano 141 -
2
votes1
answer9153
viewsQ: SQL Convert minutes to minutes:minutes:seconds
How to convert a value in minutes in oracle to the time:minutes:seconds format?
-
5
votes1
answer9153
viewsA: SQL Convert minutes to minutes:minutes:seconds
Convert minutes to hour:min:sec format, for example 1000 minutes converted would be 16:40:00 SELECT TO_CHAR(TRUNC((MINUTES * 60) / 3600), 'FM9900') || ':' || TO_CHAR(TRUNC(MOD((MINUTES * 60), 3600)…
-
3
votes3
answers3337
viewsA: INNER JOIN is duplicating record
Analyzing the structure I believe it to be as follows (account) 1 - N (immovable) 1 - N (photos) Where we have an account with several properties, and one property has several photos. With Inner…
-
3
votes2
answers29844
viewsA: Convert date to dd/MM/yyyy ORACLE
We can use the year format RRRR, which makes the recognition of the century to convert the year being necessary only 2 digits, for example 50 as we have not yet reached 2050 will be converted to the…