Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TekMem
  • Order by date
  1. TekMem

    Joining Tables with no duplicate value

    select a.applno, p.perno,p.cirno from appl a ,per p where a.applno=p.applno UNION SELECT '', perno,'' FROM PER where applno is null UNION SELECT applno, '','' FROM appl where cirno is null
  2. TekMem

    Joining Tables with no duplicate value

    I have created smaller tables for this thread with diff name but my original select statement is something like this select a.section_name, a.varchar_255_19,a.varchar_255_17 as appl, p.document_type, p.varchar_255_17 from appl_env_main a ,permit_env_main p where...
  3. TekMem

    Joining Tables with no duplicate value

    I have three tables and I want to join them so that no value is repeated in the columns. My tables are 1. Cir Cirno Address C111 50 Yonge St C112 15 Victoria Park 2. Appl Applno Cirno Address A500 C112 15 Victoria Park A501 C112 60 Flower Town A502 90 Law Av. 3. Per Perno Cirno...
  4. TekMem

    How can I modify excel chart Title

    Dim oXL As Application Dim oWB As Workbook Dim oSheet As Worksheet Dim oRng As Range Dim ochart As Microsoft.Office.Interop.Excel.Chart 'Dim objExcel As New Microsoft.Office.Interop.Excel.Application Try ' Start Excel and get...
  5. TekMem

    How can I modify excel chart Title

    Any help?
  6. TekMem

    How can I modify excel chart Title

    Thanks PRPhx for response. There is no problem in adding new charts but cannot modify chart title for existing chart. I am unable to write codes to open chart and modify its title(I am not declaring chart objects properly so that it can open existing chart).
  7. TekMem

    How can I modify excel chart Title

    Hi, I need help to modify title for existing chart in my excel. I can open my excel...populate data in cells but I am not sure how can I modity TITLE for the existing chart in that excel. Thanks.
  8. TekMem

    Count (*) for row of a table

    You guys are amazing! Thanks to both of you and have a star as token of appreciation from me.
  9. TekMem

    Count (*) for row of a table

    Thankyou SantaMufasa. I could not follow what are we trying to do here nvl(col1,0)+nvl(col2,0)+nvl(col3,0)+nvl(col4,0)) / length(col1||col2||col3||col4)*100
  10. TekMem

    Count (*) for row of a table

    I have created a view. Which looks like Col1 col2 col3 col4 ....... Coln 1 1 0 2/3*100 0 1 0 0 1/4*100 In coln I want to calculate percentage. I want to count number of ones in the row, then find out null value in the row...
  11. TekMem

    What is the impact of creating unnecessary views on data base?

    Yes It is oracle but select statements should be similar.
  12. TekMem

    What is the impact of creating unnecessary views on data base?

    ...<60 CREATE OR REPLACE VIEW VEW_OTCn (col1,col3,col2) AS select col1,col3,col4 from VEW_OTC1, VEW_OTC2,... where col2=col4 and ... CREATE OR REPLACE VIEW VEW_OTCm (col1,col3,col2,sum,per) AS select col1,col3,col2,(col1+col3),(col1+col3...)*100/16 from VEW_OTCn
  13. TekMem

    What is the impact of creating unnecessary views on data base?

    What is the impact of creating unnecessary views on data base? Creating views makes my work easier. Thanks.
  14. TekMem

    statement to see result in a line

    My select statement is: SQL>select dwg from mytable where ... Dwg1 Dwg2 Dwg3 Dwg4 4 rows selected. I want see Dwg1, Dwg2, Dwg3, Dwg4 Need some way around to see result in a line.
  15. TekMem

    Error message-ORA-01722: invalid number

    Thanks Hoinz! I had a doubt about my OS setting...initially I had asked is it to do with my XP settings. I have to figureout somthing which is good for both the type of the settings. So that my program can run on both. Good night hoinz...Anyway still good morning for me. I will appreciate...
  16. TekMem

    Error message-ORA-01722: invalid number

    Thanks to everybody for the valuable input. Hoiz, I owe you a golden star! SQL> select value from nls_session_parameters 2 where parameter = 'NLS_NUMERIC_CHARACTERS'; VALUE -------------------------------------------------- , 1. How can I change back to period(decimal). Even my date...
  17. TekMem

    Error message-ORA-01722: invalid number

    Hoinz, SQL> select to_number('0.123') from dual; select to_number('0.123') from dual * ERROR at line 1: ORA-01722: invalid number SQL> select to_number('0,123') from dual; TO_NUMBER('0,123') ------------------ ,123 Yes decimal is the problem. So what should I...
  18. TekMem

    Error message-ORA-01722: invalid number

    This time I got PROBLEM WITH: .5 => Typ=1 Len=2: 46,53 PROBLEM WITH: .25 => Typ=1 Len=3: 46,50,53 PROBLEM WITH: 0.75 => Typ=1 Len=4: 48,46,55,53 PROBLEM WITH: 0.75 => Typ=1 Len=4: 48,46,55,53 PROBLEM WITH: 0.75 => Typ=1 Len=4: 48,46,55,53 PROBLEM WITH: 1.25 => Typ=1 Len=4: 49,46,50,53 PROBLEM...
  19. TekMem

    Error message-ORA-01722: invalid number

    How should I deal with this problem. Need help. Want to add all those numbers. Thanks
  20. TekMem

    Error message-ORA-01722: invalid number

    Carp, I get PROBLEM WITH: .5 PROBLEM WITH: .25 PROBLEM WITH: 0.75 PROBLEM WITH: 0.75 PROBLEM WITH: 0.75 PROBLEM WITH: 1.25 PROBLEM WITH: 1.25 PROBLEM WITH: 2.5 PROBLEM WITH: 0.5

Part and Inventory Search

Back
Top