Help in writing SQL query

10-11  Source: Network gathering  Views:1 

Advertisement
Hi evrybody,
I have a requirement which seems very wierd to me, I m unable to clue it also. Please help me in writing the same.
I have a column in a table which contains the data with spaces and everythng same as below:
SUBSCRIBER LINE TEST
VERSION 2
DEV SNB MP FCODE
LIBA-13 4222430012 11 3
FOREIGN VOLTAGE TESTS
DC AC
FVAE FVBE FVAB FVAE FVBE FVAB
LACC LACC 7.4 0.1 0.1 0.1
0.0 0.0 PASS PASS PASS PASS
PASS PASS
INSULATION RESISTANCE TESTS
IRAE IRBE IRABA IRBBA IRAB
LACC LACC LACC LACC 8113K
10000K >10000K >10000K >10000K PASSPASS PASS PASS PASS
CAPACITANCE MEASUREMENTS
CAE CBE CAB BRK
LACC LACC 4428 NO
68 72
NT LOOPBACK TEST
PASS
NT DC SIGNATURE TEST
V-HIGH V-LOW
83.920K LACC
PASS >10000K
PASS
NT CONNECTED
INV
CIRCUIT TEST RESULT
FAIL
I need to get the o/p as:
FVAELACC=0.0 FVBELACC=0.0 FVAB=7.4 FVAE=0.1 FVBE=0.1 FVAB=0.1
CAELACC=68 CBELACC=72 CAB=4428
NT CONNECTED=INV..
Thanks in advance.
Evrybody thanks for advices. My Question is little unclear but the requirement is that itself.. Anyways I got the O/p finally.
Mr. Shahzad ,if any of the questions makes u feel like wasting ur technical time, jus donot read it.. The people who can undertsand the problem, they can answer to the post. If the requirement is like that, none of us are helpless.
Related articles
  • Help in writing SQL query 10-11

    Hi evrybody, I have a requirement which seems very wierd to me, I m unable to clue it also. Please help me in writing the same. I have a column in a table which contains the data with spaces and everythng same as below: SUBSCRIBER LINE TEST VERSION 2

  • Need help in writing SQL query 10-11

    Hi, I have a rquirement where I need to convert columns into records. Table1: (note: I have around 150 columns i.e period1 to period150) unit startdate Period1 period2 period3 period4 period5 A 1/1/2011 100 200 300 400 500 Now I need data in below fo

  • Help in writing a query! 10-11

    Dear All, My database is 11gR2 on Linux. I am struck in writing a difficult query, need help from your guys. I have a table, an application is controlling the columns of this table. Columns are added by the application. This is the structure of the t

  • Help with an SQL Query on the Logger 11-30

    We are running UCCE 8.5(3) and need help with an SQL query. When I run the below I would also like to see skill group information(name preferably)? Any help would be greatly appreciated! select * from dbo.t_Termination_Call_Detail where DateTime betw

  • Help needed for SQL query 10-11

    hello , I am a beginner in terms of writing sql queries. I hope some body can help me out. I have two tables mysql> desc user_group_t; ---------------------------------------------------+ | Field | Type | Null | Key | Default | Extra | --------------

  • Help with T-SQL query 11-30

    I have 3 hierarchical tables. [Parent] ->[Child1]->[Child2] I have [Xref] table which stores the documents associated with these three tables. In the [Xref] table, the column "TypeID" defines to which table the document is associated with.

  • Help with translating SQL query from SQL Server syntax to Oracle syntax 11-30

    Hi, is it someone that can help me translate following SQL query from SQL Server syntax to Oracle syntax. SELECT ID, [LMT(MTR)] = MAX(case when TYPE = 'LMT' then VALUE end), [AAD(KGM)] = MAX(case when TYPE = 'AAD' then VALUE end), [VOL(MTQ)] = MAX(ca

  • Newbie - help with a SQL query for a bar chart  - Originally posted in APEX 11-30

    I originally posted this in the APEX forum but someone there suggested this is more of a SQL question.  Anyone out there who can provide some assistance? Hi, I'm a new user on APEX with no real SQL knowledge and I'm trying to build a dashboard with c

  • Newbie - need help with a SQL query for a bar chart 11-30

    Hi, I'm a new user on APEX with no real SQL knowledge and I'm trying to build a dashboard with charts into an existing APEX application. Based on another application, I have come up with the following SQL code: select null link , CATEGORY label , cou

  • Selection screen - search help with dynamic sql query 11-30

    hey , is it possible to change the search help of the selection field ? when i create the range table i put a data element : create a range table that consists of this new data element   LT_RANGE_TABLE = WD_THIS->M_HANDLER->CREATE_RANGE_TABLE( I_TYP

  • Need help in the sql query 10-11

    i have a table source table : create table order(name_a varchar2(100),intid number); insert into order values('a',1); insert into order values('b',1); insert into order values('c',1); insert into order values('d',1); insert into order values('e',2);

  • Need help in writing the query 10-11

    The initial data is as follows: ID PARENT_ID ============= 1 NULL 2 NULL 3 2 4 6 5 3 6 7 7 4 8 NULL but output is as follows in such way that Parent_Id should be displayed in ID place ID PARENT_ID ============= 1 NULL 2 NULL 3 2 8 NULL 6 8 4 6 5 3 7

  • Help with JSTL sql query 11-30

    i have a query that i want to pass a paramater to the query goes like this <sql:query var = "user" > SELECT AMOUNT,flag FROM SAVINGS_ACTIVITY_DETAILS WHERE ACCOUNT_ID =? AND AMOUNT >200000 AND Flag =1 AND ACCOUNT_ACTION_ID =6 AND Treate

  • Help on JSTL sql:query / tag 11-30

    Hi..... Currently i am trying to query a date from MSSQL using <sql> tag. I had tested in MSSQL on this SQL statement which is:- SELECT * FROM hr_leave WHERE startDate LIKE 'Apr 20 2006%' It can query my MSSQL datetime. Then , I apply this query ins

  • Help in framing SQL Query 10-11

    Hi, Could someone please help me with the below requirement. On the sample EMP table I want a report that is like: Manager Tot_Joiniees_Q1 Tot_Joiniees_Q2 Tot_Joiniees_Q3 Tot_Joiniees_Q4Please refer the below query for the relevant columns and the qu

  • Help required in SQL query 10-11

    I have a table and cols as below: START DATE     TOTAL DAYS 10/11/2011 15:00      1 10/15/2011 5:00      1 12/22/2011 10:00     1 12/22/2011 11:00     2 12/30/2011 10:00     1 1/1/2012 1:00     1 1/1/2012 10:00     1 1/1/2012 16:00     2 1/2/2012 14:

  • Need help with writing a query with dynamic FROM clause 11-30

    Hi Folks, I need help with an query that should generate the "FROM" clause dynamically. My main query is as follows select DT_SKEY, count(*) from *???* where DT_SKEY between 20110601 and 20110719 group by DT_SKEY having count(*) = 0 order by 1;

  • Need help in writing a query 10-11

    Hi, I have a table with two columns as follows child parent mom grandma daughter mom How can I write a single query so that the result will be daughter,mom,grandma? Thanks Ravi.Responses to these postings will help: pivot the column names PIVOT in or

  • Help Needed In SQL Query 10-11

    HI All, Oracle sql clarification required Sample Table: empno empname Job mgr_id hire_date salary deptno 7788 SCOTT ANALYST 7566 19-APR-87 3000 20 7902 FORD ANALYST 7566 03-DEC-81 3000 20 7934 MILLER CLERK 7782 23-JAN-82 1300 10 7900 JAMES CLERK 7698

  • Need help in this sql query to use Case Statement 10-11

    hi All, I have the below query - SELECT DISTINCT OFFC.PROV_ID ,OFFC.WK_DAY ,CASE WHEN OFFC.WK_DAY ='MONDAY' THEN 1 WHEN OFFC.WK_DAY ='TUESDAY' THEN 2 WHEN OFFC.WK_DAY ='WEDNESDAY' THEN 3 WHEN OFFC.WK_DAY ='THURSDAY' THEN 4 WHEN OFFC.WK_DAY ='FRIDAY'