Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
create table report_product_densities (product varchar2(10), sample_id varchar2(10), test_number varchar2(10), lot_number varchar2(10), location varchar2(10), date_completed date, density number ) / insert into report_product_densities select rtrim(s.product) as product, rtrim(s.id_numeric) as sample_id, rtrim(t.test_number) as test_number, rtrim(s.batch_name) as lot_number, rtrim(s.sampling_point) as location, t.date_completed date_completed, r.value density from lims_sample s, lims_test t, lims_result r where s.id_numeric = t.sample and t.test_number = r.test_number and (s.status = 'C' or s.status='A') and t.analysis = '4' and (r.value > 0 and r.value < 1) and s.sampling_point like 'TK%' and t.date_completed > sysdate-365 /
|Writing Oracle SQL function that involves a parent and child table||8||65|
|Create two table and a foreign key?||4||51|
|Adding a blank row when using union all||4||37|
|Oracle SQL Insert Script to copy data between tables||8||28|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
26 Experts available now in Live!