Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ORACLE SEQUENCES IN EXCEL
Hi all:
Is there anyway I can access a sequence of Oracle, make a nexval over it and use that value in Excel (and update the value of the sequence in Oracle)? Which reference library should I load? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ORACLE SEQUENCES IN EXCEL
You can get the next value (and increment the sequence) using ADO and
something like: select seq_name.nextval from dual Tim -- Tim Williams Palo Alto, CA "Román Valoria" wrote in message ... Hi all: Is there anyway I can access a sequence of Oracle, make a nexval over it and use that value in Excel (and update the value of the sequence in Oracle)? Which reference library should I load? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Statement with 9 sequences | Excel Discussion (Misc queries) | |||
If Statement with 9 sequences | Excel Discussion (Misc queries) | |||
Save as: sequences? | Excel Discussion (Misc queries) | |||
Connect to Oracle using Microsoft ODBC for Oracle | Excel Programming | |||
Event Sequences | Excel Programming |