Lodewijk
Lodewijk

Reputation: 2391

Force a query timeout in Oracle

I'm looking for the oracle equivalent for WAITFOR DELAY in MsSql so I can test what happens when I get a timeout in my scripts.

Upvotes: 3

Views: 1522

Answers (1)

Lodewijk
Lodewijk

Reputation: 2391

Silly, typing this question gave me the perfect google query which lead met to this answer:

BEGIN
    dbms_lock.sleep(5);
END;

Upvotes: 6

Related Questions