How many characters can a SQL Query have? OracleDB and SQL Server

I'm working on a feature in a Java application that builds a query based on a LOG table.

This LOG table basically has the history of created entities, storing all PK columns and their values.

This feature basically adds an intermediary filter where the user can tell me something like:

"Here are the entity X and date Y. Go to the log table, find all PKs of entity X since the date Y, then go on the Entity X's table and bring me all the data based on the PKs that you've get on the last step."

This is why I cannot paginate :(. I need to find all PKs since date Y.

I'm facing the following situation:

Imagine that my log table has 5,000 creation logs of the TB_WINDOWS table. The table TB_WINDOWS has a composite key with 3 columns ID(NUMBER), CREATED_BY(NUMBER), CREATED_AT(DATE).

So the query will have at least:

• At least 10,000 AND clauses (AND.size() * 10,000 = 30,000 characters)

• At least 5,000 OR clauses (OR.size() * 5,000 = 10,000 characters)

• At least 30,000 () braces

• At least 110,000 characters (( ID.size() + CREATED_BY.size() + CREATED_AT.size() ) * 5,000 = 110,000).

So, imagine the query looking like this:

-- In this example I'm using Oracle's TO_DATE.
-- But as I said, I need to know about Oracle and SQL Server
-- So, just take this as an example.
SELECT
	*
FROM
	TB_WINDOWS
WHERE
	(ID = 1
		AND CREATED_BY = 2
		AND CREATED_AT = TO_DATE('a date', 'a format') )
	OR (ID = 2
		AND CREATED_BY = 3
		AND CREATED_AT = TO_DATE('a date', 'a format') )
	OR (.....)
    OR (.....)
    OR (.....)
    -- And many other OR clauses

We can say that this query will have more than 180,000 characters.

My question is, does ORACLE and SQL Server have a limitation on the number of characters that a SQL Query can have?

You risk serious trouble to run your code in production. Oracle shares SQL statements and their exec plan. Therefore every every SQL hard-parsing requires exclusive lock in shared memory resources. This can be a problem when a chunk of memory you want to allocate is HUGE. I saw DB system crashes cased by situation when heavily loaded system tried to allocate memory in shared area, trying to parse 15MB SQL statement.

Generally this approach (used by Hibernate for example) is discouraged.
There were various articles written about "Dynamic where clause problem" in Oracle. It is much safer to store your data in temporary table - for example.