Hi!,
Good Day! is there anyone here who can help me and explain to me why
when i want to click the "Copy To File" in oracle user interface form
it is "Disabled".

I want to code a timer in a proc.
We a running under Oracle 8.1.7 and the function DBMS_ALERT doesn't
exists in 8.1.7.
Is there a way to achieve this?

Suppose i am having two tables say:
t_try1:column name EmpName,Empid(PK),tid
t_try2:column name Tname,Empid(FK),tid
in t_try1 there are non-null values..

I know in Oracle forms there is a way to keep information in a memory table
through record structures that you can then traverse record by record.
Is that an Oracle form-specific ability or can that also be done in an
Oracle PL/SQL procedure?  If it can be done, then how would a ...

I need to obtain the server current timestamp. I know that some selects
like "SELECT  CURRENT_TIMESTAMP FROM dual;" gives the current
timestamp, but with a non standard format (10-Sep-05 10.58.24.853421 PM
-07:00) . I need a timestamp on numeric format type, like this

i have a test table with many diff columns.Im using oracle 9i
i gna jus name  3 columns  Name, Start_time, Identifier
example of data:
NAME               START_TIME              IDENTIFIER

I want to know is there any way that when I insert null or zero as id,
it will not check the foreign key constraint, and will check only for
non-zero and non-null values.
For example when I insert saleamanID in customer table as null or zero

Orace 9i, HP UNX 11i
I have gotten an explian plan  using v$sql_plan  using
dbms_xplan.display table function (I also tried set autotrace on woith
same results..).

Hi NG,
ich habe folgende Frage. Wie kann ich es erreichen, dass ich mit einem Linux
(Suse 9.1) Rechner auf eine externe Oracle-Datenbank zugreifen kann? Das
müsste doch irgendwie gehen! Hat jemand eine Idee oder sowas schon

I have made a test installation of an Oracle 10g database on a host, that I
want to give a new host name and IP number.
I am new to Oracle and can not figure out what to change to make the
database accessible after the renaming. Any hints on how to proceed - e.g.

Suppose i am having two tables say:
t_try1:column name EmpName,Empid(PK),tid
t_try2:column name Tname,Empid(FK),tid
in t_try1 there are non-null values..

I have one question about pagination of oracle.
The following is the example from asktom site.
  select p.*, rownum rnum
          from (select * from big_table order by id) p

When I try to put a JOB interval in Oracle I have an error ORA-06512.
I'd like to put an interval once a week (saturday).  I try with this
command but it dosen't work.

I'm playing around with trying to use the JDeveloper editor to write PL/SQL
code that I'd like to put into either a package or library for use with my
Oracle Forms.
In a properties setting I was able to add all the available Oracle libraries

I have a table "result" with 5M records.  I am doing this query:
select distinct project
from result order by project;
It returns 50 distinct projects in order.  The problem is this query