Search results for query: *

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

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...

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...

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...

Any help?

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).

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.

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

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

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...

Yes It is oracle but select statements should be similar.

Here I am trying to add at least 16 columns in one of the row in a table to find out percentage. So I have created 16 views OTC1,OTC2... in OTCn,OTCm I am getting percentage. Is there a way so that I create only one or two views? CREATE OR REPLACE VIEW VEW_OTC1 (col1,col2) as select 1 as...

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

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.

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...

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...

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...

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...

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

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