Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

oracle block item value copied

Posted on 2014-01-16
2
Medium Priority
?
914 Views
Last Modified: 2014-01-18
have tabular block which have three record or fourth record.i want when create new record the previous values will be copied to the new created record now its upto the user whetherer he changed or leave it as above.
if there the two record the second record value should be copy to third one.
how i can handle it. on which triger?

i tried to use "duplicate_record"  can any one tell me how to use duplicate_REcord in form in my scenario.


Thanks
0
Comment
Question by:hinamansoor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 20

Accepted Solution

by:
flow01 earned 2000 total points
ID: 39789274
try creating a
when-new-record instance trigger

if the : system.record_status = 'NEW' and system.cursor_record > 1 then
   if :itemx is null  then  -- itemx should be an item that always has to be filled (to prevent repetitive  duplicates)
          duplicate_record;
   end if;
end if;
0
 

Author Comment

by:hinamansoor
ID: 39791136
Gr8 answer Sir I was expecting from you.



Thanks
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question