New answers tagged sqlplus
0 votes
How to override >2499 character error in Oracle DB?
in SQL prompt Just -set define off; then run the sql query
- 11
0 votes
How to know whether the created view is valid or not
Oracle makes it super easy as it includes a STATUS column to indicate if database objects in your schema (including views) are valid or not: SELECT OBJECT_NAME, OBJECT_TYPE, STATUS FROM USER_OBJECTS ...
- 5,377
Top 50 recent answers are included