New answers tagged

1

First of all check whether your pluggable database is opened or not. SQL> select name, open_mode from v$pdbs where name='PDBORCL'; If it is in mounted mode then, SQL> alter pluggable database pdborcl open; Now on SQL Developer Create new connection as, Connection Name: demo-pdborcl Username: demo Password: ***** Connection Type: Basic(If you ...


1

I do not think that the check is needed on delete. So create a trigger like: CREATE OR REPLACE TRIGGER check_session_timing BEFORE INSERT OR UPDATE ON sessions FOR EACH ROW BEGIN if :new.SessionDay = 'Saturday' or :new.SessionDay = 'Sunday' then raise_application_error(-20001, 'Out of business hours – this transaction has not ...


0

The reason you are not seeing any results is that the FOR loop is not returning any rows as there is no owner called 'O'. To select all the table for a user who is not the logged in user you could use; FOR t IN (SELECT t.table_name, t.owner FROM all_tables t where owner <> USER) However you will get a failure almost immediately as MAX(DATE) ...


0

This import file is an export done with a tool such as exp73, exp or expdp. The manner of importing data you are referring to when you have data in an excel sheet with coma separated value, SQL developer will create a large insert statement with the data for you and run it, which will populate a table. What you want to do is to use oracle import tools such ...



Top 50 recent answers are included