Search results for query: *

Never mind obout the previous post I have fixed the problem Thanks for the help

I think the problem is that since termout is off it does display the number of records. This is my query select b.office_id from bookings b, customers c, flights f where b.cust_id = c.cust_id and b.flight_no = f.flight_no and b.office_id < 101 order by c.cust_ID; It returns all the office...

Hi I have one more question about this method. I would like to see how many rows the query returns. When I do this method it puts all the results into a file but it does not state how many rows retrieved. Any thoughts?

You my friend are a freaking genius. Thankyou

By setting term off Sql still outputs to screen, but I would like it to Just output to the text file. btw I am using oracle 9i sql*plus

Hi want to output a simple query to a text file. Select * from bookings Please note I do not want it to be displayed on the screen as the table is very large. Any help would be appreciated

Just to add to my previous post. This query is being done in oracle 9i

Hi want to output a simple query to a text file. Select * from bookings Please note I do not want it to be displayed on the screen as the table is very large. Any help would be appreciated