mosheg
Administrator
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
mosheg Administrator
Reactions
-
Re: If the sql text is saved in a table how to search for particular text using like operator
In addition, Standard conforming strings must be ON to use Unicode-style string literals (U&'\nnnn'). For example: SET ESCAPE_STRING_WARNING TO OFF; -- Do not issue a warning when a backslash is … (View Post)1 -
Re: Need to add column with max value placed in the max date of each weekending
SET DATESTYLE TO DMY;\set StartDate '''01-Jan-2022'''\set EndDate '''01-FEB-2022'''CREATE TABLE t30 ASSELECT 'A' || CHR(RANDOMINT(5) + 97) || '12345' AS UserName, DAYOFWEEK(dt) AS DayNumberInWeek, RA… (View Post)1 -
Re: Vertica Query to find and subtract skips in time
set datestyle to DMY;select *, datediff('second', start_time_utc, lag(end_time_utc) over (order by start_time_utc) ) as skip_time_sfrom skip_timeorder by user_name,row; user_name | start_date | start… (View Post)1 -
Re: How to overcome "DDL statement interfered with this statement"
Hello Keren, An object acquires an O lock (Owner lock) in some DDL operations, such as DROP_PARTITIONS, TRUNCATE TABLE, and ADD COLUMN. When an object is locked in O mode, it cannot be locked simulta… (View Post)1 -
Re: How to read first element from an arraylist which is stored as varchar
Another example on v11.0.2 CREATE TABLE orders( orderid INT, shipments ARRAY[VARCHAR(100)]);SET ESCAPE_STRING_WARNING TO OFF;SET STANDARD_CONFORMING_STRINGS TO OFF;COPY orders FROM STDIN DELIMITER '#… (View Post)1