• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

What is the maximum number of characters can be in a select union query

I have created a dynamic query which when executed against the database it returns a message stating "Query to complex"

what is the maximum number of characters can a query contain.

by the way my query contains 89,999 characters
0
visualbasic
Asked:
visualbasic
1 Solution
 
peter57rCommented:
max characters in a sql statement is 64K.

0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now