 Related Questions Default Block facility. Layout Editor. Menu Editor. Object Lists. Property Sheets. PL/SQL Editor. Tables Columns Block is a single mechanism for grouping related items into a functional unit for storing, displaying and manipulating records. Latest Answer : Canvases serve as physical containers of items. Blocks, on the other hand, serve as logical containers of items. There are two types of blocks: basetable blocks and non-base-table blocks. Sometimes, you may see base-table blocks referred to as data blocks ... Base table Blocks. Control Blocks. 1. A base table block Latest Answer : Base-table blocks, as their name implies, are based on a database table or view and must contain at least one item that is based on a column in that database table or view. If you create a block based on the STUDENT table, at least one of its items must ... Latest Answer : select * from emp a where rowid >(select min(rowid) from emp b where a.empno = b.empno) ... Read Answers (4) | Asked by : ravis Latest Answer : yes ... Read Answers (4) | Asked by : Shweta Latest Answer : NON-ISOLATED (default) a) on check delete masterb) on clear detailsc) on populate details ISOLATEDa) on clear detailsb) on populate detailsCASCADE a) per-deleteb) on clear detailsc) on populate details ... Latest Answer : Take the isolated relation ship ... If the same trigger is present in Form, Block and Item level, normally the item level will fire first. How to change this default one. That is I want to fire the block level or form level. How to do this? Read Answers (6) | Asked by : Prasanth A.S 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. ... 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 ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
