Live ORACLE

This example illustrate how to remove a value from LOV after selecting it ( removing from the LOV not from the Database ) the point here is making restriction on values duplication in case we select the value again from the LOV that post his values on unique filed.





download the fmb file from this link :-


-------------------------
For more details , have a look for the codes :-

you must first to create this table on your Database:

CREATE GLOBAL TEMPORARY TABLE reg (
region_id NUMBER , region_name VARCHAR2(25)
) ON COMMIT DELETE ROWS;


and then do this in your Oracle Forms :






That's ALL , have a nice day.

Delete Value from LOV after selecting it

http://www.oracle.com/webapps/online-help/reports/

Oracle Reports Online Help (Help Contents)

http://www.oracle.com/webapps/online-help/forms/

Oracle Forms Online Help

Look Inside >>  July/August 2009

Oracle Magazine - July/August 2009

SELECT last_name,
       Extract(YEAR FROM (SYSDATE
                            - hire_date) year to month)
       ||' years '
       ||Extract(MONTH FROM (SYSDATE
                               - hire_date) year to month)
       ||' months' "Interval"
FROM   employees;

OUTPUT :-

The Employee's Period by years and months

SELECT Sys_context(
                 'USERENV','SESSION_USER')
FROM   dual;

Know the Current USER of your Session by SQL Statement

DECLARE

 TYPE definition IS RECORD(word VARCHAR2(20),

                            meaning VARCHAR2(200));

 TYPE dictionary IS VARRAY(2000) OF DEFINITION;

 lexicon  DICTIONARY := Dictionary();

 PROCEDURE Add_entry

      (word_list  IN OUT NOCOPY DICTIONARY)

 IS

 BEGIN

   Word_list(1).word := 'aardvark';

 

   Lexicon(1).word := 'aardwolf';

 END;

BEGIN

 lexicon.extend;



 Add_entry(lexicon);



 dbms_output.Put_line(Lexicon(1).word);

END;

/

OUTPUT :-

aardwolf

PL/SQL procedure successfully completed.

Aliasing from Passing Global Variable with NOCOPY Hint

CREATE OR REPLACE PROCEDURE Create_dept

     (v_deptno  NUMBER,

      v_dname   VARCHAR2,

      v_mgr     NUMBER,

      v_loc     NUMBER)

AUTHID current_user

AS

BEGIN

  INSERT INTO departments

  VALUES     (v_deptno,

              v_dname,

              v_mgr,

              v_loc);

END;

/


CALL create_dept(44, 'Information Technology', 200, 1700);

Specifying Invoker's Rights With a Procedure