i was trying to prepare a primary database for standby database creation. while executing set_log_params.sql, we struck with an error \"ORA-32017 failure in updating SPFILE\" and \"ORA-00439 feature
I have created a sequence starting with 1 with no max value I have created a trigger for primary key insertion automatically which is below
SELECT * FROM ( SELECT city from addr_tab UNION ALL SELECT \'zzzz\' AS city from dual )ORDER BY city I am using the above approach to retrieve the \'zzzz\' as last record of the table. But I don\'t
I want to add two columns to all my t开发者_如何学Pythonables [Create Time] & [Modify Time] to capture audit trail .In the future these fields might be used in partitioning the table. Please sugge
Below is the code i use to extract data from a table to a flat file. BEGIN DECLARE file_name VARCHAR2(50);
This is a never-ending topic for me and I\'m wondering if I might be overlooking something. Essentially I use two types of SQL statements in an application:
how can I create ref curser with parameters and return this cursor from plsql function? I tried to write something like this code..
I have an MVIEW on the DEV server as CREATE MATERIALIZED VIEW MY_MVIEW AS SELECTcol1 AS \"N° INVOICE\" from TABLE
create or开发者_高级运维 replace trigger insert_catid beforeinsert or update or delete on categories
I have a oracle database table. When a row is inserted then I want to create a trigger. Till now the problem is ok,but after creating trigger I want to call weblogic application server code(means I wa
加载中,请稍侯......