I need update on following queries related to Database:
a) can we run "update" query directly at the time of defining database checkpoint (where we define our SQL query like select .. from <table name>...)?
b)I entered one sub-query like e.g. at the time of defining database custom checkpoint and that was running correctly
select ticket_price from flights where flight_number in (select flight_number from orders
but when i am entering directly in the script displaying "1" in printf log
c) I am facing problem in parameterize of SQL query as query mentioned in b)
how I can retrieve price for multiple customer (here I have defined array for customer name), but was not getting correct result. was showing me resulting price of very 1st customer