Advertisement
shreyjain

centralcdb_admin_service

Oct 28th, 2021
1,364
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ALTER SESSION SET container = pdbcs current_schema = admin;
  2. ALTER TABLE centralcdb_admin_service ADD db_available VARCHAR(3);
  3. UPDATE centralcdb_admin_service SET db_available = 'yes';
  4.  
  5. CREATE OR REPLACE editioning VIEW centralcdb_admin_service AS SELECT * FROM centralcdb_admin_service$;
  6. col name FOR a30
  7. col db_available FOR a3
  8. SELECT name, db_available FROM centralcdb_admin_service;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement