Can anybody explain me these classes and methods? DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); conn = java.sql.DriverManager.getConnection( "jdb:ocracle:thin:username/[email protected]:1234:dbSID"); Thanks ...
Hey, i'm trying to delete an entity of the following structure from an Oracle 10g tables: class Record { string id; string name; DateTime dateTime; } with the following mapping: <class name="Records" table="RECS"> <composite-id> <key-property name="P_ID" /> <key-property name="NAME" /> </id> <property n...
What cons of Oracle can you find? ...
HI ALL: I am trying to make an object oriented data base and I have the types : client is the base object(class) player is under it and captain is under player and i need a a table to store data how can i make a table of client so i can store all these types in it and who can i insert into it and select please give example if you can tha...
Hi, I've been searching the web for two days and still cannot find a way to generate DDL code with public synonyms. Would be very grateful for an advice. ...
Why can't we use :new and :old columns in a statement level trigger? ...
What does Oracle mean by "statement level atomicity"? ...
In dot net i can use dll file so that my code is safe from others. But is there any ways so that none can see the code of some of my procedures and triggers ... ...
On my website I have a .php script to which our customers can post orders. $destname = CreateUniqueOrderFileName(); if (is_uploaded_file($_FILES['file']['tmp_name'])) { if (move_uploaded_file($_FILES['file']['tmp_name'], $destname)) echo "OK"; else echo "ERROR: move"; } So for my ...
Greetings, I am having problems with a line of code. I am trying to create a count function for a view that I created. I have done this a bunch of different ways but below is the format that I have most recently used. CREATE VIEW ERP_REPORT(EVENTNAME, DESCRIPTION, COUNT(RIDERS) AS SELECT EVENTNAME, RACES.DESCRIPTION, RIDERS_F...
I'd like to do the following in Oracle 10g (this is a contrived example to show the concepts, not real code) create table orders (order_id NUMBER); insert into table orders values (1); insert into table orders values (2); insert into table orders values (3); TYPE NUMBER_ARRAY_T is TABLE of NUMBER; PROCEDURE VALIDATE_O...
Hello, I have code snippet in my PL/SQL procedure that does the following: INSERT INTO payment_operations (id, subscriber, amount, description) VALUES (payment_id, 1234, 5, 'Test'); COMMIT; SELECT subscriber INTO test_subscriber FROM payment_operations_view WHERE id = payment_id; After this I get an exception "no_data_found"! Howeve...
I have the following table in an Oracle database: InvoiceNumber InvoiceDate InvoiceCorrelative ------------- ----------- ------------------ 123 02-03-2009 0 124 02-03-2009 0 125 02-04-2009 0 126 02-04-2009 0 127 02-...
I've defined VARRAY of a user-defined type such as this : CREATE OR REPLACE TYPE TEST_T AS OBJECT (C1 VARCHAR2(20 BYTE), C2 VARCHAR2 (11 Byte)); CREATE OR REPLACE TYPE ARRAY_TEST_T AS VARRAY(200) OF TEST_T; Is it possible to create a java stored function/procedure that accepts VARRAY or user-defined type as IN parameter ? If it...
I have two select statements joined by "union". While executing that statement I've got: Error report: SQL Error: ORA-01790: expression must have same datatype as corresponding expression 01790. 00000 - "expression must have same datatype as corresponding expression" Maybe you can give me an advise on how to diagnose this problem? ...
Here's a simplified example of what I'm talking about: Table: students exam_results _____________ ____________________________________ | id | name | | id | student_id | score | date | |----+------| |----+------------+-------+--------| | 1 | Jim | | 1 | 1 | 73 | 8/1/09 | | 2 | Joe | ...
I'm trying to randomly select a card from a table of cards with columns c_value and c_suit using a procedure. After selecting it, the procedure should update that entry's taken field to be 'Y'. create or replace procedure j_prc_sel_card(p_value OUT number, p_suit OUT number) AS CURSOR CUR_...
Hi guys, In coldfusion, how can I send an anonymous block to oracle and get some response from oracle? I tried cfquery, but it doesn't work. Great thanks. @Antony, I know i can write anonymous block in cfquery. Such as: <cfquery name="queryName" datasource="oracle11ghr" result="queryName_meta"> BEGIN INSERT INTO npr_t_reservation...
If I have an table create table sv ( id integer, data text ) and an index: create index myindex_idx on sv (id,text) would this still be usefull if I did a query select * from sv where id = 10 My reason for asking is that i'm looking through a set of tables with out any indexes, and seeing different combinations of select queries...
Can anybody suggest, whether we should use commit after opening and before closing cursor? ...