SELECT onwer, status FROM all_triggers WHERE trigger_name ='<trigger name>';
SELECT owner FROM all_tables WHERE table_name = '<table name>';

SELECT * FROM all_triggers WHERE trigger_name ='PITRIGGER';
SELECT * FROM all_tables WHERE table_name = 'PERSONAL_INFORMATION';

ALTER SYSTEM SET NLS_DATE_FORMAT='YYYY/MM/DD' SCOPE=SPFILE;

SELECT USER, instance_name, host_name FROM v$instance;

SQL> conn user1/user1 @myNSN
Connected.
SQL> SELECT USER, instance_name, host_name FROM v$instance;
SELECT USER, instance_name, host_name FROM v$instance
                                           *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> conn user1/user1 @myNSN as sysdba
Connected.
SQL> SELECT USER, instance_name, host_name FROM v$instance;

USER                           INSTANCE_NAME
------------------------------ ----------------
HOST_NAME
----------------------------------------------------------------
SYS                            xe
PC32

DECLARE
CURSOR test_cur IS SELECT user, instance_name, host_name FROM v$instance;
BEGIN
FOR test_rec IN test_cur LOOP
DBMS_OUTPUT.PUT_LINE (test_rec.user  || ' ' || emp_test.instance_name || ' ' ||test_rec.host_name);
END LOOP;
END;

Error 201 at line 2, column 62
  identifier 'V$INSTANCE' must be declared

grant select on v$instance to user1;

SQL> conn user2/user2@myNSN as sysdba
Connected.
SQL> grant select on v$instance to user1;
grant select on v$instance to user1
                *
ERROR at line 1:
ORA-02030: can only select from fixed tables/views

grant select on v_$instance to user1;

SQL> conn user1/user1 @myNSN
Connected.
SQL> create table testtable (sn number primary key, name varchar2(20));

Table created.

SQL> create sequence testseq;

Sequence created.


SQL> ed
Wrote file afiedt.buf

  1  create trigger testtrgr
  2  before insert on testtable
  3  for each row
  4  begin
  5  select testseq.nextval into :new.sn from dual;
  6* end;
SQL> /

Trigger created.

SQL> select owner from all_triggers where trigger_name='TESTTRGR';


OWNER
------------------------------
USER1

SQL> select owner from all_tables where table_name='TESTTABLE';

OWNER
------------------------------
USER1

FRM 40202: Field must be entered.

begin
  forms_ddl('alter session set NLS_date_format = ''yyyy/mm/dd''');
end;