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

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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 02:59:44 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.