Search results for query: *

Okay I feel pretty stupid right at this moment, as I feel that this should be an easy answer but here I go. I want to search a text field and return rows where there is an underscore '_' in the text. The problem is, is that the underscore is a single character wildcard as you all well know...

I can not seem to resolve the following problem. Compliling the following returns PLS-00452: Subprogram 'BLOCK_OFFSET' violates its associated pragma. However, I can not see anything that would indicate that the function is writing to the database. -- In Header function block_offset(InDate...

I am running into a sporadic problem which appears to be getting more common. Firstly I am running Oracle 8.0.5.1.1 on NT6SP6. I am running my query directly on the server, so a network problem should not be the issue. The problem I am having is this. I am occasionally getting an ORA-03113...

I am more an Oracle user than Sybase, so please excuse my short comings with regards to Sybase. I am extracting data from a sybase (System 11) table that contains a field with text information. The text can contain linefeeds and carriage returns (Char(13) + Char(10)), and so when I run an...

Okay, this one is driving me nuts. In sqlplus the query: select to_date(19960501,'yyyymmdd') from dual; returns: 01-MAY-96 The query: select to_char(to_date(19960501,'yyyymmdd'),'mm/dd/yyyy') from dual; returns: 05/01/1996 This is what you would expect right? The thing that perplexes...

Hello, I have a problem with a mutating trigger. I have table that contains sort keys, and when a row is deleted, I want the sort keys to be resorted so that there are no gaps. Ie, if I have 100 rows, sorted 1 to 100, then if row 50 is deleted, then 51 to 100 to be renumbered 50 to 99. So...