[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 918
  • 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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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