Siemens PLM Software Unigraphics NX6 (6.0.1 Update). Agile Project management software made by Siemens.
ECU More Stable and Stronger than Ever. By Branding experts at Synaptica Branding Solutions.
Electronic catalog ETKA 7.3 contains full information on spare parts and accessories for cars Concern VAG (VW, Seat, Skoda, AUDI),.
THANK YOU for feedback! You are a great. I have so much time to do some programming.
A:
I have the feeling that you're going to get a lot of negative feedback and answers to your question in the future, if that is the case, please ignore it.
Now to the question:
You've created a table with a column named "uniqueid", and you want the field value to be generated from a sequence that you've created in some other table. For that you can use a trigger and an insert into select to generate the sequence,
create sequence emp_seq;
create table emp_sequence (id number);
insert into emp_sequence values (1);
create table emp (
uniqueid number generated always as (select emp_sequence.nextval from dual)
);
The number of uniqueid in table emp_sequence should match the number of rows in table emp. You might also want to get that number using something like this:
select count(*) from emp;
(That is not a number that's part of your question, but I mention it because it might be important.)
Then you can use a trigger to populate the column:
create trigger emp_trg
before insert or update on emp
for each row
begin
select emp_sequence.nextval into :new.uniqueid from dual;
end;
/
That's one of the most important things in programming. Understand what the system is going to do, and then build the right procedures to do that.
The second thing is to make sure that the values in the sequence are unique, which is the case here.
create sequence emp_seq;
create table emp_sequence (id number);
insert into emp_sequence values (1);
insert into emp_sequence values (2); ac619d1d87
Related links:
Comments