Search results for query: *

Hi, I am very new to java and trying to make this server multithreaded to handle repeated concurrent requests. I would a new thread to handle each connection. Help would be great Many Thanks import java.io.*; import java.net.*; import java.util.*; class Web extends Thread { public static...

Hi, Is there any way in an SQL query where the user can enter the condional parameter which the results will be based upon? i.e. A list of suppliers in a user selected postal area. It must be in SQL. Many thanks in advance Nick

Thank you, I can create the Trigger now. Do I need to refer to it when I insert records into the table? At the moment it will allow any part_no in the table even if they do not exist in the mechanical table or electrical Thanks again nick

sorry this one. CREATE OR REPLACE TRIGGER CHECK_SUPPLY_NO BEFORE INSERT OR UPDATE ON SUPPLIES FOR EACH ROW DECLARE cursor lc_mech_elec (p_no number) is select 1 from mechanical where part_no = p_no union select 1 from electrical where part_no = p_no; l_dummy pls_integer; BEGIN...

CREATE OR REPLACE TRIGGER CHECK_SUPPLY_NO BEFORE INSERT OR UPDATE ON SUPPLIES FOR EACH ROW DECLARE cursor lc_mech_elec (p_no number) is select 1 from mechanical sorry this one. where part_no = p_no union select 1 from electrical where part_no = p_no; l_dummy pls_integer; BEGIN...

Heres the final code but I am still getting a error Warning: Trigger created with compilation errors. SQL> sho err Errors for TRIGGER CHECK_SUPPLY_NO: LINE/COL ERROR -------- ----------------------------------------------------- 12/19 PLS-00049: bad bind variable 'NEW.PART_NO' create...

Sorry wrong one. I get SQL this error with the following code. Many thanks in advance > sho err Errors for TRIGGER CHECK_SUPPLY_NO: LINE/COL ERROR -------- -------------------------------------------------------------- 12/19 PLS-00049: bad bind variable 'NEW.PART_NO' SQL> INSERT INTO...

Many thanks Please could you help a little bit more. Now I have the following CREATE OR REPLACE TRIGGER CHECK_SUPPLY_NO BEFORE INSERT OR UPDATE ON SUPPLIES FOR EACH ROW begin cursor lc_mech_elec (p_no number) is select 1 from mechanical where part_no = p_no union select 1...

it was select Part_No not *

So far I have done this CREATE OR REPLACE TRIGGER CHECK_SUPPLY_NO BEFORE INSERT OR UPDATE ON SUPPLIES FOR EACH ROW begin cursor lc_mech_elec (p_no number) is select * from mechanical where part_no = p_no union select * from electrical where part_no = p_no; l_dummy...

Thanks, I am new to oracle SQL please could you help me a bit more on creating a trigger to do this! Thanks in advance

Hi thanks for the reply how would you do it using triggers?

Hi, am trying to link two tables to one single foreign key iun a further table. I would like Electrical(Part_No ) and Mechnaical (Part_No) to be a single foreign key in the supplies relation, but the last line referencing the two keys brings a "ORA-00907: missing right parentesis&quot...