Oracle Development | Forum profile

Please post the exact error message. If you are getting a warning for network error just ignore it and proceed further.

I have the following: Table A Table B Pallet_No Pallet_No Qty Qty I need to return: - All of the Pallet_No's from Table A that are not in Table B - All of the Pallet_No's from Table B that are not in Table A - All the Pallet_No's where there is a difference in Qty b/w Table A and Table B. Thanks for your help.

Quote: Originally Posted by hattatTR I tried to solve the network problem. but i could not. And i ignored the message and installed Oracle 10g. But i got another problem. The Enterprise Manager needs to be installed. Unfortunately it is not. Now i can connect to the db only in SQLPlus. I guess i should install EM myself but i donot know how to do. It took a few days but i finally made it. I deinstalled the broken Oracle installation. Than i...

The number column doesn't much help either I don't think, but thanks for the effort. Maybe this would be best handled (particularly for my Friday brain that is about fried) to create a function to return a table of some type? I've not done anything like that. I can create a custom type if necessary (but don't really want to if possible). I'm familiar with cursors so that helps also. Is there any way to create a data...

Quote: This works, except I need to make the "WHERE CODE LIKE '%XX%' dynamic because we may add codes in the lookup table at any time, so the query would have to be modified manually if we add 'DD'. Then you might consider a stored procedure that walks the lookup table and builds a dynamic SQL statement and then executes it. Clive

Quote: Originally Posted by debasisdas check the create database command, go through it, understand it and then try to use. http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/create.htm http://www.dba-oracle.com/oracle_create_database.htm Ive just read some of that and it cant be that complex... All I want to do is set up a simple database which holds a few books using php commands. (I am using a web server which has 10g oracle...

Some usefull converters are available on google to migrate database i use convert db for this purpose. Find Here : www(.)convert-db(.)com

Hi all, In order to create this trigger, i've created a function to calculate and return business days. --------------------------------------------------------------------------- FUNCTION CME.CASE_1 (start_date IN CME_ROUT.BFDATE%TYPE, end_date IN CME_ROUT.RETDATE%TYPE) --------------------------------------------------------------------------- then, i've created a view that calls the above function as follows...

Since you didn't post the desired result this can't be but a guess ... sql Code: Original - sql Code select * from ( select e.EMPLOYEE_NAME, count(w.pallet_no), sum(w.QTY) from pca_wms_fg w, kr_employee_v e where trunc (w.modified_date) >= Date_From and trunc (w.modified_date) <= Date_To and w.MODIFIED_BY = e.BADGENUM group by e.employee_name ) aa inner join ( select e.employee_name, sum(w.qty) from pca_wms_fg w join...