Hi All,
I have to join two tables,table A is having a column Store_id as number ei 1234
and table B having the column as character as 'SOLUTION STATION - # 1234'
i have used the condition as follows:
where (replace(B.stor e_name,'SOLUTIO N STATION - # ',''))=to_char( A.STORE_ID)
i am getting error as "invalid number"
can any one suggest me the right solution for this ?
Thanks in advance....
dharmu131983
Last Activity: Oct 17 '08, 04:27 PM
Joined: Sep 4 '08
Location: India
-
Comparison of character and number
-
script to download csv file from a FTP location.
Hi All.
thanks a lot for all ur previous replies.
Can any one of suggest me the perl script for downloading a CSV or excel file from a FTP location to my local machine? -
Semi Join with 3 tables
Hi,
i have 2 tables A & C but i dont have any column common to join them. so i am using a 2nd table say B from my data base and using that i am joing A and C.
I want only distinct Values from the table A. Column which is used for Joining A and B is havng multiple values in Table C.
can any1 suggest me how to perform semi join with 3 tables so i get ONLY distinct rows from table A.
query is being used for inserting... -
Problem in code
Hi I am very new to PERL i have written code as :
if (open(PROGRAM_1 , "C:\program_1") ) {
print ( "working");
}
for opening the simple txt file but it is showing error as
"Name "main::PROGRAM_ 1" used only once: possible typo at Untitled1 line 3.
Please do help me.i am using perlexpress on windows environment.
No activity results to display