Search results for query: *

Hi George, I believe I figured out the syntax error in the code. I took out the AS from: ) As A and it seemed to have worked fine. I also was able to put in my where clauses. Now if you could go through a quick explanation that would be wonderful. THanks again!

Hi mercury, i tried your code as well and if i change it a bit to give me other information it will return all the max timestamps of each different transaction for that user. So what I'm trying to get it to do now is return the last transaction for that user. ? hope that makes sense. Thank you !

Hi George, I've tried to run the code you supplied and its giving me the following error: ORA-0095 Missing keyword on the line containing: ) As A Also, is Inner Join a recognized sql function, because it seems only the Join is blue and the Inner isn't. could i add another where clause...

I have a table that contains a timestamp that is captured after each time a particular unique instance (example person) is changed or a transaction takes place on that person. So for example if my table contains 30 different users that are logged in or logged out or absent or on vacation i want...

I wouldn't know where to put that select statement or how to create the function from just one table? Sorry if I'm unclear. Thanks, JE

Well the table that has the codes doesn't have all the other columns. This is my sql: SELECT lot_warehouse.molname as Compound_Name,lot_warehouse.lnb_ref as LNB_Ref,sts_project.project_code as P_Codes...

So my next question for you is how? :( I have a very large sql statement that is returning many more columns than those 4. I know that I would have to change the function a bit to include those columns but I'm stuck on what I would change "je27" to. For instance in the function: for c in...

Sorry, for the misunderstanding. Ideally I would like to be able to run a sql to output the data the way you have shown. I just wasn't sure how the function worked, but you have clarified that now. I simply have to run the create function sql then incorporate: col code format a20 select...

OH and Thank you!!!

Hi, So this function is used after the data is retrieved, right? So if i have an application I can use a function like this to manipulate the data and output it this way in excel?

Ok thanks, will do.

I have a query that is looking in many different tables and I am trying to see if there is a way to retrieve the data below so that it removes duplicates but puts the values that are not dupilicate in the same cell with a comma delimiter. Tables: Name.......Code....Well....Project...

This is a relational oracle database.

I have a query that is looking in many different tables and I am trying to see if there is a way to retrieve the data below so that it removes duplicates but puts the values that are not dupilicate in the same cell with a comma delimiter. Tables: Name.......Code....Well....Project...

I am trying to convert a lotus 123 workbook or spreadsheet into an Excel Workbook and I had 14 cells that could not be read. I figured out the formulas for these cells in Lotus 123 but I do not know how to convert them so that Excel can read them. The other problem is I do not know how to...