I have 2 unrelated tables A and B which both have foreign key constraints on C. I need to run an sql query that determines if either A or B contain a given id of C. My first approach was to use the union all but A and B are not related thus it will not work. Any ideas? ...
I'm trying to get the products that havn't been made in the last 2 years. I'm not that great with SQL but here's what i've started with and it doesn't work. Lets say for this example that my schema looks like this prod_id, date_created, num_units_created. I'll take any advice i can get. select id, (select date from table ...
In short. After patch 19 has been installed I can't run any form: compiled with patch 18 or 19, by myself or others. Immediately after starting I get Windows error: -------------------------------- ifrun60.exe .... -------------------------------- The application failed to initialize properly (0xC0000005). ..... ---------------------...
Hi, Is there any way i can convert a table struture in a MySQL or Oracle database to XSD (XML Schema Definition) format ?. Thank You. ...
The following query returns ORA-00904 error: SATIS: Invalid identifier. When I remove the line HAVING satis > 0, it works. What should I do? SELECT donem, bolge_adi, sehir_tasra "1=Ş, 2=T", COUNT(DISTINCT mekankodu) "M.SAYISI", SUM(b2b_dagitim + b2b_transfer - b2b_iade) satis FROM mps_view2 WHERE donem IN ('200612','20071...
I have some configuration information in some tables that need to get dumped to some flat files. What's the best way to detect that the tables have changed? I don't have control of some of these tables, so I would prefer to avoid a trigger if possible. ...
I'm using a C# project that is linked to the OracleDataAccess.dll - V9 or V10, but only one of them at a time. My development machine has both installations. On the deployment machines only one of them is available. For this reason, I have to switch the reference betwenn V9 and V10 in my project dependent on the deployment machine. Is ...
Oracle PL/SQL won't let users to use aliases in conditions. In most cases it's very practical for me to use aliases instead of long statements. What's the reason for that? What bad would happen if we could use aliases in conditions? Example case: http://stackoverflow.com/questions/2235166/whats-wrong-with-this-sql-query ...
CREATE TABLE DMS_POP_WKLY_REFRESH_20100201 NOLOGGING PARALLEL AS SELECT wk.*,bbc.distance_km ,NVL(bbc.tactical_broadband_offer,0) tactical_broadband_offer , sel.tactical_select_executive_flag, sel.agent_name, res.DMS_RESIGN_CAMPAIGN_CODE, pclub.tactical_select_flag FROM spineowner.pop_wkly_refresh_20100201 w...
We are currently migrating one of our oracle databases to UTF8 and we have found a few records that are near the 4000 byte varchar limit. When we try and migrate these record they fail as they contain characters that become multibyte UF8 characters. What I want to do within PL/SQL is locate these characters to see what they are and then...
Is there any data type greater than CLOB in oracle ...
I'm scripting some data transfer routines and incorporating exp and imp into the workflow. Both of these have a FILE= parameter to specify the data file. Is there a way to specify stdin and stdout? I would love to do something like this: exp ... | ssh foo imp ... Right now I'm halfway tempted to work around this with mkfifo, but th...
Hi. I'm new to Silverlight and I need to develop some tiny web app with it. My requirements: User always need to be authenticated; Unauthenticated users cannot see any page. Authentication data is located in Oracle DataBase. That's all =) But I can't do it =( Because I've tried RIA and can't change it to Oracle. Thanx very much fo...
I am having table with clob column & trying to insert SIGNED character data which contains =176048 characters, it throws error has Insert exception data transaction java.sql.SQLException: ORA-01704: string literal too long ...
enter code here I need the count of records of a data base table from unix. I am calling one sql script from unix and need the record count to any log file . ...
I have a query that works when I have fixed values. ie: select count(*) from address a where a.primary_name like upper('cambourne court') and a.secondary_name like upper('flat 9'); However replace the upper('flat 9') with a variable which is second_name:=upper('flat 9') and the search now returns all 111 addresses in '...
Hi, I am using Oracle Application Express and I was wondering whether it's possible to call php inside a pl/sql page process? Can I use htp.p or htp.prn in pl/sql? For example, let's say I have a php function on the server that returns the remote_addr of the local machine - I basically would like to capture this function value and add...
I am currently working on a PHP project with an Oracle database. To update a table, the php code I'm working with uses a SQL "MERGE INTO" method to loop through a table and see if values for multiple records exist in another table. If they don't exist yet, the values are inserted into my table. If the values already exist, nothing hap...
First, we currently have the behavior that's desired, but it's not trivial to maintain when any changes to the database are needed. I'm looking for anything simpler, more efficient, or easier to maintain (anything that does any of those 3 would be most welcome). When we perform an update, a history row is created that is a copy of the ...
I am trying to restore oracle XE by clicking (run as administrator) Restore Database from Start menu -> All Programms ->Oracle Database 10g Express Edition. After entering yes to the confirmation question the error messages appear. Messages are: RMAN-00554: Initialization of internal recovery manager package failed RMAN-04005: error f...