Home » SQL & PL/SQL » SQL & PL/SQL » Regarding columns of number and string datatype comparisons (oracle)
Regarding columns of number and string datatype comparisons [message #337737] Fri, 01 August 2008 00:07 Go to next message
vernonmechery
Messages: 3
Registered: August 2008
Junior Member
Hi all,

I have two tables by name (table1) and (table2). table1 contains a column with a varchar2 datatype, which contains the data like (143 - delhopt). and table2 contains a column with a number datatype.

Now, I want to compare these two tables on the basis of these two columns. I want to extract the number 143 from table1 and compare it with table2. how can I do it? Please help me....
Re: Regarding columns of number and string datatype comparisons [message #337738 is a reply to message #337737] Fri, 01 August 2008 00:11 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above


Re: Regarding columns of number and string datatype comparisons [message #337741 is a reply to message #337738] Fri, 01 August 2008 00:15 Go to previous messageGo to next message
vernonmechery
Messages: 3
Registered: August 2008
Junior Member
Hi,

Thank you for the guidelines. I think I have followed it properly. I require an urgent help.
Re: Regarding columns of number and string datatype comparisons [message #337742 is a reply to message #337737] Fri, 01 August 2008 00:19 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I think I have followed it properly.
>I require an urgent help.
Please post a copy of the actual Posting Guidelines
& then show how/where you conformed to guidelines.
Re: Regarding columns of number and string datatype comparisons [message #337743 is a reply to message #337742] Fri, 01 August 2008 00:23 Go to previous messageGo to next message
vernonmechery
Messages: 3
Registered: August 2008
Junior Member
I am sorry. I will prepare my requirements according to the guidelines and then post it. Thanks anyways.
Re: Regarding columns of number and string datatype comparisons [message #337745 is a reply to message #337741] Fri, 01 August 2008 00:35 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
vernonmechery wrote on Thu, 31 July 2008 22:15
Hi,

Thank you for the guidelines. I think I have followed it properly. I require an urgent help.

http://www.orafaq.com/forum/t/88153/0/
Posting Guidelines clearly state AVOID words like "URGENT"

Can not you read & understand?
Re: Regarding columns of number and string datatype comparisons [message #337754 is a reply to message #337743] Fri, 01 August 2008 00:57 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, guidelines say you have to search before posting and extracting a number from a string has been asked many and many and many times.

Regards
Michel
Previous Topic: Create a view based on a public synonym
Next Topic: How to query of the table has a CHAR data type
Goto Forum:
  


Current Time: Sat Dec 10 05:09:17 CST 2016

Total time taken to generate the page: 0.11703 seconds