how to apply Lov query on button or at any event;--
--
or How to call lov from a button or else; --
-------------------------------------------------------------
Example1:
if show_lov('lov_name') then
null;
end if;
Example2:
declare
a boolean;
begin
a:=show_lov('lov_name');
end;
------------------------------------------------------------
Timer For Oracle forms 6i 9i 10g
The When-Timer-Expired trigger fires when a timer you have previously created in your form, expires.
For example, you create a timer in the when-button-pressed trigger of a button, like this:
DECLARE
timer_id Timer;
one_minute NUMBER(5) := 60000;
BEGIN
timer_id := CREATE_TIMER('emp_timer', one_minute, NO_REPEAT);
END;
60 seconds after the user presses the button, the When-Timer-Expired will fire, and its code will be executed.
When you create more than one timer, you need to check which of your timers expired, because the same trigger will fire, no matter which timer expired. You can use the GET_APPLICATION_PRPERTY built-in for that purpose.
Something like this:
Applied this on when-timer-expired trigger -----------------------
if get_application_property(TIMER_NAME) = 'EMP_TIMER' then
message('timer EMP_TIMER expired');
-- Do something else...
end if;
Copy your Table database into another Table at the same time of Table Input
CREATE OR REPLACE TRIGGER MY_TRIGGER
AFTER INSERT ON EMP FOR EACH ROW
BEGIN
INSERT INTO EMP_COPY -----SECONDARY TABLE
(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES(:NEW.EMPNO,:NEW.ENAME,:NEW.JOB,:NEW.MGR,HIREDATE,SAL,COMM,DEPTNO);
END;
Create User in Oracle SQL with Complete Grants:
* CREATE USER scott --Assign User name
* IDENTIFIED BY tiger -- Assign password
DEFAULT TABLESPACE tools -- Assign space for table and index segments
TEMPORARY TABLESPACE temp; -- Assign sort space
DROP USER scott CASCADE; -- Remove user
GRANT CONNECT, RESOURCE TO scott;
GRANT DBA TO scott; -- Make user a DB Administrator
Remember to give the user some space quota on its tablespaces:
ALTER USER scott QUOTA UNLIMITED ON tools;
Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB Configuration Assistant (dbca). DBA's must unlock these accounts to make them available to users.
Look at these examples:
ALTER USER scott ACCOUNT LOCK -- lock a user account
ALTER USER scott ACCOUNT UNLOCK; -- unlocks a locked users account
ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password
--------------------
SQL> grant connect to alfredo;
sql> alter user alfredo account unlock;
.jpg)
