I am new to SQL and I am using ORACLE SQL PLUS - I need to report the query execution time. There are so many pages that I can not get to the end. When I change preferences to single page, it get a message that says my query is too large. Is there a statement I can use to get to the end of my query to report the execution time? My Set Timing On is on the first page of programming and I can view the lapse time on all of the pages before this one. Here is my coding:
When MY_PRODUCTS_CE2 contains M rows and PRODUCT_SUMMARY_V contains N rows, your query will return M*N rows (all row combinations).
It is because you did not join rows from both tables (specify, which rows shall be put together).
As you did not post the table structures and the desired result, you shall find this condition yourself.
As you did not post your Oracle version, you shall search the Oracle documentation for more details (SQL Reference).
> When I change preferences to single page, it get a message that says my query is too large.
What exactly did you do? Do you not use some reporting tool; as I am not aware about 'Preferences' whatever in SQL*Plus.
> I can use to get to the end of my query to report the execution time?
If the query resultset contains many rows, you shall wait till they are all written (may take a long while). Or do you want to see only the elapsed time, not the resultset?