Is it possible to execute big SQL query in Hibernate?

What is the difference between executing query statements using 'execute' and directy in PL and SQL?

• st :='SELECT USERNAME FROM LOGIN WHERE USERNAME =: a and PASSWORD =: b'; execute immediate st into un using username,pw;  - or - SELECT USERNAME INTO un FROM LOGIN WHERE USERNAME = username and PASSWORD = pw; where username, un and pw are varchar2(50) variables

• Answer:

  You can dynamically build a statement string and execute it with EXECUTE statement. When you directly call SELECT .. INTO from PLSQL, such query must be valid at compile time. For example, you can dynamically create a table via EXECUTE, and select from it using EXECUTE again. SELECT .. INTO would fail in this case, as the dynamically created table does not exist yet.