Home » Other » General » Sample Access code Oracle SQL statements
Sample Access code Oracle SQL statements [message #104704] Wed, 05 January 2005 07:32 Go to next message
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
Re: Sample Access code Oracle SQL statements [message #104727 is a reply to message #104704] Wed, 12 January 2005 21:36 Go to previous message
yaso
Messages: 2
Registered: December 2001
Junior Member
no u can't
Previous Topic: Dual Table Name
Next Topic: oracle 8.1.6
Goto Forum:
  


Current Time: Thu Mar 28 18:11:14 CDT 2024