I'm using Oracle as my database, and Dreamweaver to create the input forms.
I need to be able to pass a value that is created automaticlly by the
database via the use of a trigger. Everything works fine when the first user
inputs his/her data, but then I get an error message ...

I'm trying to work on a form (Forms 6i, Oracle DB 9i on Windows XP Pro)
which has three tab pages on it.  Two are database blocks and the third
isn't.
The tab pages are, in order of display on the form:

i would like to ask you for an advice. i want to install Oracle at
home, so that i could test it and learn a bit about its admnistration i
run Debian Sarge at home but it seems it would quite a big challange
(at least for me) to install Oracle on it. What linux distro would you

Hi faculties,
   I perform an export of a schema from one DB to another one. Is it
necessary to do some post maintainence tasks after the import is over?
By tasks i mean tasks like index reorganization.

I'm using Oracle as my database, and Dreamweaver to create the input forms.
I need to be able to pass a value that is created automaticlly by the
database via the use of a trigger. Everything works fine when the first user
inputs his/her data, but then I get an error message ...

I am tryiing to get data into a temp table from 3 odd master tables
referencing a stored procedure to insert values via triggers. But I am
unable to populate data in the temp table? Does anyone have any
suggestion?

Optimizes Performance Across All Oracle Products, Including Oracle
Database, Oracle Fusion Middleware and Oracle Applications
http://technology-post.com/tech/index.php/oracle-performance-group-leverages-mer
cury-application-delivery-offerings/

I'm using Oracle as my database, and Dreamweaver to create the input forms.
I need to be able to pass a value that is created automaticlly by the
database via the use of a trigger. Everything works fine when the first user
inputs his/her data, but then I get an error message ...

Hi Gurus,
I have cloned oracle10g database by manual method.
Steps
1. edit trace file (save clone.sql)

hi friends,
i am working as oracle DBA. i want a solution to the problem.
i want to revoke the export and import utility from a user.
anyone please explain the steps of what to do for this.

Is it possible in Oracle to create 2 (or more) functions with the same name,
but with differents arguments?
Thanks
Roberto Nenni

I'm trying to resolve a problem. I currently have a java application
utilising an oracle instance called orany1. The developers made the
mistake of hard-coding all the sql references to the tables with the
instance name i. table_name@orany1. The application connects to the

I am using the following sql query which I feel could be simplified,
but I don't know how. For t1, fields (project + year) form the Pr Key.
select t1.location from t1 aa, t2 t2
 where aa.project = t2.project and aa.year = t2.year and aa.month =

I have table  Dept.
   i want a temporary of structure same as Dept., so that temporary
table can hold some records from dept. How to do this in oracle

*****Oracle*******
I am selecting distinct records from a table, but table has one column
whose datatype is CLOB, so i got errors in select.
does anybody have solution over it.