Search results for query: *

I have a number of tables they have some master/child realtionship i.e they can be joined by related columns. Now I understand I can create outer joins in these tables and should start with a MASTER table and from their keep joining tables to each other including ALL columns that are common...

I have a table like: orderid, custname, zipcode, orderdate. I want to count to do like this: select orderdate, count(distinct custname,zipcode) from a_able group by orderdate. Bu this does not work. I am trying to get for an order how many distinct custname were their in in zip code...

I have a huge table and I intend to do: insert into another_table select * from big_table; Will this run into can not extend rollback segment error?

Is there a dictionary view that can give me status of refresh of Materialzed view(i.e, success, error code if failed on error etc)?

I have a legacy code and need to run this from perl. I can not use DBI as this needs to fit in legacy. system("sqlplus \/NOLOG <<EOF connect scott\/tiger\@store; select sysdate from dual; exit EOF "); This does not work and keeps prompting me for help on sqlplus. Seems somewhere may be at <<...

I want to have functionality of typeahead in list box. Any help?

I have my application on Solaris with Tomcat. Now I want to do following things: when this application starts prompt user for his user name/password, if they typed these matching the ones in Active Directory (the users run this application on window XP on company's hosted active directory) then...

I have data like: 0.01 0.02 0.03 0.23 0.29 .. .. 23.20 This data I have in excel spreadsheet I like to plot that will shows how many data(percent and absolute values) I have in 10 minutes interval( In above I have in first 10 minutes 3 transactions, in next 10 minutes 0 transactions and in...

I want to processs some code when tab page is selected. I used 'On Click' event that seems to work fine if I click in the middle of tab page. But users will click on the little thumb nail to select a tab and this event does not seem to fir at that time. What other things can I do to accomplish...

I have a tabular report in which every field comes from a table except one that comes from a detail table. How can I create this report. It should look like: cust_id cust_name productid(s) 1 John 100,101,102 .. productid(s) are from detail table. Any clues?

I have a table with check box against each row of data. I want to provide a global check box[check all] on top which if clicked should check all check boxes on the form. I do not find any method to that. Any ideas, what method of check box I call? Thanks

I have a query: select 'True' as print_flag, cust_id from cust; How do I cast print_flag to cast to Boolean(true/false or yes/no)? Seems this comes up as text when I base my form on this query.

I want to add a check box to each row of a table. This table is a straight dump of data from a table. What I am trying to do is provide user a way to chose(print or do something else) for the row checked. How do I do this? I created a tabular object usning wizzrad and then added manually a check...

I have a Oracle 9i database and I want to generate 10/15 reports in pdf that users can view and print thru IE browser. Really not interested to buy a tool like crystal or oracle report writer etc. Are there some freeware I can use in my JSP code to do this. I just picked up pdf since Acrobat...

I create a report passing parameter. That works fine. Problem is that users may not even pass parameter every time when they run this report, likemthey want to see all results. So Itry codeing where clause like: cust_id = NVL(?cust_param,cust_id) NVL is an oracle function that says if...

I have couple of reports done using crystal report 10. I want to put them on web. My front end is JSP and I have a Tomcat server. What other pieces I need to install to make this work. JSP page really passes ULR alnog with arguments and them report works. I tested report in client server that...

I am new to crystal report. I have some old reports done in Oracle report, I am trying to convert them to CR. I pass some parameters form JSP page. The user may pass any of the five parameters and the report should print data based on parameters passed. In oracle report I can change where...

I run this query in access pointing to Oracle SELECT CInt(Right(Trim(mse_name),4)) FROM db_own WHERE ((Left([mse_name],4))='DB19') and len(trim(mse_name)) = 8 and CInt(Right(Trim(mse_name),4)) > 70 I get Invalid Number error. It is the where 'CInt(Right(Trim(mse_name),4)) > 70' giving...

I migrated an sqlany db to Oracle and now after linking all forms in access application when I run it I get many errors. Most commons are recordsetclone error, invalid number, invalid expression. I am using common data types like integer, char etc. I will think after I link all forms correctly...