0

I run following procedure in sql developer window to search all oracle tables for specific string and at the end in Statement Output window it says "anonymous block completed" and now can't understand where is result rows, how to get it?

enter image description here

thanks

Improve this question

1 Answer 1

Reset to default
1

We have option in SQL Developer

and also you have to execute your procedure as below

SET SERVEROUTPUT ON;
begin
    dbms_output.put_line('Testing output');
end;
/

Click ->View->Dbms Output and then click + symbol on Dbms output window. now you can run the procedure and can see output.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.