Search results for query: *

So it's a db version issue. Thanks Dima.

I want to create a case-insensitive index. I found an exemple on the net, but this doesn't seem to work. Here's my case: SQL> create table books (title varchar2(10),price number(2)); Table created. SQL> desc books Name Null? Type...

Metalink is at: http://www.metalink.oracle.com/ , but you have to register. There is a wealth of Oracle articles, documents there. Regarding my initial question, I have read several articles, FAQs etc but have not found an answer. I use the old-fashioned CONNECT INTERNAL since.

O.k., thanks, we have a new copy now, working fine, so no need for a copy anymore.

Due to 'accident' we lost the file "owsctl" (Oracle Web Appl Server), version 3.0 for AIX platform, needed for Oracle APPS 11 (not 11i). Can someone please send me this file ? We can't restore it in short term. You can send it to: mockenrue2000@yahoo.com I will update the thread as...

We have custom messages defined in Oracle APPS 11. Each message is defined in 2 languages: US and D. After generating the message files US.msb and D.msb we want to upload the D messages on another server using the FNDMDGEN utility with the RUNTIME_TO_DB option and the correct D parameter...

It can ! User can query :X in this field. A pop-up appears and there you enter -> :X is null.

A-ha, o.k.

Wasn't 32767 the limit for varchar2 fields ?

Yes, that works, thanks. Still don't understand why the row did not show without the NVL.

Problem: Query retrieves one record, but when I use the exact same query as subquery the master query returns no rows. Example with EMP table: ---------------------------- SQL> select e.job 2 , e.mgr 3 , e.sal 4 , e.comm 5 , e.deptno 6 from emp e 7...

Thanks MeyersG. Lots of documents, I'll better start browsing !

Thanks Alex.

Does anyone know some good articles on deadlocks (not wait locks) in Oracle on the web ? DBA frequently reports listings like this: >> *** 2003.04.17.09.16.54.000 *** SESSION ID:(354.144) 2001.04.17.09.16.54.000 DEADLOCK DETECTED Current SQL statement for this session: UPDATE ... ----- PL/SQL...

I have successfully installed 8i Personal Edition rel 3 (8.1.7) on a stand-alone Windows98 PC. I can start instance and database, however only when using the INTERNAL login. According to Oracle documentation the preferred login is: connect / as sysdba However doing so results in...

declare e_zero_divide exception; pragma exception_init (e_zero_divide, -1476); begin <your code> exception when e_zero_divide then null; end;

In triggers you must refer to a column like: :new.<column_name> or: :old.<column_name> And you can use 'if inserting' and 'if updating'. So you can construct something like: begin if inserting then if :new.client_book = 'L' then update client set book = ...

Assuming your column is named n_app: create or replace trigger num_val after insert on <TABLE NAME> for each row when new.n_app < 0 declare begin :new.n_app := abs(:new.n_app); end;

Try this: select decode ( sign ( PRICE - 1000 ) , -1 , 3103 , 0 , 3103 , 5005 ) NEW_CODE from <your table>

Thanks for your suggestions. I've tried Dima's approach combined with a library variable and that seems to suit most of the cases. I'll see whether BJCooper's relation can be established without post-gen. Thanks again, Arthur