Tagged Questions
1
vote
2answers
74 views
How can I append a column to an inner SQL statement?
I have two tables that have the same structure except one has an additional column that should be auto-incremented. Sequence and trigger are defined.
I want to copy all data from one table to ...
1
vote
4answers
304 views
Limiting Generated Sequence Values in Multi-table Insert
In Oracle, given the following objects:
create table a (x number );
create table b (val number );
create table c (val number );
create sequence my_seq;
Suppose I populate table a as follows:
...
3
votes
2answers
2k views
How Does Oracle Handle Multiple Concurrent INSERTs Against One Table
I am trying to understand Oracle 11g a little more closely. My question is simple: how does Oracle handle two sessions that are attempting to insert records into a single table at the same time.
For ...
4
votes
3answers
830 views
Is (and if how) it possible in Oracle to “insert into <table> values <rowtype-variable>” if <table> has virtual columns
Here's a table
create table tq84_virtual_test_without (
col_1 number,
col_2 number,
col_3 number,
col_4 number,
col_5 number
);
with the rule that col_5's value is the sum of the other ...
1
vote
3answers
180 views
Insert to particular location in Oracle DB table?
Suppose I have a table containing the following data:
Name | Things
-------------
Foo | 5
Bar | 3
Baz | 8
If I want to insert a row, so that the final state of the table is:
Name | Things
...
