Tarek Fathy

-********************************************************- - I create and populate the following table: CREATE TABLE my_employees ( last_name VARCHAR2 (100) , salary NUMBER ) / BEGIN INSERT INTO my_employees VALUES ('Smith', 100); INSERT INTO my_employees VALUES ('Silva', 200); INSERT INTO my_employees VALUES ('Singh', 300); INSERT INTO my_employees VALUES ('Chen', 400); INSERT INTO my_employees VALUES ('Corvalis', 500); INSERT INTO my_employees VALUES ('Feuerstein', 600); COMMIT; END; / I then write the following block: DECLARE TYPE namelist_t IS TABLE OF my_employees.last_name%TYPE; l_filters namelist_t := namelist_t ('S%', 'C%', 'F%'); BEGIN FORALL indx IN 1 .. l_filters.COUNT UPDATE my_employees SET salary = salary * 1.1 WHERE UPPER (last_name) LIKE l_filters...

--------------------------------------------------

-------------------------------------------------- Environment Headstart utility go to the Function Hierarchy Diagramer select the container that you wish to create the business rule in, or just create a new sheet click on Function icon "small white square on the right top of the screen", then place it in the sheet type the lable and short definition of that function. Note: in this step you are building your business rules tree, so you may keep the root as a description for your business rules to be grouped under. Ex: for PMS, first we start with the root BR_PMS, and its definition is PMS Business Rules. Then for each system model, we have a group of business rules, like Funds/Portfolios Business Rules, or Securities Business Rules...etc. pick again the function icon, and type the label according to the following convention: · BR_TableShortName001_CEV (change event) · BR_TableShortName002_TRS (transition e...

Scenario : 1- User presses enter query button 2- user enter the criteria and the presses "Execute Query" button 3- Data for the specified criteria is now displayed on the block 4- user wants now to order data ascending , so he presses "Order ASC" button which contains this code "set_block_property('data",default_where,vColumn||' '||'asc'); Execute_query;" 5-The block now displays all the data form the table in a ascending order requirement: user wants to display only the data with the previous specified criteria in an ascending order -------------------------------------------------- DECLARE v_qry varchar2(1000); v_where varchar2(1000); m number; n number; BEGIN csh$block.all_Rec('DATA','QF_BROWSE',:SWITCH,'CSH_ENTER',:ACTION_FLAG); If csh$block.check_records(':browse.status',:action_flag,:switch,'CSH_ENTER','T')>0 then v_qry:=get_block_property('BROWSE',last_qu...

-------------------------------------------------- you may face this problem that is your form becomes very slow after running it on Sun JRE instead of Oracle jinitiator to solve this problem : open basejpi.htm and add this parameter -------------------------------------------- --------------------------------------------

-------------------------------------------------- If you replaced oracle Jinitiator or JRE, you may not unable to run forms using Firefox or Mozilla To solve this problem edit formsweb.cfg jpi_mimetype=application/x-java-applet

-------------------------------------------------- If you are using DHCP or Your computer is not connected to a local network, You have to Follow these steps before beginning installation for Oracle Database 1-ADD Microsoft loopback adapter To install the Microsoft Loopback Adapter, follow these steps: 1-Go to Start | Control Panel | Add Hardware. 2-In the introductory dialog box, click Next. 3-Select Yes, I Have Already Connected The Hardware, and click Next. 4-Scroll to the bottom of the Installed Hardware list box, select Add A New Hardware Device, and click Next. 5-Select the Install The Hardware That I Manually Select From A List (Advanced) option, and click Next. 6-Under Hardware Types, select Network Adapters, and click Next. 7-Under Manufacturer, select Microsoft. 8-Under Network Adapter, select Microsoft Loopback Adapter. 9-Click Next twice, and click Finish. Assign a non-routable IP like"192.168.1.1" to Loopback Adapter don't assign xxx.xxx.xx.xx to network adap...