|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
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 18th, 2008, 01:11 AM
|
|||
|
|||
|
Query in 10g oracle
Hi All,
I am facing problem with a select query in oracle 10g database from vb.net.It was working for oracle 9.Can anyone help me in finding what the problem is?The select statememnt I have written is as follows Str=" select UCC.table_name, UCC.constraint_name, UCC.column_name, UCC.position, UC.constraint_type " & "from USER_CONS_COLUMNS UCC,USER_CONSTRAINTS UC " & "where (UCC.constraint_name = UC.constraint_name) " & "and UC.constraint_type = 'P' " & "and UCC.table_name = " & " '" & TableName & "'" Regards, Seena
|
|
#2
April 18th, 2008, 01:15 AM
|
|||
|
|||
|
That is not a valid SQL statement (at least not for Oracle)
Print the real statement out, run it in SQL*Plus and then let us see the error message.
|
|
#3
April 18th, 2008, 06:58 AM
|
|||
|
|||
Your statement has correct syntax, what error are you getting?
__________________
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Query in 10g oracle |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
