-
Hi, All:
I am currently migrating a SQL Server stored procedure to Oracle stored procedure:
In SQL Server, we use
IF EXISTS(...)
BEGIN
...
END
ELSE
BEGIN
...
END
I don't know how to efficiently do the EXISTS check in Oracle, so what I did is define a counter variable, and do like this:
SELECT COUNT(*) INTO v_counter1
FROM ...
WHERE ...;
IF v_counter1 = 0 THEN
...
ELSE
...
END IF;
Though I don't think it is efficient because if there are many records in the table satisfy the condition, it will take a long time to count the number. Really I don't need the number but just if there is just one case.
I know my way is stupid, just give some recommendations.
Thanks a lot!
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
|
Click Here to Expand Forum to Full Width
|