Search results for query: *

Hi, In the following cursor, I need to raise an exception when the Insert in the Loop fails. My objective is, if all the records retrieved by the cursor are NOT inserted, then abort the insert transaction and do not commit. Should my EXCEPTION be just before the loop ends or after the loop...

Hi, My question is how oracle treats an INSERT transaction before issuing a COMMIT. While I am doing an INSERT transaction, will oracle wait until I have inserted all my records within that procedure and then when I issue a COMMIT statement will the records be saved in a sequence for this...

Hello, We have our offices across Europe and Asia. Our users in these offices access and run crystal reports (Business Objects Enterprise R 3.1 sp4)that is installed in our location in New Jersey. There seems to be an issue with using date time functions like Currentdate, Today, Now...

Hello, We have our offices across Europe and Asia. Our users in these offices access and run crystal reports (Business Objects Enterprise R 3.1 sp4)that is installed in our location in New Jersey. There seems to be an issue with using date time functions like Currentdate, Today, Now...

I have 2 tables. Table A has information about inactivated print jobs and Table B has the description for Inactivation. Note: Print jobs can be reactivated and again Inactivated. That is why Table A can have the same print job id more than once. Now my objective is to retrieve Inactivated...

I have 2 tables. Table A has information about inactivated print jobs and Table B has the description for Inactivation. Note: Print jobs can be reactivated and again Inactivated. That is why Table A can have the same print job id more than once. Now my objective is to retrieve Inactivated...

I was able to flatten a table (made rows into columns). However my output has NULLS. I want to have just one row for every document name. I do not want to create Procedure or use a Cursor. I want to know can this still be done with a query. Thanks for your help! Table_1 ID(PK) DOC_ID...

I am a Crystal Reports developer and I have always been working with Oracle database and this is my first time with SQL Server. This is what I have been desperately searching for. From my local PC, I want to connect to a SQL SERVER database which is on a database server. I am aware that I...