I have written a code in JAVA to search files from the system.User specifies the filename and extension on text input on applet window and on button click code establishes a connection to oracle database and searches the directory name from the database table.The code for searching works fine without applet and on using applet it detects...
Hi, I am trying to use DWR in Oracle BPM. I am new to Oracle BPM and would like to know where I need to put the classes, dwr.xml files etc. Any help is appreciated. An example would really help. Thank you in advance! OBPM NewBie ...
I am using dbms_metadata.get_ddl function. I extract ddl of package and package body seperate and use them separately, so i dont need PACKAGE BODY's ddl when i ask for PACKAGE ddl. However get_ddl('PACKAGE',some_package) returns PACKAGE and PACKAGE BODY's ddls together. Is there a parameter to set, or anything else to make this possible....
I've got a string containing an SQL statement. I want to find out whether the query will modify data or database structure, or if it will only read data. Is there some way to do this? More info: In our application we need to let the users enter SQL-queries, mainly as part of the applications report system. These SQL queries should be al...
I'm looking for oracle admin tool like SQL Buddy (here). I just want to use the browser to test my querys. ...
Hi All, I am trying to run this code below using Execute Immediate but its not working and values are correct. Please suggest the correct code. declare v_count number:=1; v_conc_name varchar2(400); v_val VARCHAR2(20):='vineet'; BEGIN v_conc_name:='INT_AP_PAY_CONV'; EXECUTE IMMEDIATE 'UPDATE xxx_cnc_prg_details SET ...
Hello, We have a Oracle 9i Database with 7 tables each with 15+ Million records. There is no relation between the table i.e. no foreign keys. Here is an example of one of the tables CREATE TABLE GSS.SHOWPD ( INSERVID VARCHAR2(7 CHAR) NOT NULL, CAGEPOS VARCHAR2(8 CHAR) DEFAULT NULL, DETA...
As the title suggests, I would like to know if it is possible to join the string in a select statement within a PL/SQL procedure. For example, I have something like this SELECT FCS.CATEGORY, FCS.NUMBERS, FCS.POINTS WHERE FCS.OBJECT = 'T' AND FCS.THIS_DB & strSelectedDB & So, is it possible to do something like...
How to use array( Varray) in store procedure. Actually,i have make a stored procedure from which i retrieve a list of elements. For example: create or replace procedure GetTargetFields ( fileformat in varchar2, filefields out Vrray(4) ) IS BEGIN SELECT id INTO filefields FROM ...
I'm trying to write a query that brings back patients who have had an office visit at least a year before the most recent one. The various ways I'm thinking of get all twisted up in my head, so I was wondering if anyone out there can see an obvious way to write it that I'm missing. Don't worry too much about the exact syntax and naming -...
Hi, I am trying to run a stored procedure that has multiple in and out paramaters. The procedure can only be viewed in my Connections panel by navigating Other Users | | Packages | | If I right click , the menu items are "Order Members By..." and "Create Unit Test" (greyed out). The ability to "Run" the procedure does not seem possi...
Apple "deprecated" Java and will stop supporting it in the future. Assuming that Oracle will take over support for Java on the Mac, is there a way to be sure that Apple-specific hacks like those "put the menubar at the top of the screen" or "use the native theme by default" will be supported the same way on other JREs/JVMs targeting Ap...
Imagine you have the following table (note: this is a contrived/simplified example): CREATE TABLE foo ( book_id number, page number, -- [a bunch of other columns describing a single page in a book] ); ALTER TABLE foo ADD (CONSTRAINT foo_pk PRIMARY KEY(book_id, page)); While (book_id, page) pairs are unique, the same page nu...
I am writing a query to find employees who earn greater than the average salary within their department. I need to display the employee ID, salary, department id, and average salary of that department. I have a query that just almost works but it keeps giving me "ORA-00904: "AVG_SAL": invalid identifier" errors. Am I doing this correctl...
I never seen this, but is it possible to have one SQL call join data from Oracle and SQl Server? ...
Hi, I've a .Net 3.5 windows application.One of the modules uses a Oracle stored proc which returns a recordset to the C# client. I just want to know which one is a better approach among the following two[wrt. code-readability and performance.]: 1.If I write a multiple CASE statement in the stored proc(SP) itself, then the recordset co...
Hi ALL these day i really stress because of oracle server, im quite new to oracle. i have one old windows 2003 server which installed oracle 10.2.0 version. and i want to full backup of this oracle then want to install same database to another new windows 2003 server ,this windows 2003 server is all different server, computer name...
Hi! While exploring my database in Netbeans I could only see Tables, Views and Procedures in schema tree. So these are the only types of objects that it could explore? What about Java sources and java classes at least? ...
I need to generate a txt from oracle and put it into a ftp server, I already make the st for build de file but is it possible to transfer it to a ftp directly from the SP??? Thanks. ...
I would like to write a PLSQL function that returns true if the domain name I pass is valid. I should use regular expression, but I don't know how to do this. declare ignore boolean; begin isDomainSyntaxOk('www.laclasse.com'); --> should return true. isDomainSyntaxOk('www.la classe.com'); --> should return false because ...