I've got an Oracle 10g database which is accessed from an ASP.NET application. Although I've used SQL Server heavily in many different aspects and Oracle for querying and reporting, this is my first time using Oracle as the OLTP database for an application. The database-level procedures in the packages are typically of the form: -- TY...
This question refers to the dequeueing of messages in Oracle Streams Advanced Queueing. I need to ensure that the messages which are related to each other are processed sequentially. For example, assume the queue is seeded with the four messages that have a business-related field called transaction reference (txn_ref) and two of the ...
I tried the solution given in "mysql SELECT COUNT(*) … GROUP BY … not returning rows where the count is zero" but it didn't work for me. Here is SQL :: SELECT empid, SUM (total_records) total_records FROM (SELECT ID, (CASE WHEN ID LIKE '2%' THEN '2____' WHEN ID LIKE '3%' THEN '3____' ...
With SQL Plus for Oracle Database, I can call SET autotrace on and then see Execution Plan, statistics, etc. The problem is that I want access to information about the Execution Plan and statistics in my Java program. I typically have done something like this to execute a sql statement, Connection connection = //INITIALIZE HERE; St...
How do you work with the oracle XML data type? This question is intended to be asked and answered by me, just to share the information with others ...
how to resolve OCI-04030 ? OS : window 7 32-bit web server : tomcat 6.0 ...
Hi, I've got some help turning my table of the sort: Col 23 25 15 53 ... into something like 23,25,15,53... The query that does it is SELECT max(ltrim(sys_connect_by_path(flow_run_id, ','), ',')) FROM (select flow_run_id, rownum rn from table where CREATED_DATE < sysdate - 32 and flow_id = 3 order by 1 desc) STA...
Hi all, This one has me rather confused. I've written a query which runs fine from my development client but fails on the production client with error "ORA-01652: unable to extend temp segment by....". In both instances, the database and user is the same. On my development machine (MS Windows) I've got SQL*PLUS (Release 9.0.1.4.0) and T...
Hi, I'm trying to create a binary with py2exe, here are last lines of py2exe output: *** copy dlls *** copying C:\Apps\Python27\python27.dll -> C:\Documents and Settings\nikolay.derka ch\Desktop\UMTScellsChecking\UMTScellsChecking\dist setting sys.winver for 'C:\Documents and Settings\nikolay.derkach\Desktop\UMTSce llsChecking\UMTScell...
I found this paragraph in Oracle documentation if you want to select the name of each department along with the name of its manager, you can write the query in one of two ways. In the first example which follows, the hint /++ordered++/ says to do the join in the order the tables appear in the FROM clause with attempting...
Oracle supports a query syntax where a table is joined to an Oracle collection type (Nested table or VARRAY). This semantic can be used instead of the in (1,2,3) syntax in SQL, and allows an array of values to be bound to the query. This can be done using Oracle's JDBC driver. This type of query is known as a Pickler Fetch. It is much m...
Slightly broad question here, but here goes I'm trying to call an Oracle stored procedure, which returns a VARRAY which is of constructed from a ROWTYPE on one of my tables. For simplicity, lets say this table looks like the following : MY_TABLE ID VALUE ----------- 1 John 2 Dave so I will call a SP that returns the followin...
How to convert number 1.33408564814814 to time 32:01:05? ...
Hi. I am using Oracle 10g. and I have the following relational structure that I think I need to flatten out so on the client side a grid view shows the correct number of columns. TableA below can be configured to have any one of it's records enabled or disabled using the enabled field. TableB stores calculated values related to TableA ...
yep, it sounds like an unholy alliance but I need to configure how to do it... for starters I have on my PC installed Oracles PL/SQL environment, with latest client (11g, I think) ... I can work in theirs IDE w/o any problems. I even can code desktop apps with C# and Oracle connector (etc.) Now, from MS site I can click on that Web Inst...
I have two similar tables in oracle in two different databases. For example : my table name is EMPLOYEE and primary key is employee id. The same table with same columns(say 50 columns are is avlbl in two databases and two databases are linked. I want to compare these two tables column by column and find out which records are not matchi...
Question Example Table +-------------+----------------------+--------+ | category_id | name | parent | +-------------+----------------------+--------+ | 1 | ELECTRONICS | NULL | | 2 | TELEVISIONS | 1 | | 3 | TUBE | 2 | | 4 | LCD ...
Can someone please explain to me why I keep getting this PLS-00905 error for the below simple procedure? Thank you. create or replace procedure copy_table( table_name IN varchar2, database_link IN varchar2, suffix IN varchar2, table_owner IN varchar2) IS begin execute immediate 'create table ' || table_name || '_'...
Just more a general question I can't seem to find a definite answer on. But what is a good SQL wrapper for C++ that allows me to call queries? I'm used to Oracle, but i've used MYSQL before aswell. And how would you call something such as an insert statement (for example) in one? ...
i need to accept only Y/N for is_master variable declare below. For example if i use the below statement in SQL script the user can enter any character. I want to restrict user to enter only y Y n or N Accept is_master prompt ' Is the user a Master user (Y/N) : ' ...