The virtual-columns tag has no wiki summary.
1
vote
1answer
120 views
Creat Temporary Id in SQL Statement
I have a table
id name
1 Alpha
2 Alpha
3 Beta
4 Charlie
5 Charlie
I want to assign a temporary id at the run time in the SQL statement, So the desired result should be like
myid name
...
4
votes
3answers
804 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 ...
