Oracle Help

Inserting rows in SQL Developer
When I insert some new rows in SQL Developer's data grid (or I edit existing fields), there doesn't seem to be any way of submitting changes except doing a COMMIT. Is is possible to edit data as you do in TOAD with the autocommit option disabled? That is: 1. Edit data in the grid 2. Play with it, possibly ... 4 Sep 2008 07:50

view fmx file
hello, sorry for the question can i view the content of a form fmx file ? not need the code, only the view. thank's for all ask! ... 4 Sep 2008 06:49

date, select // count per 10 minutes
for statistics i need to select the number of orders per 10 minutes. So i want to do something like SELECT TRUNC(insert_date, '??'), COUNT(*) FROM orders .... ; But within the trunc-(or other data-based) function allowed Patterns are "HH" or "MI". as workaround i use: SELECT TRUNC(insert_date,'HH'... 3 Sep 2008 12:20

Using the zip/unzip command given with Oracle in Unix, without directory names
On Tue, 2 Sep 2008 02:19:10 -0700 (PDT), compuneo <compuneo(a)gmail.com> wrote: Hi, I am trying to compress using the zip/unzip command given with Oracle in Unix. The objective is to create a zip file, for e.g. for the following, from any directory other than tt, without the directory name. tt/f1.... 2 Sep 2008 06:33

Using the zip/unzip command given with Oracle in Unix, without directory names
Hi, I am trying to compress using the zip/unzip command given with Oracle in Unix. The objective is to create a zip file, for e.g. for the following, from any directory other than tt, without the directory name. tt/f1.txt tt/f2.txt into tt.zip. Say I'm using this command: zip -r tt.zip tt/ In other w... 2 Sep 2008 08:36

how to execute a package in my schema context
Hi, I've written a package that works with a special set of tables I'm using in different schemas (i.e. MY_WORK). Now I'd like to create it in a special schema (i.e. SERVICE) to avoid the redundance. But executing it in MY_WORK it tries to modify the tables in SERVICE. It is so by design, I understand it. Norm... 1 Sep 2008 02:54

Can we write trigger on Oracle Database level for abnormal loss of connection to database?
On Fri, 29 Aug 2008 06:53:58 -0700 (PDT), shilpa <shilpa.uttarwar(a)gmail.com> wrote: ORACLE: I want a trigger to get fired when my application's connection to the database gets disconnected abnormally. I plan to monitor the Server Name and its status in the “ v$session“ table. Can I write a trig... 29 Aug 2008 11:38

Can we write trigger on Oracle Database level for abnormal lossof connection to database?
shilpa wrote: ORACLE: I want a trigger to get fired when my application�s connection to the database gets disconnected abnormally. I plan to monitor the Server Name and its status in the � v$session� table. Can I write a trigger that gets fired when � v$session� table gets edited? How ... 29 Aug 2008 10:37

Can we write trigger on Oracle Database level for abnormal loss of connection to database?
ORACLE: I want a trigger to get fired when my application’s connection to the database gets disconnected abnormally. I plan to monitor the Server Name and its status in the “ v$session“ table. Can I write a trigger that gets fired when “ v$session“ table gets edited? How can I achieve it? Is there any o... 29 Aug 2008 10:37

Refresh Schema - Table Data Only
10gR2 I want to refresh a shema - data only If I'm to use expdp to export "scott" from Production and use impdp to import to "scott" on Test.... What is the best approach on the import ? 1) Should I drop all tables under "scott" ? or truncate them ? 2) What about existing table constraints/Ref. Integrities.... 28 Aug 2008 18:17