Imagine if I have a application I install via clickonce or setup to the customer machine.And it needs oracle client? How can the oracle instant client be installed by the end user ? Or how the hell should it be installed? Should I go to each pc and install it? ...
I'm tring to use join but facing this issue. I've pasted my query select count(*) from table_a inner join table_b on table_a.number = table_b.number left outer join table_c on table_a.id = table_c.id and table_a.number = table_c.number order by number; pls let me know ...
I'm using the pl/sql htp package to create simple web pages. Now I need to use different templates based on the device accessing the pages (Desktop Browser or Mobile Blackberry Client ). Is this possible in pl/sql? ...
I need a solution to deploy the Oracle Instant Client on User's PC's (on or more) .Please suggest some way which I can do to make a Setup from what Oracle provides. Basically the Oracle Instant Client is a ZIP file (instantclient-basic-win32-11.1.0.7.0.zip (46,734,555 bytes) you can extract to a folder on the User's PC and then set: ...
im trying to insert data into my oracle database but i am getting "invalid month" error as it seems that i cant convert the datetimepicker value of my form into oracle date or timestamp(7) please help! my code dateTimePicker1.Format = DateTimePickerFormat.Custom; dateTimePicker1.CustomFormat = " dd MM yyyy "; string m = "insert into ...
Hello All, I have set up a dataguard config, and done most of the work from within DGMGRL to avoid possible issues, its seems to be running fine, but its reporting the following problem: ORA-16801: redo transport-related property is inconsistent with database setting. Looking at DGMGRL it gives me the following info: DGMGRL> show dat...
I have a large (multi-GB) data file exported from an Oracle table. I want to import this data into another Oracle instance, but I want the table name to be different from the original table. Is this possible? How? Both importing and exporting systems are Oracle 11g. The table includes a BLOB column, if this makes any difference. Th...
I'm pretty sure this is something really silly. Instead of spending another 10 minutes with this ( or better said, while I spend another 10 minutes with this ) I'll ask it here in parallel. What's wrong with the following statement: select to_date( '30/10/2009 18:27:35', 'DD/MM/YYY HH24:MI:SS') from dual The error message is: Err...
Hello Folks, I have an adress table and I need to take the near number. For example if I´m entenring the number 256 in this case I´ll take 257 because: 254<--256->257 Somebody knows the solution. Thanks and sorry for my bad English. ...
I have situation where a 3rd party open source product I am using is running out of cursors in Oracle and receiving the error: java.sql.SQLException: ORA-01000: maximum open cursors exceeded My maximum cursors is set to 1000 and I am trying to figure out if the code that is reaching this limit is doing something incorrectly, or if I sim...
Is there a system table/view/procedure/whatever which can be used to determine the last time a proc, function, or packaged procedure was invoked? ...
Say I have a program that searches a database for columns to modify, as part of a database conversion process. If I attempt to alter a column with a functional index defined gives the following error: ORA-30556: functional index is defined on the column to be modified Looking up the ORA code, the solution is to "Drop the functional i...
I'm trying to use a pipelined function to save on time and reduce redundancy in my queries. The function in question returns data from a reference table based on some input. Records in the main data table I am selecting from have multiple columns that all refer to the reference table. The problem I run into is that when I try to use the ...
In the program I have, I depend on the SQL Server TIMESTAMP data type to tell me if a row's "content" has changed. What's the way to find out if a row's content has changed in Oracle (preferably without having to add a extra column for this in a table) ? ...
I ran a data copy function in Toad that disabled all constraints and then failed. That left me with a bunch of disabled constraints. Most of them I've been able to enable successfully, but the flashback ones are giving my stored proc fits. Questions: 1) Is it necessary to reenable the constraints on the flashback tables? My assumpt...
Hello everyone, I heard MySQL has no transaction support at all? Is that true? If yes, how could people write reliable code to make sure data consistency and reliable compared to other commercial database (e.g. Oracle/SQL Server)? thanks in advance, George ...
i want to develop a procedure for following scenario. I have one source, one target and one error table. Target and Error tables have all fields that are present in source tables. But the data type of all fields for error table are varchar. Error table don't have integrity, foreign key and other constraints. Error table also have t...
Hi! I know there are several threads and posts regarding this issue in the internet and I've read them (not every article, I have to admit) but none of them did fully satisfy me. My situation: I'm using ODP.net (dll version 2.111.6.0) to access the Oracle DB (version 10 + 11) and a DataReader to retrieve the data (.NET 3.5, C#). Using...
When I have two sql-files, one of them in a sub-directory main_test.sql sub/sub_test.sql and sub_test.sqlcalls @../main_test.sql (or @@../main_test.sql) then this works fine when executing it from the sub-directory sub> sqlplus xxx @ sub_test.sql But when I call sub> cd .. > sqlplus xxx @ sub/sub_test.sql this results in SP2-03...
Hi Folks, following problem, i want to create an view in Oracle wich calculates an "utilization rate in percent". AS SELECT sw.SWITCH_ID, sw.ASSET_ID, sw.SYSTEMNAME, sw.MAX_INSTALLABLE_PORTS, sw.INSTALLED_PORTS, sw.USED_PORTS, (sw.INSTALLED_PORTS/sw.MAX_INSTALLABLE_PORTS)*100 AS UTIL_INSTALLED_PORTS, sw.RES_INFRASTRUCTU...