Given the following indexes for an Oracle database: CREATE INDEX subject_x1 ON subject (code); CREATE INDEX subject_x2 ON subject (code, status); Is it true that the first index is redundant, and can be removed. We need to get this right as this is a relatively large sized table that is going to be constantly hammered. Any oracle doc...
i have the following function: create or replace FUNCTION "MXUPGKEYVAL"(tbname varchar2,colname varchar2) return number is val number; BEGIN EXECUTE IMMEDIATE 'select sum(length('||colname||')) from '||tbname into val; return val; END; and the following update: update ANINTEGDATA set val1=to_char(nvl(MXUPGKEYVAL(MX5T,MX5C),0)) whe...
how can i convert rows in to columns in oracle 10g( like pivot in oracle 11g),so that i can add multiple 'and' conditions for the primary key. ex: select emp_name from emp where empid = 1 and emp_age = 21; where empid = 12 and emp_age = 23; without using 'in' ,i have to get records which satisfies all the above condtions(Like 'and ' ...
hi all, i have written a java code..using which i can insert images to my oracle data base blob data type and to retrieve from it. it's working perfectly on other systems ..but not working in my system when i want to insert an image having size more than 2kb.but from my system i m able to retrieve images of any size.. the same applicati...
Hi, I have the following queries on fetching a BLOB data from Oracle ( I am trying to use OracleDataReader - .Net to read the BLOB value.): Is it possible to read a BLOB data on Oracle database as chunks without loading the entire BLOB on to server memory? I believe OracleDataReader.GetBytes() will load the entire blob on server memory....
I have a really big table with dozens of columns and lots of rows. Lets call this table FT. Everyday I run a script that reads data from the FT table, perform some calculations, and update a smaller table (table FA) that I use to generate reports. The query that update FA is something like: INSERT INTO FA (A, B, C) (SELECT sum(X),...
I have a Java program that creates a number of xml file and then zips them up and saves them to the file system. Later in the program I want to put that same zip file into a blob column of my oracle database. Problem is I'm not sure how to do that. I don't need to read it or do anything with the data, just move it to the database for p...
I have added my Oracle JDBC driver to my Maven repository and everything is working fine however I am still receiving warnings whenever I package my project. E.g. [INFO] Unable to find resource 'com.oracle:ojdbc14:pom:10.2.0' in repository central (http://repo1.maven.org/maven2) How can I stop those warnings from showing up? ...
Hi, What is the difference in the load balancing capabilities of Apache's mod_jk and Oracle's Oracle WebCache ? If my application doesn't have any need for caching (hence no use of caching features of Oracle WebCache), then how do they both rate ? The obvious thing is cost. mod_jk is open source while WebCache isn't. Apart from this, how...
I've recently started working in ASP.NET and RDBMS.I'm making a test form where I can do basic add,update,delete operations.I'm using OracleDataClient to do the DB operations.I was able to populate a listbox using OracleDataAdapter. Now after clicking on update button,I intend to Update in DB.I've Dataadapter with it's update property.Bu...
I see this in the Debian folder hierarchy after installing Zend Framework. /oradiag_root/ /user/myuser/oradiag_myuser/ /user/myuser/oradiag_root/ This name reminds me Oracle. But I did not find official documentation about this. I didn't install any Oracle server. The folders are doubted. ...
I have already installed oracle xe 10g, apache, php in ubuntu by following the ebook Underground Oracle-PHP-manual. But when i run some file connection oracle-PHP using oci_connect() show error : Warning: oci_connect() [function.oci-connect]: OCIEnvNlsCreate() failed. There is something wrong with your system - please check that ORAC...
Hi folks, I'm sending a value from my front-end (Flex) to the back end (Oracle) along with a hash on the value. From my front-end, I'm using the as3corelib library from Google Code to compute a HMAC hash value using the SHA1 algorithm: com.adobe.crypto.HMAC.hash(mySecret, myMessage, com.adobe.crypto.SHA1); At the back-end, I'm using...
If i have a table and a defined policy on it then do I need to redefine the policy if I drop and recreate the table or alter it, provided that the alteration or the recreation of the table does not alter elements that the function needs to see? ...
What if I do not Explicitly close the sys_refcursor in oracle? will it give a open cursor issue, and results in slow speed of application?? ...
How can I access Oracle from Python? I have downloaded a cx_Oracle mis but Python can't import the library. I get the following error import cx_Oracle Traceback (most recent call last): File "", line 1, in import cx_Oracle ImportError: DLL load failed: The specified module could not be found. I will be grateful for any help ...
I've worked with some open source databases (mysql, postgres and firebird). They all have small and lean drivers for ado.net and are quite easy to configure. I'm currently working with IBM/DB2 and Oracle. They are hard to get working and you have to install several megabytes to get a small driver. Why can't they create drivers that are ...
In SQL Server we can type IsNull() to determine if a field is null. Is there an equivalent function in PL/SQL? ...
Hello, I'm using Zend Framework version 1.7.8. I am trying to create a class that extends from Zend_Db_Table_Abstract: class My_Model_Table extends Zend_Db_Table_Abstract { public function __construct($tableName) { parent::__construct(array('name' => $tableName, 'primary' => 'dummy', 'db' => Zend_Registry::get('dbAdapt...
I need the document or form to be automatically updated when the data in the Oracle database is updated. If not possible, could anyone give me guidance to a solution similar to this? Thanks for the help. ...