I\'m using table with a counter to ensure unique id\'s on a child element. I know it is usually better to use a sequence, but I can\'t use it because I have a lot of counters (a customer can create a
In Oracle I\'ve created a data type: TABLE of VARCHAR2(200) I want to have a variable of this type within a Stored Procedure (defined locally, not as an actual table in the DB) and fill it with dat
I writing an application using Oracle 10g. I am currently facing this problem. I take in \"filename\" as parameter of type varchar2.
refer to these post : here1 and here2 at last I solve my problem by build a asynchronous solution,and it work well!!! but there is a problem that i face with it,now my code is like this:
I don\'t know how I can return all attributes with the RETURNING clause I want something like this: DECLARE
This question already has answers here: Closed 12 years ago. Possible Duplicate: ‘CONTINUE’ keyword in Oracle 10g PL/SQL
In the JDBC code, I have the following that is working with SQL Server: CallableStatement stmt = connection.prepareCall(\"{ call getName() }\");
I need to find out the number o开发者_如何学编程f rows affected by a rollback. How can I get this ? Please help.Consider a table fred with two columns (id, value) with two rows.
I have stored-procedure in Oracle database like this: create or replace PRO开发者_开发百科CEDURE EDYTUJ_PRACOWNIKA
I have to make a process in Oracle/PLSQL. I have to verify that the interval of time between start_date and end_date from a new row that I create must not intersect other start_dates and end_dates fro
加载中,请稍侯......