database-connection
| connect to |
MySql |
database on |
localhost |
with username |
dbgreenpepper |
and password |
dbgreenpepper |
and database |
dbgreenpepper |
Insert Into interpreter can be used to set symbol values with autogenerated primary keys.
| insert into |
Table |
|
users |
| username |
name |
userid?= |
| pera |
pera pera |
user1 |
| nuja |
nuja nuja |
user2 |
| nnn |
nnn nnn |
user3 |
Symbols are then automatically available as bind variables for queries
| set of |
query |
|
Select * from users where userid=@user1 |
| username |
name |
| pera |
pera pera |
How can you enable this feature for Oracle databases with sequences ?
What I would like is a way to somehow do a
| set | parameter | | my_param | select SEQUENCE_NAME.nextval from dual |
| insert into | Tabøe | | TABLENAME |
| PRIMARY_KEY | COL1 | COL 2 | ... |
| @my_param | VAL1 | VAL2| ... |
Is some thing like this possible with dbGreenPepper ?