Home » SQL & PL/SQL » SQL & PL/SQL » Help in making query (Oracle 9i Wundows Server)
icon5.gif  Help in making query [message #445408] Mon, 01 March 2010 10:20 Go to next message
milindsaraswala
Messages: 4
Registered: March 2010
Junior Member

Hi,

I am new to this forum and I need help in making query. Scenario is like this I have table called Orders with lots of fields from Imports Fields are ConsigneeKey,Shipto,ProductCode. and another table called Product. Main fields are ProductCode,Price,Weight,StdCube. Now I have two list of Consineekey,One which is shipto X area and another is of Y area. I want to make query like separate list of Orders which is shipto X,Y and Common Products in Both X and Y. I will supply list of Consigneekey in where clause. How can I achieve this.

Note I have data of more than 6 years so query should run fast
Re: Help in making query [message #445409 is a reply to message #445408] Mon, 01 March 2010 10:23 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Welcome to the forum.

Please post a working Test case: create table and insert statements along with the result you want with these data.

Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version with 4 decimals.

Regards
Michel
icon5.gif  Re: Help in making query [message #445413 is a reply to message #445408] Mon, 01 March 2010 11:11 Go to previous messageGo to next message
milindsaraswala
Messages: 4
Registered: March 2010
Junior Member

Hi Michel,

Thanks for quick reply Surprised

Actually I am new here in this company database so I dont know how they create table but I try my best to give as much information as I can

Oracle Version Information
(1)Oracle Advanced Security: NTS authentication service adapter for 32-bit Windows: Version 2.0.0.0.0
(2)Oracle Advanced Security: authentication service for 32-bit Windows: Version 9.2.0.8.0 - Production
(3)Oracle Advanced Security: crypto-checksumming service for 32-bit Windows: Version 9.2.0.8.0 - Produ
(4)Oracle Advanced Security: encryption service for 32-bit Windows: Version 9.2.0.8.0 - Production
(5)Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.8.0 - Production

For Index I Have uploaded as Jpeg File

Output shud be common product in List of X and Y Consigneekey

ProductCode Consigneekey
----------- ------------


  • Attachment: Index.JPG
    (Size: 98.66KB, Downloaded 77 times)
Re: Help in making query [message #445414 is a reply to message #445413] Mon, 01 March 2010 11:27 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As you know the description of the tables you can write the create table statements.
Then you can write some insert statements for some data (of your own or from your database).

Finally given these example date, you can tell us what should be the result.
We just need that.

By the way, some of us can't or don't want to download files, so it is better to post them in text in the post itself.

Regards
Michel
Re: Help in making query [message #445416 is a reply to message #445408] Mon, 01 March 2010 11:51 Go to previous messageGo to next message
milindsaraswala
Messages: 4
Registered: March 2010
Junior Member

CREATE TABLE ORDERS (
GENNUMBER NUMBER (38),
ORDERKEY VARCHAR2 (10) NOT NULL,
STORERKEY VARCHAR2 (15) DEFAULT ' ' NOT NULL,
EXTERNORDERKEY VARCHAR2 (32) DEFAULT ' ' NOT NULL,
ORDERDATE DATE DEFAULT sysdate NOT NULL,
DELIVERYDATE DATE DEFAULT sysdate NOT NULL,
PRIORITY VARCHAR2 (10) DEFAULT '5' NOT NULL,
CONSIGNEEKEY VARCHAR2 (15) DEFAULT ' ' NOT NULL,
C_CONTACT1 VARCHAR2 (100),
C_CONTACT2 VARCHAR2 (100),
C_COMPANY VARCHAR2 (100),
C_ADDRESS1 VARCHAR2 (100),
C_ADDRESS2 VARCHAR2 (100),
C_ADDRESS3 VARCHAR2 (100),
C_ADDRESS4 VARCHAR2 (100),
C_CITY VARCHAR2 (45),
C_STATE VARCHAR2 (2),
C_ZIP VARCHAR2 (18),
C_COUNTRY VARCHAR2 (30),
C_ISOCNTRYCODE VARCHAR2 (10),
C_PHONE1 VARCHAR2 (18),
C_PHONE2 VARCHAR2 (18),
C_FAX1 VARCHAR2 (18),
C_FAX2 VARCHAR2 (18),
C_VAT VARCHAR2 (18),
BUYERPO VARCHAR2 (20),
BILLTOKEY VARCHAR2 (15) DEFAULT ' ' NOT NULL,
B_CONTACT1 VARCHAR2 (30),
B_CONTACT2 VARCHAR2 (30),
B_COMPANY VARCHAR2 (45),
B_ADDRESS1 VARCHAR2 (45),
B_ADDRESS2 VARCHAR2 (45),
B_ADDRESS3 VARCHAR2 (45),
B_ADDRESS4 VARCHAR2 (45),
B_CITY VARCHAR2 (45),
B_STATE VARCHAR2 (2),
B_ZIP VARCHAR2 (18),
B_COUNTRY VARCHAR2 (30),
B_ISOCNTRYCODE VARCHAR2 (10),
B_PHONE1 VARCHAR2 (18),
B_PHONE2 VARCHAR2 (18),
B_FAX1 VARCHAR2 (18),
B_FAX2 VARCHAR2 (18),
B_VAT VARCHAR2 (18),
INCOTERM VARCHAR2 (10),
PMTTERM VARCHAR2 (10),
DOOR VARCHAR2 (10) DEFAULT ' ' NOT NULL,
ROUTE VARCHAR2 (10) DEFAULT ' ' NOT NULL,
STOP VARCHAR2 (10) DEFAULT ' ' NOT NULL,
OPENQTY NUMBER (38) DEFAULT 0,
STATUS VARCHAR2 (10) DEFAULT '0' NOT NULL,
DISCHARGEPLACE VARCHAR2 (30),
DELIVERYPLACE VARCHAR2 (30),
INTERMODALVEHICLE VARCHAR2 (30) DEFAULT ' ' NOT NULL,
COUNTRYOFORIGIN VARCHAR2 (30),
COUNTRYDESTINATION VARCHAR2 (30),
UPDATESOURCE VARCHAR2 (10) DEFAULT '0' NOT NULL,
TYPE VARCHAR2 (10) DEFAULT '0' NOT NULL,
ORDERGROUP VARCHAR2 (20) DEFAULT ' ' NOT NULL,
NOTES VARCHAR2 (2000),
EFFECTIVEDATE DATE DEFAULT sysdate NOT NULL,
STAGE VARCHAR2 (10) DEFAULT ' ',
DC_ID VARCHAR2 (10) DEFAULT ' ',
WHSE_ID VARCHAR2 (15) DEFAULT ' ',
SPLIT_ORDERS VARCHAR2 (1) DEFAULT '0',
APPT_STATUS VARCHAR2 (10),
CHEPPALLETINDICATOR VARCHAR2 (10),
CONTAINERTYPE VARCHAR2 (20),
CONTAINERQTY NUMBER (38),
BILLEDCONTAINERQTY NUMBER (38),
C_EMAIL1 VARCHAR2 (55),
C_EMAIL2 VARCHAR2 (55),
TRANSPORTATIONMODE VARCHAR2 (30),
TRANSPORTATIONSERVICE VARCHAR2 (30),
EXTERNALORDERKEY2 VARCHAR2 (32),
SUSR1 VARCHAR2 (30),
SUSR2 VARCHAR2 (30),
SUSR3 VARCHAR2 (30),
SUSR4 VARCHAR2 (30),
SUSR5 VARCHAR2 (30),
NOTES2 VARCHAR2 (2000),
ITEM_NUMBER NUMBER (12),
FORTE_FLAG VARCHAR2 (6) DEFAULT 'I' NOT NULL,
LOADID VARCHAR2 (20),
SHIPTOGETHER VARCHAR2 (1) DEFAULT 'N' NOT NULL,
DELIVERYDATE2 DATE DEFAULT SYSDATE,
REQUESTEDSHIPDATE DATE DEFAULT SYSDATE,
ACTUALSHIPDATE DATE DEFAULT SYSDATE,
DELIVER_DATE DATE DEFAULT SYSDATE NOT NULL,
ORDERVALUE NUMBER (10,2) DEFAULT 0 NOT NULL,
OHTYPE VARCHAR2 (10) DEFAULT '1',
EXTERNALLOADID VARCHAR2 (10) DEFAULT ' ',
SORTATIONLOCATION VARCHAR2 (18),
BATCHFLAG VARCHAR2 (1) DEFAULT '0' NOT NULL,
BULKCARTONGROUP VARCHAR2 (10),
ADDDATE DATE DEFAULT sysdate NOT NULL,
ADDWHO VARCHAR2 (30) DEFAULT USER NOT NULL,
EDITDATE DATE DEFAULT sysdate NOT NULL,
EDITWHO VARCHAR2 (30) DEFAULT USER NOT NULL,
TRAFFICCOP VARCHAR2 (1),
ARCHIVECOP VARCHAR2 (1),
WISHBONE VARCHAR2 (10),
GZONE VARCHAR2 (10) DEFAULT '',
ROUTENUMBER VARCHAR2 (10) DEFAULT '',
ROUTESEQUENCE VARCHAR2 (10) DEFAULT '',
TRANSFER VARCHAR2 (10),
TRANSFERNO VARCHAR2 (10),
DELIVERYNO VARCHAR2 (10),
BONDTEMPEXP VARCHAR2 (1),
TEMPEXPDATE DATE,
BFLAG VARCHAR2 (10),
BCONTTYPE VARCHAR2 (60),
BCONTNUM VARCHAR2 (60),
BBOEXIT VARCHAR2 (60),
BEXITDATE DATE,
BHAWB VARCHAR2 (60),
BMAWB VARCHAR2 (60),
HOLD VARCHAR2 (10),
EC VARCHAR2 (1) DEFAULT '0',
CHANGESTATUS VARCHAR2 (1),
CONFIRMED VARCHAR2 (10) DEFAULT '1' NOT NULL,
INTERNETORDER VARCHAR2 (1) DEFAULT '0',
PICKBILLINGSTRATEGY VARCHAR2 (5) DEFAULT '0',
PICKINGCHARGE NUMBER (22,6) DEFAULT 0,
PICKINGCURRENCY VARCHAR2 (10) DEFAULT 'KWD',
EMPICKINGCHARGE NUMBER (22,6) DEFAULT 0,
EMPICKINGCURRENCY VARCHAR2 (10) DEFAULT 'KWD',
BILLED VARCHAR2 (1) DEFAULT '0',
EMBILLED VARCHAR2 (1) DEFAULT '0',
PROTECTED VARCHAR2 (1) DEFAULT '0',
RELEASESTATUS VARCHAR2 (30) DEFAULT 'UNRELEASED' NOT NULL,
TOTALREMAININGQTY NUMBER (38) DEFAULT 0,
TOTALORDEREDQTY NUMBER (38) DEFAULT 0,
SHIPMENTCONFIRMED VARCHAR2 (10) DEFAULT '0',
TOTALDCBYPASSQTY NUMBER (38) DEFAULT 0,
SESSIONID VARCHAR2 (50),
CONTRACTNUMBER VARCHAR2 (40) DEFAULT ' ',
DECCONTAINERQTY NUMBER (38,5) DEFAULT 0,
DECBILLEDCONTAINERQTY NUMBER (38,5) DEFAULT 0,
ORIGINALSHIPDATE DATE,
SDFLAG VARCHAR2 (1) DEFAULT '0' NOT NULL,
TRUCKNO VARCHAR2 (20),
FREEZONE_DOC VARCHAR2 (10),
LEGALIZATION VARCHAR2 (10),
CUSTOMERREFERENCE VARCHAR2 (20) DEFAULT ' ' NOT NULL,
AREA VARCHAR2 (10) DEFAULT ' ' NOT NULL,
MROSTATUS VARCHAR2 (10) DEFAULT 0,
TCN VARCHAR2 (25) DEFAULT ' ',
REASON VARCHAR2 (10),
PACKDATE DATE,
INTERFACESUFFIX VARCHAR2 (10) DEFAULT 'A',
ORIGINALORDERNUMBER VARCHAR2 (10),
BACKORDER VARCHAR2 (2) DEFAULT '0' NOT NULL,
JOBKEY VARCHAR2 (10),
PROCESSED VARCHAR2 (10) DEFAULT '0' NOT NULL,
INTERFACEDATE DATE,
QTYALLOCATED NUMBER DEFAULT 0,
BILLINGPROCESSED VARCHAR2 (10) DEFAULT '0',
CALCULATEDSTATUS VARCHAR2 (10) DEFAULT '0',
TOTALQTY NUMBER DEFAULT 0,
EXPORT_FLAG VARCHAR2 (1) DEFAULT '0',
CONSTRAINT PK_ORDERS
PRIMARY KEY ( ORDERKEY ) )
PARTITION BY HASH (ORDERKEY,STORERKEY,EXTERNORDERKEY)
PARTITIONS 40
STORE IN ( ORD_TS,ORD_TS03);

ALTER TABLE ORDERS ADD CONSTRAINT PK_ORDERS_EXTERN_ORDERGROUP
UNIQUE (EXTERNORDERKEY, ORDERGROUP) ;




CREATE INDEX IDX_ORDERS_STORER_CONS ON
ORDERS(STORERKEY, CONSIGNEEKEY)
LOCAL STORE IN ( ORD_IS02);

CREATE INDEX IDX_ORDERS_EXTERN2 ON
ORDERS(EXTERNALORDERKEY2)
LOCAL STORE IN ( ORD_IS);

CREATE INDEX IDX_ORDERS_STATUS_EDIT ON
ORDERS(STATUS, EDITDATE, ADDDATE)
LOCAL STORE IN ( ORD_IS01);

CREATE INDEX IDX_ORDERS_ARCHIVECOP ON
ORDERS(ARCHIVECOP)
LOCAL STORE IN ( ORD_IS);

CREATE INDEX IDX_ORDERS_MRO_STATUS_DATE ON
ORDERS(STORERKEY, ORDERKEY, MROSTATUS, STATUS, EDITDATE, ADDDATE, REASON)
LOCAL STORE IN ( ORD_IS01);

CREATE INDEX IDX_OCC_ORDERS_EDITDATE ON
ORDERS(EDITDATE)
LOCAL STORE IN ( ORD_IS);

CREATE INDEX IDX_ORDERS_ORDERDATE ON
ORDERS(ORDERDATE)
LOCAL STORE IN ( ORD_IS02);

CREATE INDEX IDX_ORDERS_EXTERNORDERKEY ON
ORDERS(EXTERNORDERKEY)
LOCAL STORE IN ( ORD_IS01);

CREATE INDEX IDX_ORDERS_EXTORD_GROUP ON
ORDERS(STORERKEY, EXTERNORDERKEY, ORDERGROUP)
LOCAL STORE IN ( ORD_IS01);


ALTER TABLE ORDERS ADD CONSTRAINT FK_ORDERS_STORER_01_P
FOREIGN KEY (STORERKEY)
REFERENCES WH1.STORER (STORERKEY) ;


=================================================================
Data for it

"GENNUMBER" "ORDERKEY" "STORERKEY" "EXTERNORDERKEY" "ORDERDATE" "DELIVERYDATE" "PRIORITY" "CONSIGNEEKEY" "C_CONTACT1" "C_CONTACT2" "C_COMPANY" "C_ADDRESS1" "C_ADDRESS2" "C_ADDRESS3" "C_ADDRESS4" "C_CITY" "C_STATE" "C_ZIP" "C_COUNTRY" "C_ISOCNTRYCODE" "C_PHONE1" "C_PHONE2" "C_FAX1" "C_FAX2" "C_VAT" "BUYERPO" "BILLTOKEY" "B_CONTACT1" "B_CONTACT2" "B_COMPANY" "B_ADDRESS1" "B_ADDRESS2" "B_ADDRESS3" "B_ADDRESS4" "B_CITY" "B_STATE" "B_ZIP" "B_COUNTRY" "B_ISOCNTRYCODE" "B_PHONE1" "B_PHONE2" "B_FAX1" "B_FAX2" "B_VAT" "INCOTERM" "PMTTERM" "DOOR" "ROUTE" "STOP" "OPENQTY" "STATUS" "DISCHARGEPLACE" "DELIVERYPLACE" "INTERMODALVEHICLE" "COUNTRYOFORIGIN" "COUNTRYDESTINATION" "UPDATESOURCE" "TYPE" "ORDERGROUP" "NOTES" "EFFECTIVEDATE" "STAGE" "DC_ID" "WHSE_ID" "SPLIT_ORDERS" "APPT_STATUS" "CHEPPALLETINDICATOR" "CONTAINERTYPE" "CONTAINERQTY" "BILLEDCONTAINERQTY" "C_EMAIL1" "C_EMAIL2" "TRANSPORTATIONMODE" "TRANSPORTATIONSERVICE" "EXTERNALORDERKEY2" "SUSR1" "SUSR2" "SUSR3" "SUSR4" "SUSR5" "NOTES2" "ITEM_NUMBER" "FORTE_FLAG" "LOADID" "SHIPTOGETHER" "DELIVERYDATE2" "REQUESTEDSHIPDATE" "ACTUALSHIPDATE" "DELIVER_DATE" "ORDERVALUE" "OHTYPE" "EXTERNALLOADID" "SORTATIONLOCATION" "BATCHFLAG" "BULKCARTONGROUP" "ADDDATE" "ADDWHO" "EDITDATE" "EDITWHO" "TRAFFICCOP" "ARCHIVECOP" "WISHBONE" "GZONE" "ROUTENUMBER" "ROUTESEQUENCE" "TRANSFER" "TRANSFERNO" "DELIVERYNO" "BONDTEMPEXP" "TEMPEXPDATE" "BFLAG" "BCONTTYPE" "BCONTNUM" "BBOEXIT" "BEXITDATE" "BHAWB" "BMAWB" "HOLD" "EC" "CHANGESTATUS" "CONFIRMED" "INTERNETORDER" "PICKBILLINGSTRATEGY" "PICKINGCHARGE" "PICKINGCURRENCY" "EMPICKINGCHARGE" "EMPICKINGCURRENCY" "BILLED" "EMBILLED" "PROTECTED" "RELEASESTATUS" "TOTALREMAININGQTY" "TOTALORDEREDQTY" "SHIPMENTCONFIRMED" "TOTALDCBYPASSQTY" "SESSIONID" "CONTRACTNUMBER" "DECCONTAINERQTY" "DECBILLEDCONTAINERQTY" "ORIGINALSHIPDATE" "SDFLAG" "TRUCKNO" "FREEZONE_DOC" "LEGALIZATION" "CUSTOMERREFERENCE" "AREA" "MROSTATUS" "TCN" "REASON" "PACKDATE" "INTERFACESUFFIX" "ORIGINALORDERNUMBER" "BACKORDER" "JOBKEY" "PROCESSED" "INTERFACEDATE" "QTYALLOCATED" "BILLINGPROCESSED" "CALCULATEDSTATUS" "TOTALQTY" "EXPORT_FLAG"
"0000001429" "SW3109" "W81NNE42680212" 04/10/2004 10:54:12 04/10/2004 10:54:12 "5" "W81NNE" "W81NNE" "W81NNE42680212XXX" " " " " " " " " 0 "9" " " "0" "A51" " " 04/10/2004 10:54:12 " " " " " " "0" "I" "N" 04/10/2004 10:54:12 04/10/2004 10:54:12 04/10/2004 10:54:12 04/10/2004 10:54:12 0 "1" " " "0" 04/10/2004 10:54:12 "WH1" 06/10/2004 12:57:49 "WH1" "0" "1" "0" "0" 0 "KD" 0 "KD" "0" "0" "1" "UNRELEASED" 0 2 "0" 0 " " 0 0 "0" " " " " "0" " " "A" "0" "0" 0
"0000001435" "SW3109" "W918AR42740029" 04/10/2004 10:54:12 04/10/2004 10:54:12 "5" "W918AR" "W918AR" "W918AR42740029XXX" " " " " " " " " 0 "9" " " "0" "A51" " " 04/10/2004 10:54:12 " " " " " " "0" "I" "N" 04/10/2004 10:54:12 04/10/2004 10:54:12 04/10/2004 10:54:12 04/10/2004 10:54:12 0 "1" " " "0" 04/10/2004 10:54:12 "WH1" 12/10/2004 13:21:09 "mahesh" "0" "NB" "NO" "0" "1" "0" "0" 0 "KD" 0 "KD" "0" "0" "1" "UNRELEASED" 0 1 "0" 0 " " 0 0 "0" " " " " "0" " " "A" "0" "0" 0
"0000001461" "SW3109" "W91XPA42680016" 04/10/2004 10:54:12 04/10/2004 10:54:12 "2" "W91QSU" "W91QSU" "W91XPA42680016XXX" " " " " " " " " 0 "9" " " "0" "A51" " " 04/10/2004 10:54:12 " " " " " " "0" "I" "N" 04/10/2004 10:54:12 04/10/2004 10:54:12 04/10/2004 10:54:12 04/10/2004 10:54:12 0 "1" " " "0" 04/10/2004 10:54:12 "WH1" 06/10/2004 08:30:12 "WH1" "0" "1" "0" "0" 0 "KD" 0 "KD" "0" "0" "1" "UNRELEASED" 0 4 "0" 0 " " 0 0 "0" " " " " "0" " " "A" "0" "0" 0
"0000001463" "SW3109" "W81NNE42680270" 04/10/2004 10:54:12 04/10/2004 10:54:12 "2" "W81NNE" "W81NNE" "W81NNE42680270XXX" " " " " " " " " 0 "9" " " "0" "A51" " " 04/10/2004 10:54:12 " " " " " " "0" "I" "N" 04/10/2004 10:54:12 04/10/2004 10:54:12 04/10/2004 10:54:12 04/10/2004 10:54:12 0 "1" " " "0" 04/10/2004 10:54:12 "WH1" 06/10/2004 08:30:12 "WH1" "0" "1" "0" "0" 0 "KD" 0 "KD" "0" "0" "1" "UNRELEASED" 0 2 "0" 0 " " 0 0 "0" " " " " "0" " " "A" "0" "0" 0
"0000001668" "SW3109" "W91YZ742710800" 04/10/2004 10:54:17 04/10/2004 10:54:17 "2" "W91YZ7" "W91YZ7" "W91YZ742710800XXX" " " " " " " " " 0 "9" " " "0" "A51" " " 04/10/2004 10:54:17 " " " " " " "0" "I" "N" 04/10/2004 10:54:17 04/10/2004 10:54:17 04/10/2004 10:54:17 04/10/2004 10:54:17 0 "1" " " "0" 04/10/2004 10:54:17 "WH1" 09/10/2004 17:02:14 "guna" "0" "NB" "NO" "0" "1" "0" "0" 0 "KD" 0 "KD" "0" "0" "1" "UNRELEASED" 0 25 "0" 0 " " 0 0 "0" " " " " "0" " " "A" "0" "0" 0
"0000001777" "SW3109" "W91T1F42710174" 04/10/2004 10:54:19 04/10/2004 10:54:19 "2" "W91T1F" "W91T1F" "W91T1F42710174XXX" " " " " " " " " 0 "9" " " "0" "A51" " " 04/10/2004 10:54:19 " " " " " " "0" "I" "N" 04/10/2004 10:54:19 04/10/2004 10:54:19 04/10/2004 10:54:19 04/10/2004 10:54:19 0 "1" " " "0" 04/10/2004 10:54:19 "WH1" 11/10/2004 19:33:26 "WH1" "0" "1" "0" "0" 0 "KD" 0 "KD" "0" "0" "1" "UNRELEASED" 0 30 "0" 0 " " 0 0 "0" " " " " "0" " " "A" "0" "0" 0
"0000001923" "SW3109" "W915UX42750023" 04/10/2004 10:54:23 04/10/2004 10:54:23 "5" "W915UX" "W915UX" "W915UX42750023XXX" " " " " " " " " 0 "9" " " "0" "A51" " " 04/10/2004 10:54:23 " " " " " " "0" "I" "N" 04/10/2004 10:54:23 04/10/2004 10:54:23 04/10/2004 10:54:23 04/10/2004 10:54:23 0 "1" " " "0" 04/10/2004 10:54:23 "WH1" 12/10/2004 10:41:12 "WH1" "0" "1" "0" "0" 0 "KD" 0 "KD" "0" "0" "1" "UNRELEASED" 0 1 "0" 0 " " 0 0 "0" " " " " "0" " " "A" "0" "0" 0
"0000002760" "SW3109" "W91ZKW42790112" 07/10/2004 12:23:32 07/10/2004 12:23:32 "2" "W91ZKW" "W91ZKW" "W91ZKWOEF AWCF SSF" "W91ZKWTAJI AB" "W91ZKWTAJI IQ" "W91ZKW42790112XXX" " " " " " " " " 0 "9" " " "0" "A5A" " " 07/10/2004 12:23:32 " " " " " " "0" "5624" "I" "N" 07/10/2004 12:23:32 07/10/2004 12:23:32 07/10/2004 12:23:32 07/10/2004 12:23:32 0 "1" " " "0" 07/10/2004 12:23:32 "WH1" 13/10/2004 18:08:26 "WH1" "0" "1" "0" "0" 0 "KD" 0 "KD" "0" "0" "1" "UNRELEASED" 0 1 "0" 0 " " 0 0 "0" " " " " "0" " " "A" "0" "0" 0
"0000003200" "SW3109" "W91X8J42803408" 07/10/2004 12:23:40 07/10/2004 12:23:40 "12" "W91X8J" "W91X8J" "W91X8JOIF II AWCF SSF" "W91X8JBALAD AB" "W91X8JBALAD IQ" "W91X8J42803408XXX" " " " " " " " " 0 "9" " " "0" "A5A" " " 07/10/2004 12:23:40 " " " " " " "0" "6064" "I" "N" 07/10/2004 12:23:40 07/10/2004 12:23:40 07/10/2004 12:23:40 07/10/2004 12:23:40 0 "1" " " "0" 07/10/2004 12:23:40 "WH1" 12/10/2004 16:36:35 "WH1" "0" "1" "0" "0" 0 "KD" 0 "KD" "0" "0" "1" "UNRELEASED" 0 1 "0" 0 " " 0 0 "0" " " " " "0" " " "A" "0" "0" 0

Re: Help in making query [message #445418 is a reply to message #445416] Mon, 01 March 2010 11:59 Go to previous messageGo to next message
BlackSwan
Messages: 24903
Registered: January 2009
Senior Member
It appears application could benefit from Third Normal Form.
Sad
Re: Help in making query [message #445419 is a reply to message #445416] Mon, 01 March 2010 12:00 Go to previous messageGo to next message
Littlefoot
Messages: 20824
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
./fa/5263/0/ You must be kidding! This is far from being a test case; this is a mess. Can't you create a simple test case that would be easy to understand and reproduce? Do you really expect someone to type all those values? If so, well, I'm afraid that you are very wrong.
Re: Help in making query [message #445420 is a reply to message #445408] Mon, 01 March 2010 12:03 Go to previous messageGo to next message
milindsaraswala
Messages: 4
Registered: March 2010
Junior Member

thats why I have given simple query in the first message but you people ask me all those things. Can you please go through first message and reply me.
Re: Help in making query [message #445421 is a reply to message #445420] Mon, 01 March 2010 12:13 Go to previous message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I asked you data in the form of INSERT statements.
Reread my post:
Quote:
Then you can write some insert statements for some data (of your own or from your database).

And my previous one I asked you:
Quote:
Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

In the end I also asked you:
Quote:
Finally given these example data, you can tell us what should be the result.


Of course, posting a test case means the simplest information that is needed to answer the question, we don't need all those address* columns and so on.

And take the greatest attention to BlackSwan's post.

Regards
Michel

[Updated on: Mon, 01 March 2010 12:15]

Report message to a moderator

Previous Topic: send pdff
Next Topic: problem with parsing parameter
Goto Forum:
  


Current Time: Sun Sep 25 04:16:08 CDT 2016

Total time taken to generate the page: 0.04498 seconds