UFT 11.51 API test – How to convert a data type in a checkpoint
Question ID: 104910

Is there a way to do this:

I have a test step that executes a SELECT statement against a database. One of the columns in the results set is a number represented in the database as a VARCHAR data type. I want to convert it to an integer and test if it is greater than some number. How do I do this in API testing?

Marked as spam
Posted by (Questions: 25, Answers: 12)
Asked on March 20, 2013 5:41 pm
Answers (1)
Private answer

You could use the oracle function to_number

Select to_number(field_name) from table_name

Marked as spam
Posted by (Questions: 3, Answers: 12)
Answered on March 21, 2013 12:49 am

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top