I've noticed that there are the following date
functionsdays_betweenmonths_betweenyears_betweenbut there isn't a
weeks_between equivalent. Is this an intentional decision to omit this
functionality? I'm having to resort to a personal implementation t...
Hi, I'm seeing some slightly odd behaviour when casting to decimal.
Please see the below example. Why is it that if we provide an explicit
figure it rounds and then truncates whereas if we provide and expression
it decides to simply truncate? select ...
Please! Please! Please! can someone enlighten me as to how to call these
2 wrapper functions from the dbVisualizer script window? for data in
wrapper:query_rows( 'SELECT * FROM CAT' ) do output( data.TABLE_NAME ..
data ) end for table_name, table_...
Hi, I'm a beginner with regards to Exasol scripting with Lua. I've been
through the course material for fundamentals and database development,
but am struggling with one aspect. That is the use of query results with
Lua. Once I have this aspect unloc...
Hi, I was wondering if I could get some help with string manipulation.
If i'm provided with the following example Create a function
add_prefix(arr, prefix) that takes an array of strings arr and a string
prefix as an input. It should output a comma-s...
So that's quite similar to SQL Server reservation and cap of memory per
instance installation.One thing we also noticed recently is that if you
are on the RAM based license model and purchase e.g. 4GB license then
that is NOT 4GB per node, but 4GB to...
I've just found these resources that mention a slight issue with DOUBLE
I just read this on the following doc link
Data TypesExasol supports approximately and exact numerical data types.
The difference when using the approximate data types aris...
I was after the result '99.1' after it having been rounded up to 1
decimal place. Key is to use the explicit round function before
casting.create or replace view my_schema.DataTypes as select
cast(5943.00/cast(60.00 as decimal(10,2)) as decimal(10,2)...