Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Mockenrue

  1. Mockenrue

    Index using UPPER function

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

    Index using UPPER function

    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...
  3. Mockenrue

    CONNECT / AS SYSDBA on Win98 8i Pers Edition

    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.
  4. Mockenrue

    Need AIX file, please

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

    Need AIX file, please

    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...
  6. Mockenrue

    Messages in other language not uploaded

    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...
  7. Mockenrue

    null query

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

    Converting LONG to VARCHAR2

    A-ha, o.k.
  9. Mockenrue

    Converting LONG to VARCHAR2

    Wasn't 32767 the limit for varchar2 fields ?
  10. Mockenrue

    Subselect question

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

    Subselect question

    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...
  12. Mockenrue

    CONNECT / AS SYSDBA on Win98 8i Pers Edition

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

    Articles on deadlock ?

    Thanks Alex.
  14. Mockenrue

    Articles on deadlock ?

    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...
  15. Mockenrue

    CONNECT / AS SYSDBA on Win98 8i Pers Edition

    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...
See more

Part and Inventory Search

Back
Top