-
change from SQL to PL/SQL
Hi,
I am not good at PL/SQL. Anyone can help me to change from SQL to PL/SQL. I am studying in database performance tunning. I have to change from SQL to PL/SQL that will improve performance by doing one time full scan only for LineItem table.
SQL as below:
SELECT COUNT(*)
FROM LINEITEM
WHERE LINEITEM.L_SHIPDATE =
( SELECT MAX(LINEITEM.L_SHIPDATE)
FROM LINEITEM
WHERE LINEITEM.L_SHIPDATE <>
( SELECT MAX(LINEITEM.L_SHIPDATE)
FROM LINEITEM ) );
Anyone pls kindly help me.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|