SELECT * FROM employees ORDER BY EMPLOYEE_ID OFFSET 99 ROWS FETCH NEXT

How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?

Question Posted / rutujagabhane

Answer Posted / rutujagabhane

SELECT *
FROM employees
ORDER BY EMPLOYEE_ID
OFFSET 99 ROWS
FETCH NEXT 21 ROWS ONLY;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to enter binary numbers in sql statements? : Sql dba

921

What is spool?

992

What are properties of the transaction?

957

What is trigger with example?

1012

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

943

Does view store data in sql?

900

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

900

What is the importance of sqlcode and sqlerrm?

1276

what is a stored procedure? : Sql dba

1051

Does a user_objects view have an entry for a trigger?

959

what is row? : Sql dba

1166

Explain what is an index?

999

What are the possible values for the boolean data field?

900

What is crud stand for?

931

what is a trigger in mysql? : Sql dba

1067