7/03/2012

Create a pass-through query to retrieve the nextval from an Oracle sequence

Question: I can get nextval from sequence in Oracle with this command:
select seq_name.nextval from dual;
Is there any way to get nextval from the Oracle sequence through Access 2003/XP/2000/97 when docmd.runsql("select seq_name.nextval from dual") doesn't work?
I need to insert nextval (the same value) into two tables.
Answer: To get the nextval from an Oracle sequence, you will need to use a pass-through query in Access.
To create a pass-through query, create a new query. Select Design View and click on the OK button.




When the Show Table window appears, do not add any tables. Click on the Close button.


Select SQL View from the toolbar.


Enter your SQL statement. In this example, we're selecting the next value from the Oracle sequence called supplier_seq.


Finally, under the Query menu, select SQL Specific > Pass-Through.

2 comments:

  1. Really good casino, plenty of probabilities to get free spins which is wager free. Aside from the colonial and, due to this fact western gambling traditions, Mahjong was legalised in the mid-20th century. However, in the intervening years, lots of the colleges that were arrange for this recreation 정카지노 have closed. This is partially because of the of} altering tradition in the metropolis and the rise in its metropolitan multiculturalism. As you would possibly expect, the British occupation and rule of Hong Kong in the days of the Empire affected all elements of life in the then colony. In the 1800s, horseracing had turn out to be immensely in style, which led to the setting up of the Happy Valley racecourse and the Hong Kong Jockey Club.

    ReplyDelete
  2. But we needed these on a v tight deadline no one in town may deliver. really have} reached out about one other project and talked with their customer support group -- who was pleasant and useful. I'll by no means let go of my native companions, end result of|as RING DOORBELL CAMERAS a end result of} I consider printing is native...however it is SO NICE to have Mixam at the able to fill in after we want.

    ReplyDelete