Search results for query: *

hi to all, I am learning oracle on my own. I have personal oracle installed in my win2k os. I have 1600 records in my excel files . I created a table items in oracle . I tried to export data from that excel file using sql * loader and I was able to export only 32 records and got the message like...

hi to all How frequently data are refreshed in data ware house application? where Can I get more information about data ware house information? with best regards Niran

thanks Dima, I got it the query should be like this select count(*) from user_tab_columns group by table_name having table_name=<table_name> best regards Niran

thanks thejon and donutman I got it .

Hi I have a table like this state sales oh 200.00 DE 700.00 NJ 800.00 NJ 500.00 NY 2000.00 IN 100.00 .. .... I need to get the results like state sale NJ 1300 NY 2000 other 1000 I need to show top five...

Hi I have a requirement for my front end that I should create text boxes based on the number of columns . How can I get number of columns of a table if I know the table name? or how can I query to retrieve number of columns of a table? thanks in advance

Hi, I need to retrive only top five sales agents from sales table .Sales table contains sales agent's name and amount of sales for each agent in addition to other fields.Can we do that without writing procedure? Thanks in advance