Hi all, I am not sure If I'm correct in posting in this forum but I need info. I am doing University project which needs couple of oracle database server which are online. I have a cloud application which would access this servers. I tried to find online if I could rent database servers for a week for the test with no luck. Could somebo...
What are the differences between LOG_CHECKPOINT_INTERVAL and LOG_CHECKPOINT_TIMEOUT? I need a clear picture of volume based intervals and time based interval. What are the relations among LOG_CHECKPOINT_TIMEOUT,LOG_CHECKPOINT_INTERVAL and FAST_START_IO_TARGET? ...
This answer on a question on SO says ... you can read a LONG from a remote database, but you can't read a CLOB I did not find anything about this on the internet, is it true? Any documentation or citings for this will be helpful. ...
Possible Duplicate: Prevent scientific notation in ostream when using << with double I get 1e-1 as result after a computation how can I convert the result from exponent to dot notation i.e., 0.1 ? Why is it automatically converted to exponential notation!! ...
I am trying to use PL/JSON in my Oracle APEX application but get the following errors when I attempt to run a Hello, world example (which works fine when I run the example from SQL*PLUS as sys): ORA-06550: line 2, column 20: PLS-00905: object MY_SCHEMA.JSON is invalid ORA-06550: line 2, column 20: PL/SQL: Item ignored ORA-06550: line 5,...
Hi Folks! Greetings to all! I want to create a pl/sql query by declaring variables for the following eg: :stay_id = (SELECT Stay_Id from MVStay where StayNumber = 'xxxx' AND StayState = 2); -- get passage linked to the stay and is 'discharged' :passage_id = (SELECT Passage_Id from MVStayWorkflow where Stay_Id = :stay_id and WorkflowActi...
using pl/sql how do I open a directory? ...
Using pl/sql how do I locate a file in a directory and move the file? ...
Possible Duplicate: Using pl/sql how do I locate a file in a directory and move the file? How do I locate a file in a directory using PL/SQL? ...
From these two threads, Why is LONG an issue with Oracle? Is it possible to read a CLOB from a remote Oracle database? LONG is archaic and deprecated. Oracle says, Do not create tables with LONG columns. Use LOB columns (CLOB, NCLOB) instead. LONG columns are supported only for backward compatibility. Oracle also recommends ...
Hello, We are planning a migration of an Oracle installation from Solaris to Linux. At the same time we will upgrade to latest version of Oracle. There are a few hundred stored procedures that should be migrated as well. Present version is Oracle SE 9.2. We will still use Oracle SE, potentially with RAC. Is there anything that we mu...
i have a PL/SQL procedure using MERGE : MERGE INTO table_dest d USING (SELECT * FROM my_Table) s ON (s.id = d.id) when matched then UPDATE set d.col1 = s.col1 when not matched then INSERT (id, col1) values (s.id, s.col1); now lets say the query s returns mutiple rows with same id wich will returns an ORA-00001: unique const...
e.g. I have a table: create table test (testdata varchar2(255)); then I need an autoincrement field: alter table test add id numeric(10); create sequence test_seq start with 1 increment by 1 nomaxvalue; create trigger test_trigger before insert on test for each row begin select test_seq.nextval into :new.id from dual; end; wh...
I would need to connection to Oracle database via connection pool. Please correct me IF I am wrong that I only need to modify/add the datasources in data-sources.xml. Thanks. ...
I have to migrate data from one database to another. As preparation we have already extracted CLOB and BLOB data into separate files located on the Oracle server. The database contains several CLOB and BLOB columns in different tables that have been initialized with NULL values for all those rows. How can I load the content of a file in...
Hi all, I'm interested in whether a select for update query will lock a non-existent row. e.g. Table FooBar with two columns, foo and bar, foo has a unique index Issue query select bar from FooBar where foo = ? for update If query returns zero rows Issue query insert into FooBar (foo, bar) values (?, ?) Now is it possible that t...
As ColdFusion datasource we are using the Oracle thin client to connect with the database. So, basically we are using a JDBC URL such as jdbc:oracle:thin:@... and as Driver Class oracle.jdbc.OracleDriver This works successfully however we would like to set encryption and integrity parameters as well. In Java this is done similarly by s...
---------- User ---------- user_ID(pk) UserEmail ---------- Project_Account ---------- actno actname projno projname ProjEmpID ProjEmpMGRID Where ProjEmpID,ProjEmpMGRID is the user_id and ProjEmpMGRID can be null. I need to look up the useremail and display the table project_account. I need to query with actNo which has duplicate valu...
Hello, am a newbie to Oracle/PL SQL.I've 2 tables A and B. A has a column CustId,Age,Location and Date. Table B has 2 columns CustId,CustName. What would be the sql query to show show CustName and Location for a given age? Thanks. ...
Hi, I have 2 tables T_Foo foo_id fooHeader T_FooBodys foo_id foobody foo_id are primary key for both of their respective tables. In second table, foo_id is foreign key to first table. I generate the PK for both table values using a sequence and try to make insert - once into FooHeader and twice into FooBody. MY code crashes on the ...