Search results for query: *

Thanks.

Besides thank you 1 million times it works great. It seems like I have much reading to do on the powers of sysdate and trunc. As for using the union I was planning on doing this in case statements. Do you see a problem? Also, since I realized I did not mention it but you did it your prior...

Below is what you requested SantaMufusa describe hpd_helpdesk; Name Null? Type ---------------------------------------- CASE_ID_ NOT NULL VARCHAR2(15) SUBMITTED_FOR VARCHAR2(30) ARRIVAL_TIME NOT NULL NUMBER(15) ASSIGNEE_LOGIN_NAME...

Thanks again LKBrwnDBA. Your help is always appreciated.

O.k. Still can't believe one line of code to transform epoch into human readable time:) This is what I have been looking for everywhere. Thanks for this. The sad part is that I I tried what you suggested SantaMufasa and still receiving ORA-01830: date format picture ends before converting...

Hello again, Yes my grammatical errors are all over this forum:) In my original post I was just trying to give you an idea about what I was trying to do and was improperly naming functions and tables. Your are correct in saying that my function name is total different in my most recent post...

Sorry SantaMufasa, Actually it was a mistype. The table is hpd_helpdesk So it would be For Last 12 Mths select * from hpd_helpdesk where convert_to_epoch(arrival_time) between last_day(add_months(sysdate, -12)) + 1 and sysdate; and For Year to date select * hpd_helpdesk table where...

Hello experts, Need help figuring out YeartoDate and Last12Months syntax. I'm trying experts, trying my best. YearToDate = is it select * from table where convert_to_epoch(arrival_time) between TRUNC(SYSDATE,'YEAR') and sysdate; Last12Months select * from table where...

Sorry again, I am having one of those days. I figured it out. Just remove the parameter and all is good. I should have looked at it before I wrote the email. Anyways, if you have anything for epoch I would definitely be appreciated.

Thanks LKBrwnDBA, Wow that is great!!!!! What if I didn't want to add a parameter and just wanted to find out last weeks data without the parameter prompt. Also, I know I am pushing it, but do you know of anything for epoch conversion. The create date in your select needs to be converted...

Hello again experts, Has anyone had any luck on this. Please your help is appreciated. Thanks again.

Well Anand, I tried to copy and paste the code with no luck. I'm still not sure on the function part. Doesn't the function need to be create and deployed first before it can be used. Sorry excuse my ignorance but just trying to understand what is happening. Thanks again for replying Anand.

Oh experts, I am finally on my way with Oracle. I've tossed everything I know about SQL Server and strictly focusing on Oracle. So I need help with the following. I have created a package with a procedure and I need to know how to find all data for the prior week starting from Sunday to...

Hi LkBrwnDBA You did help me as you lead me in the right direction. I posted a message on the crystal reports forum and synapsvampire helped me. Please refer to thread766-1219880. I switched my connection to use native oracle driver and so far so good. Runs perfectly. So all the experts...

Ah yes, Now I understand Synapsevapire. I'm not sure where my head is today. You are referring to the oracle server(create New Connection) part in crystal reports directly bypassing the ODBC connection. Now I understand. I had to install the drivers from the crystal CD inorder to get this...

Thanks for the reply Synapsevampire, When you say the crystal supplied native connectivity and that it's listed are you talking about the Microsoft ODBC for Oracle version 2.575.1117.00 because I do not see any others besides the one's I listed. Their is the SQL Native Client but I'm assuming...

Hello all, Well LkBrwnDBA you lead me in the write direction. I had suspicion it was related to the oracle driver after your response since I wanted to make sure first that I was not doing anything wrong in the proc. So looking at the cr_oracle_stored_procedures.pdf they confirmed to use the...

Sorry guys I figured it out. I had suspicion it was related to the oracle driver so looking at the cr_oracle_stored_procedures.pdf they confirmed to use the crystal for oracle ODBC driver. So I setup another DSN using the Crystal Oracle ODBC Driver 4.10 instead of the Oracle in OraHome92...

Hello experts, I have sent an email to the Oracle 9i forum and received an answer saying that the issue might be related to crystal reports so I need all the experts advice. I have created a very simple Oracle Stored procedure(I am trying to learn oracle 9.2) and what I found was that crystal...

Oh I see, well I have tried what you asked and this is the error that I receive. Sorry I have no idea how to copy and paste into here so I will manually type it Query Engine Error:Hy000:[Oracle][ODBC]ORA-06550:line 1 column 45:PLS-00567:Cannot pass NULL to a NOT NULL constrained formal...