 Related Questions Latest Answer : A sequence generates a list of unique numbers that identifiy the rows and columns of a table. ... Read Answers (9) | Asked by : Geetha Latest Answer : here is the example for DBMS_SQL:CREATE OR REPLACE PROCEDURE delete_all_rows(p_tab_name IN VARCHAR2, p_rows_del OUT NUMBER)IScursor_name INTEGER;BEGINcursor_name := DBMS_SQL.OPEN_CURSOR;DBMS_SQL.PARSE(cursor_name, ’DELETE FROM ’||p_tab_name,DBMS_SQL.NATIVE ... Read Answers (5) | Asked by : Vinoth I am having WHEN-NEW-ITEM-INSTANCE trigger at Form, Block, Item level what is the sequence of execution? And if I want to change there sequence how I have to change? Latest Answer : You can get the current value of the Sequence by querying DBA_SEQUENCESColumn name is Last_numberThanksHari Kiran P. ... Read Answers (3) | Asked by : ram Latest Answer : Say you are using the seq name temp_seqCREATE SEQUENCE temp_seqStart with 5
Increment by 2maxvalue 999999999999999999999999nocachenocycle
Above will create the sequence temp_seqTo use itINSERT INOT xyz
VALUES (temp_seq.nextval,'oracle') ... Read Answers (3) | Asked by : smitesh shinde Hi All:I have problem with oracle when i migrate any application (develop in developer 6i)from Developer 6i(on ms window) to Oracle Developer Suite 10g(on ms window)then my form is open in Internet Explorer without any problem all fonts and screen size is ok, when i check this form on Linux and browser is netscape then my form is too small.I am also compile this form on Linux based Application Server 10g then check this form on Linux browser again form and font is too small. Please tell me what Hi, suppose i have 2 managers M1 & M2. S1 & S2 are Sales reps under M1. S3 & S4 are Sales reps under Hi, suppose i have 2 managers M1 & M2. S1 & S2 are Sales reps under M1. S3 & S4 are Sales reps under M2. Suppose S1 (whose manager is M1) creates 2 records. S2 will be able to see them ?.Now, if i change the parent position of S1 (i.e., if now, S1 is placed under M2 instead of M1), and responsibility remaining the same as earlier (Sales rep resp), will the Manager M1 be still able to see the records created by S1 ? Please clarify this. Thanks View Question | Asked by : s Hi,Subject: Oracle Apps :Order Management PTO,ATO, CTO Currently i am working on PTO they have some PTO type of orders. They call it Custom Config. The Customer may want to order something that requires Picking and Assembling multiple items from Inventory. The example Ram has given below is representative of what they would do now in FACTS.In this example they put Lines 1.1, 2.1, and 3.1 on the Order. However, Line 3.1 is made up by combining lines 1.1 and 2.1They then release the order and it reserves View Question | Asked by : Kalyan Latest Answer : Hi,If a Form Item's property needs to be changed, then it should be done from a form trigger and not a database trigger. You can use Visual Attributes or Property Classes to achieve this or a form trigger. Depending on your criteria, you can use form ... Hi,Need to generate an 6 digit sequence number automatically for employee numberin front end (Oracle Hi,Need to generate an 6 digit sequence number automatically for employee numberin front end (Oracle Applications)Module HRMSeg - 000001,000002.Pls update on thisRegardsVenu Read Answers (1) | Asked by : venu
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
