I have a table name Passenger where I have a column name Id_Number.
In the Id_number column, I have given 10 ids. so reading this id from this column and putting in an application. can anyone help how can I do this? Please help.
Generally, How to loop this. I want to picup this id number one by one and use into the type into activity.
-Use for each row loop and pass the datable as input
-inside the loop use type into activity pass the value as
Row(“column name”).tostring or
Row(“column index”). tostring
(Here Row is for each row variable name…you can even keepyour name as u like)
Hope this would help you
I am interacting with the oracle database bro, Is sql and oracle db query same.
Yah you can use execute query activity with which u can access any db servers…
The output would be in datatable type
You can use this activity buddy
Is it fine what you said bro.
In Type Into activity, write like this:
Buddy You can either use column name like Row(“column name”).tostring
Okay, Thanks bro
Directly from data table you can list like this if your select query return single row.