Home » SQL & PL/SQL » SQL & PL/SQL » CAN YOU HELP ME GET THE LOGIC (ORACLE 10G)
CAN YOU HELP ME GET THE LOGIC [message #339584] |
Thu, 07 August 2008 21:13  |
victory_nag
Messages: 36 Registered: June 2008 Location: CA
|
Member |
|
|
I HAVE TABLE A. THE DATA IN TABLEA IS SHOWN AS BELOW.
TableA
ID Qstn Ans1 Ans2 Ans3
1 i Y N Y
1 N N
1 k Y
2 i Y y Y
2 J N Y Y
2 K
3 J Y
3 K N Y
THE DATA IN TABLEA SHOULD BE LOADED(INSERTED) INTO TABLEB AS SHOWN BELOW.
TABLE B
ID QSTN1 ANS1 ANS12 ANS13 QSTN2 ANS21 ANS22 ANS23 QSTN1 ANS31 ANS32 ANS33
1 I Y N Y N N K Y
2 I Y Y Y J N Y Y K
3 J Y K N Y
CAN ANYONE OF YOU HELP ME GET THE LOGIC,HOW TO DO IT.
SCRIPT TO CREATE TABLES AND DATA:
CREATE TABLE TABLEA( ID NUMBER, QSTN VARCHAR2(5), ANS1 VARCHAR2(5), ANS2 VARCHAR2(5), ANS3 VARCHAR2(5) );
INSERT INTO TABLEA VALUES ( 1,'I','Y','N','Y');
INSERT INTO TABLEA VALUES (1,'','N','','N');
INSERT INTO TABLEA VALUES (1,'K','','','Y');
INSERT INTO TABLEA VALUES (2,'I','Y','Y','Y');
INSERT INTO TABLEA VALUES (2,'J','N','Y','Y');
INSERT INTO TABLEA VALUES (2,'K','','','');
INSERT INTO TABLEA VALUES (3,'J','Y','','');
INSERT INTO TABLEA VALUES (3,'K','','N','Y');
CREATE TABLE TABLEB (ID NUMBER, QSTN1 VARCHAR2(5),ANS11 VARCHAR2(5),ANS12 VARCHAR2(5), ANS13 VARCHAR2(5),
QSTN2 VARCHAR2(5), ANS21 VARCHAR2(5), ANS22 VARCHAR2(5), ANS23 VARCHAR2(5),
QSTN3 VARCHAR2(5), ANS31 VARCHAR2(5), ANS32 VARCHAR2(5), ANS33 VARCHAR2(5));
THANKS.
|
|
|
|
Re: CAN YOU HELP ME GET THE LOGIC [message #339597 is a reply to message #339588] |
Thu, 07 August 2008 21:33   |
victory_nag
Messages: 36 Registered: June 2008 Location: CA
|
Member |
|
|
iT IS ONE OF MY PART IN ETL PROCESS. THE DATA IN TABLEA IS DEFINED SUCH THAT THE "ID" REPEATS 3 TIMES TO ANSWER 3 QUESTIONS.
BUT IN TABLEB ID IS PRIMARY KEY COLUMN SO THERE SHOULD NOT BE ANY DUPLICATES OF ID. HENCE THE DATA IN TABLEB SHOULB BE AS SHOWN.
|
|
|
Re: CAN YOU HELP ME GET THE LOGIC [message #339605 is a reply to message #339584] |
Thu, 07 August 2008 22:05   |
 |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
Your Caps Lock key is stuck ON & needs to be repaired/replaced.
For example in TABLEB why is J in QSTN2 & not in QSTN1, etc.
>THE DATA IN TABLEA IS DEFINED SUCH THAT THE "ID" REPEATS 3 TIMES TO ANSWER 3 QUESTIONS.
Then why does ID=3 have only 2 rows & violates the requirements!
>CAN YOU HELP ME GET THE LOGIC
You offer no logic requirement to implement
You're Own Your Own (YOYO)!
[Updated on: Thu, 07 August 2008 22:15] by Moderator Report message to a moderator
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Feb 17 21:54:11 CST 2025
|