• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 922
  • Last Modified:

query oracle database table

Hi

I am looking for syntax to query oracle database table

select * from XYZ_table where col1='123';

col1 is varchar column.

when I run above query giving invalid number error then says licence is not there error and hanging up Toad.


select * from XYZ_table;

Above query runs fine though.

Any ideas, suggestions, sample code, links, source code highly appreciated. Thanks in advance
0
gudii9
Asked:
gudii9
  • 2
  • 2
3 Solutions
 
slightwv (䄆 Netminder) Commented:
Try the query from sqlplus not Toad.
0
 
gatorvipCommented:
select * from XYZ_table where col1='123';

Open in new window


Syntactically, this is correct. You must have something else going on here - some things you can check:
- is there a partition on col1
- does your query work in SQLPlus
- are there some specific settings on numeric conversions in Toad
- also, what is the exact error
- does
select * from XYZ_table where col1='abc'; -- or some other non-numeric

Open in new window

work correctly?
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
Can you describe the table for us? Use:
desc XYZ_table;

Open in new window

and show the output. Thanks.
0
 
slightwv (䄆 Netminder) Commented:
What was the solution?

Splitting points to everyone doesn't help anyone in the future to solve their issue.
0
 
Gerwin Jansen, EE MVETopic Advisor Commented:
Agreed, I see no solution here, this question best be deleted if no answer is given.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now