Why do we use data source as procedure in Oracle forms? What is the use of taking procedure as Data Source?
Latest Answer: To increase the control and securityTo specify a Query at runtime, Eg: in case of manager logs in he can see more info wherein if its employee he will be able to see less dataIf you wanna specify any complicated business rule to be executed before getting ...
hello,i am facing one problem. I have one main form. In that when i press one button, one window will be pop up with the details of Orders for the particular supplier which was selected in main form. I
Latest Answer: Try moving the pointer in the detailed block to NEXT_RECORD after you populate each record ...
how can you generate the system _generate number in forms automaticallyhint: IN FORMS WE CREATING ONE DATA BLOCK BUT ONE CLOUMN (EMPLOYEE_ID) THIS COLUMN GENERATE THE ID NUMBER AUTOMATICALLY WITH OUT
Latest Answer: 1: EMPLOYEE_ID := DBMS_RANDOM.STRING('X',6); ---- its generates unique EMPLOYEE_ID six char long 2: Then check whether newly generated id is already in DB. Create a cursor which select and return ids and the match both vales. If both are equal then go ...
Latest Answer: 1. Open data model editor, increase the height of the group to make place for the formula column or summary column.2. Select the formula column tool button in the tool palette and place it after the last field in the group.3. Open the property palette ...
Latest Answer: Yes it can come from two blocks. If the cource block is database/from clause query block then just go to the POST-QUERY of that block where display item exist and write :block.display_item:=block1.field1||block.field2 int hat POST-QUERY. ...
Latest Answer: no its not possible ...
What do you mean by anchoring on object?
Latest Answer: Anchors fasten an edge of one object to an edge of another object, ensuring that they maintain their relative positions. For example, you can anchor boilerplate text to the edge of a variable-sized repeating frame, guaranteeing the boilerplate's distance ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
