|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
April 25th, 2008, 01:21 PM
|
|||
|
|||
SQL Query
The below query is not working and the error its giving is ORA-01722
Code:
SELECT c1.certificate_nbr, c2.part_nbr as part171, c2.inactive_ind, c2.hts_cde, c2.originating_ind, c3.iso_country_cde, c2.basis_cde, c2.producer_cde, c2.cert_cde, c2.regional_value_content_cde, c2.part_nbr, c1.effective_dte FROM certificates c1, certificate_parts c2, displayed_countries_of_origin c3 WHERE c1.certificate_nbr=c2.part_nbr AND c2.part_nbr=c3.certificate_nbr; and i am really not understanding what to.... please help me...  Last edited by pabloj : April 25th, 2008 at 02:00 PM.
|
|
#2
April 25th, 2008, 01:45 PM
|
|||
|
|||
|
Thanks a lot for viewing it but i sloved it.....
since i am new to oracle developing i will be asking lots lots and lots of questions.... try to help me  Thanking You Bhagya Sree Nallagangu Quote:
|
|
#3
April 25th, 2008, 01:57 PM
|
||||
|
||||
|
Hi and welcome to Devshed, please consider this is not a free support service, don't expect an immediate answer, there is no SLA.
Then, in order to improve your chances, learn a few things: 1. use a descriptive subject for your posts 2. include full error messages and table(s) structure 3. add proper formatting to your code, make it easy to read 4. describe your requirements and expected results 5. provide sample data to reproduce your case 6. post the solution if you got it elsewhere
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Last edited by pabloj : April 25th, 2008 at 02:01 PM.
|
|
#4
May 10th, 2008, 04:26 AM
|
|||
|
|||
|
desc your tables to check the type of the column. although you see the data of column is number, but the type of column is char type. the connection of different type maybe cause the error which you mentioned. hope it can help you! ^^
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > SQL Query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
