Genova Nutreval

(Event EventID, EventGroup eventGroupId)

select * from event_page_event_comments where eventcategoryid= @eventCategory

How to remove Events without event categories?

Also the syntax is changed and now I have to convert my varchar value into a datetime in my page.

ALTER EVENT ENTIRELY AND/OR LIFETIME TYPE or 'CHAR' in EventTag as TIMESTAMP NOT NULL

I tested just now about this - (string) %20((Select 1 from v$TimeDim p))) as = '00:00:%R'; inside my v$session.create; line on my code and still it doesn't work.

Is there any syntax that I can use to remove events without category?

There are multiple ways of doing this, one is:

WITH Cte AS (

SELECT ENTRY_ID, ENTRY_GUID, START_TIME, END_TIME

FROM ENCODING

WHERE EVENT_GUID='PK_ENTRY_ID'

SELECT ENTRY_ID, ENTRY_GUID

FROM Cte

WHERE TSTAMP=@@TIMESTAMP

but if you really want to add an event category ID to a single row, you can do this manually by doing something like:

ALTER EVENT ENTIRELY AND/OR LIFETIME TYPE or ('CHAR' IN ATTRIBUTES(EVENT_CATEGORY_ID));

As for changing your trigger method, remember that you can't do this with older versions of ORACLE only with 2014+ versions when it was renamed trigger types.