Friends, I'm facing another challenge in APEX and I hope you can help. I have created a tree using the method described in John & Scott's superb book, "Pro Application Express" whereby the page link is stored in a table. Below is an example: go to a page passing some parameters f?p=&APP_ID.:3:&SESSION.::::P3_IDENTIFIER,P3_FAMILY_NA...
Hi. I am having problem with importing csv files containing values in japanese characters. When I do so it will display garbage when I query. my OS is japanese. My encoding for oracle NLS_LANG is JAPANESE_JAPAN.JA16SJISTILDE. I don't know what the problem is. When I try to import the very same file in some of my office mates' PC it just ...
Hi guys, I have the following situation: I have a java code launching a stored procedure. What I want is to launch the java code, and when arriving into the stored procedure, to start debuggin it using Toad. Is this possible? Thanks alot. Best regards, Corneliu ...
Hi, I have a procedure that returns an OUT parameter. procedure foo (in_v IN INTEGER, out_v OUT integer) BEGIN ... EXCEPTION WHEN OTHERS THEN --sh*t happend out_v := SQLCODE; END That parameter will be 0 if everything goes OK, and <> 0 if something ugly happened. Now, if sh*t happens along the way, an exception will be th...
Hi, What is the latest version of JDeveloper which supports Oracle UIX development? Not a version which supports migration, but one which actually still has UIX development tools integrated? Thanks! ...
Hello, I am trying to make an inner join on a select statement like this: select * from (select* from bars where rownum <= 10 )as tab1 inner join (select * from bars where rownum <= 10 )as tab2 on tab1.close=tab2.close and I get the following error: ORA-00933 SQL command not properly ended Any help would be appreciated, thank you! ...
Hello, I am trying to make an inner join on a select statement like this: select * from (select* from bars where rownum <= 10 )as tab1 inner join (select * from bars where rownum <= 10 )as tab2 on tab1.close=tab2.close and I get the following error: ORA-00933 SQL command not properly ended Any help would be appreciated, thank you! ...
How do I select an XML schema previously registered with Oracle? For example, if I've registered a schema like so: DBMS_XMLSCHEMA.registerSchema( SCHEMAURL => 'http://test.com/my-schema.xsd', SCHEMADOC => '...the xsd..., ... ); I would like to be able to get that schema back, ideally something in the vain of: select s.sc...
I have a couple of question's regarding the following project. *Scott, Recently some developers have teamed-up to offer Oracle support (using Oracle's ODP.NET) for Subsonic 3.x, using the T4 Visual Studio template database provider system. Please search Github.com for Oracle/Subsonic, or my link, http://github.com/mabraham1...
Hello, I have a table which has columns of price and date, ordered by the ascending dates. I need to calculate from this a return vector where return = price ( i) / price ( i- 1). The time is not time based, which means that one record can be at 9h34, the next at 9h35, then 9h40 etc... I have found the following topic: SQL Syntax for ca...
Hi, After entering code to create a new table in SQL ORACLE, would the changes be saved if I was to log out of the SQL Session? ...
Hi, I want to declare a cursor on a table that does not exist. Of course, my procedure doesnt compile. This table is a temporary table, and is created by a pre process. It will exist on runtime, but at compile time its another story. For my select / updates an other DML operations, I've used EXECUTE IMMEDIATE 'operation from tmp_tab...
It appears that there is a limit of 1000 arguments in an Oracle SQL. I ran into this when generating queries such as.... select * from orders where user_id IN(large list of ids over 1000) My workaround is to create a temporary table, insert the user ids into that first instead of issuing a query via JDBC that has a giant list of para...
SELECT * FROM (SELECT ROWNUM rnum, query.* FROM (WITH myQuery AS( SELECT column_b FROM table_a a WHERE a.column_a = 1234) SELECT b.column_e AS some_column FROM table_b b, table_c c, table_a a ...
I am trying to understand the performance of a query that I've written in Oracle. At this time I only have access to SQLDeveloper and its execution timer. I can run SHOW PLAN but cannot use the auto trace function. The query that I've written runs in about 1.8 seconds when I press "execute query" (F9) in SQLDeveloper. I know that this i...
please help me connect spatials to oracle 10g XE where can i find fun things to do with oracle spatial? ...
Hi, I need to get value of column (TIMESTAMP) from oracle DB into C++. Then which dataype i should map to access database field (In MFC or WinAPI any) or what should in do to do this in proper manner. Thanks, Anuj Seharavat edit Additional info: I need to fetch data from database. I am using CRecordset class and function RFX_Date i...
I want to use standard authorization with forms. But all tables must be saved not in mdb file which used by default, but in Oracle. Would you please provide me information how to do this? Thanks! ...
Hi, This is a problem that my friend asked over the phone. The C# 3.5 program he has written is filling a Dataset from a Patient Master table which has 350,000 records. It uses the Microsoft ADO.NET driver for Oracle. The ExecuteQuery method takes over 30 seconds to fill the dataset. However, the same query (fetching about 20K records) ...
In our application, there's a database update that is committed only after a consequent update is being executed (both using the same transaction, of course). However, we've discovered a rare flow in which the user exits the application before the second update, causing the first to be discarded. I'm looking for a way to recognize this u...