Home » SQL & PL/SQL » SQL & PL/SQL » NUMBER EQUALS (WINDOWS)
NUMBER EQUALS [message #420612] Mon, 31 August 2009 22:50 Go to next message
siva.n.subramanian
Messages: 10
Registered: April 2009
Junior Member
Dear all,

i have 2 numbers eg 123456 in one table and in other table i have 0000123456. now i want to write a condition while joining the 2 tables that these 2 numbers are equal and view its output.

please help.
thanks and regards
siva nagarajan
Re: NUMBER EQUALS [message #420613 is a reply to message #420612] Mon, 31 August 2009 22:57 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.


We don't do homework.
Re: NUMBER EQUALS [message #420614 is a reply to message #420613] Mon, 31 August 2009 23:11 Go to previous messageGo to next message
siva.n.subramanian
Messages: 10
Registered: April 2009
Junior Member
Dear Blackswan,

I did go through the portal search and the oracle wiki but was unable to find the discussion on topic. hence created the post.

thanks and regards
siva nagarajan
Re: NUMBER EQUALS [message #420615 is a reply to message #420612] Mon, 31 August 2009 23:14 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
You want/desire/need SQL. Right?
We don't know table names or column names so no SQL is possible.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
Re: NUMBER EQUALS [message #420616 is a reply to message #420615] Mon, 31 August 2009 23:34 Go to previous messageGo to next message
Prajakta001
Messages: 52
Registered: June 2008
Location: Mumbai
Member

Please follow the guidelines as given by BlackSwan.

With given information may be you can convert them to number and then try the join .

Regards
Prajakta
Re: NUMBER EQUALS [message #420620 is a reply to message #420612] Tue, 01 September 2009 00:35 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
0000123456

This is NOT a number this is a string which may represent a number which number is 123456.

Regards
Michel
Previous Topic: partial Updation of coumn ! (merged 4)
Next Topic: Stored procedure date type compare ORA-01839
Goto Forum:
  


Current Time: Fri Dec 02 16:31:38 CST 2016

Total time taken to generate the page: 0.21287 seconds