Hi,

I have a question.

I need to insert data into a table Student with columns names as Student_id, batch_id and student_name, but I have another table with name batch_job and in this table I have a column batch_id.
The value of the column batch_id in table student should be based on the values of the column batch_id of the table batch_job and on the where clause of the batch_job

somewhat Like this
INSERT INTO Student VALUES ('student_id',job_id,student_name)(
where Student.job_id in (SELECT job_id FROM batch_job WHERE BATCH_STATUS = 'SUCCESS'))

how can we implement such a scenario?

Thanks in advance.

create table t (x integer);

insert into t values ((select 1 from dual));

1 row inserted.

select * from t;

         X
----------
         1

delete t;

insert into t
  select rownum
  from   dual 
  connect by level <= 5;

5 rows inserted.
  
select * from t;

         X
----------
         1
         2
         3
         4
         5

insert into student 
  select 'student_id', job_id , 'student name'
  from   batch_job 
  where  batch_status = 'SUCCESS';