Search results for query: *

I am trying to find all users who had transactions on three different dates and I don't want to wade through a compilation of the transactions of those dates. The only way I know how to do it is with intersect: select * from transactions where transaction date = date1 intersect select * from...

Hi Everyone, I have a table with the following structure EmployeeID Number Year1 Date Salary1 Number Year2 Date Salary2 Number Year3 Date Salary3 Number Year4 Date Salary4 Number Year5 Date Salary5...

Hi Group, I have this payroll table that I am just wanting to get the total number of records from, which is done using select count(*) from payroll, now I need to format the number so it is easier to read the number, the table has several million records in it. I have tried using to_number...

This is just a hypothetic question for right now. Supose a user/schema is granted select permission to use a function, call it function1, in the DB, and suppose function1 calls other functions. Now, does the select permission of the user/schema cascade down so that the user/schema can now call...

Hi Everyone, I have this function I am building so I can parse long datatypes. I keep getting a ORA-06502 error when I come to the following line select rls.text into rsqlcode from report_level_sql rls where rls.id = r_id; rls.text is the column with the long datatype, rsqlcode is declared...

Hi everyone, I'm trying to get some data displayed, but I want it transposed, and I can't figure it out, and the examples that I have found on the 'net haven't addressed my issue. What I have is a list of contacts and what company they are with, so a straight up select query will give me that...

Hey All, I'm working on report for the company website reporting various stats, what reports where run, where people when, etc. This report, the user selects a month and enters a year, and the various stats for the month selected and the month previous are populated into the report. Fairly...

I'm running a bunch of queries comparing data in two different tables, the my usual way of doing it is to use subqueries, select waht I need from each table and compare those results, however these tables are very large, 30,000 records each, so they take a long time to return results. I have...

I use the form-sql element to guide my sql code based on user input. The two tags below are basically how I use the element. <form-sql name="monthid" value="600"> <form-sql name="monthid" value="not(600)"> Now, what I want to know is if I can use an OR in the value attribute instead of...

Hey All, I'm currently converting some old Access '97 apps for use in our Oracle Database and I have a question. Once a month we get text file of payroll data. The file is not delimited in any fashion except in the sense that each line is a fixed length string, with various character positions...

Hi All, I work for a multi-employer pension plan. Every month we mail out reports that we generate using XML, XSLT, and SQL. For each employer we have to run the SQL script restricting it to just that employer. Which of course means that we have to run the reports many, many times, is there a...

Hey All, I work for a pension plan, and we need to know when certain dates occur for our members, such as 65th birthday for example. However when I do my calculations and then cast the result to a date using the to_date function I get a weird result I get the correct day and month, but the year...

I have a table that I'm trying to do a mass insert into, but one of the fields that comprises the primary key is also a foreign key, which is also a sequential number that is generated by the other table, doesn't get updated after the first record is inserted. Is there any way to keep...

Hey All, I hope that I have the right forum, right now my boss has me converting a bunch SQL queries into pdf reports using XSLT. Which is fine and has been going well. I've been asked to add another tweak to one of the reports. One of the reports lists the results by department. My boss now...

Hey All, I hope that I have the right forum, right now my boss has me converting a bunch SQL queries into pdf reports using XSLT. Which is fine and has been going well. I've been asked to add another tweak to one of the reports. One of the reports lists the results by department. My boss now...

Is there any way that I can do comparisons with just a year? What I am working on is a user enters a four digit year, i.e. 2006, now is there anyway I can do any date manipulation from that, specifically put 31/12/ in front of that? B/c if I can then all other date functions are possible. I...

Hey all, I need some help with figuring out the logic of the where stmt. Here's the situation: I have a web page front end, where the user inputs a criteria. If they want all pieces of type 3421, then they input 3421, and all pieces of type 3421 are displayed. Thats the easy part. However...

I need some clarification on the ORA-00904 error documentation. I have a column that is a case stmt, and I'm trying to use that column in the WHERE clause of my sql. Code: SELECT . . . CASE WHEN YTD < YMPE THEN 100 WHEN YTD > YMPE THEN 200 ELSE 0 END AS...

I'm trying to create a query that will show me when there is a difference of say 10% (the absolute amount really doesn't matter) between the previous record and the current record in a table. Example: Name |Score John |80 John |85 John |100 The query should show me the records...