Ora - 22992 and ora - 02063 error-CodePudding

As shown in figure directly execute the select can be detected data, plus the explain plan for an error, (note: the table without clob fields, are 'character and date type) which show next why?

CodePudding user response:

The explain plan for

In the Command Window in the implementation;

If in the SQL Window, you directly select the select statement, you can press F5 again;

CodePudding user response:

reference 1st floor selling fruit net reply:

the explain plan for

In the Command Window in the implementation;

If in the SQL Window, you directly select the select statement, you can press F5 again;

I know commend window we can see, also can see the SQL window, F5 reported the same mistake as well,

CodePudding user response:

refer to the second floor feng5796863 response:

Quote: refer to 1st floor selling fruit net reply:
the explain plan for

In the Command Window in the implementation;

If in the SQL Window, you directly select the select statement, you can press F5 again;

I know commend window we can see, also can see the SQL window, F5 reported the same mistake as well,

SQL window, just write the select, don't write in front of the explain plan for

CodePudding user response:

reference 3 floor selling fruit net reply:

Quote: refer to the second floor feng5796863 response:

Quote: refer to 1st floor selling fruit net reply:
the explain plan for

In the Command Window in the implementation;

If in the SQL Window, you directly select the select statement, you can press F5 again;

I know commend window we can see, also can see the SQL window, F5 reported the same mistake as well,

SQL window, just write the select, don't write in front of the explain plan for

Very thank you for your answer, but you have a try, can write the explain SQL window, I answer to the second floor with pictures, I don't know you see it

CodePudding user response:

Add that the v_overdue_his_054 contains a dblink in this view, but still use dblink nested, parse SQL will have a problem? Tests are insert can be successful, and insert the data, just an execution plan analysis error,,,