OraFAQ Forum: General » Sample Access code Oracle SQL statements

Home » Other » General » Sample Access code Oracle SQL statements

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sample Access code Oracle SQL statements [message #104704]

Wed, 05 January 2005 07:32

Warren Tolentino
Messages: 1
Registered: January 2005

Junior Member

I am developing application using MS Access as front end and connected to Oracle database. I run into scenario wherein there is a master-detail relationship between two oracle tables and each has their own primary keys. I need a sample code to get the next value of the sequence for master and detail table and how to assign the master sequence to the detail table when save is made.

e.g. Select master_seq_id.nextval
Into ...
From dual

Report message to a moderator

Re: Sample Access code Oracle SQL statements [message #104727 is a reply to message #104704]

Wed, 12 January 2005 21:36

yaso
Messages: 2
Registered: December 2001

Junior Member

no u can't

Report message to a moderator

Previous Topic:	Dual Table Name
Next Topic:	oracle 8.1.6

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 15 01:28:46 CDT 2026