I want to substitute a variable in oracle. The var is coming in via SQLPlus and is reference using &1 &1 in my scenario is the schema name - here's the SQL. CREATE SYNONYM ACCOUNT FOR &1.ACCOUNT; Assuming &1 equals ABC the synonym created is for ABCAccount, instead of ABC.Account. For some reason the period is removed. Any ideas w...
Hi everyone, I have a pretty big sql statement which returns a list of id's. I need this id-list as base for other statements. Like this: open crs_result1 for ' select * from ... where id in ( select <ids> from <base_statement> ) '; open crs_result2 for ' select * from ... where id in ( select <ids> from <base_statement> ) '; open crs_...
I have three tables. Product, Company, Employee ProductId of Product table is foregin key for Company and CompanyId of Company table is foregin key for Employee So on deleting ProductId from Product table, all the related records in other tables should delete. But I can't touch schema(can't use alter table). How should I write the que...
Hello gurus, I would like to know if i can get a case study for my dissertation with the above topic. I am in dire need of data I can use for the developing the data warehouse and that would help me arrive at a possible conclusion of using the BI application I would be developing.Many thanks for your audience. Regards, Tunde ...
I am using nHibernate with Oracle, using Oracle's ODP implementation. http://tiredblogger.wordpress.com/2008/11/07/using-oracle-odp-with-nhibernate-from-a-c-class-library/ This is pretty much working but then I got this error: Unable to cast object of type 'Oracle.DataAccess.Client.OracleConnection' to type 'System.Data.Common.DbCon...
Hello, i have a Dimension Table like this : my_Table pk1 Primary key pk2 Primary key pk3 Primary key col1 col2 col3 ... and using a procedure to fill this table with the MERGE INTO statement : MERGE INTO my_Table dest USING ( SELECT <columns> FROM <tables> WHERE <conditions> ) src ON (dest.pk1 = src....
Hi mates, I have a table defining ranges, e.g.: START | END | MAP 1 | 10 | A 11 | 15 | B ... how do I query into that table so the result will be ID | MAP 1 | A 2 | A 3 | A 4 | A 5 | A 6 | A 7 | A 8 | A 9 | A 10 | A 11 | B 12 | B 13 | B 14 | B 15 | B ... I bet its a easy one... Thanks for the help f. ...
Maybe that will sound odd, but I need to schedule priority on oracle connections. It goes like that: I have one main 'connection' that will pump data out of oracle, and it should be as fast as it can be. I have two other connections that should (ideally) use all oracle resources not dedicated to the first query. Is there a way to do ...
I have an implementation of the jaro-winkler algorithm in my database. I did not write this function. The function compares two values and gives the probability of match. So jaro(string1, string2, matchnoofchars) will return a result. Instead of comparing two strings, I want to send one string with a matchnoofchars and then get a resu...
I have two small VB.NET applications that connect to the same Oracle database. One uses the OLEDB provider, and the other uses Oracle's ODP.NET. Should I expect to see problems with the OLEDB provider, as it's less 'native' to Oracle? Thanks for any help! ...
I need to know if somebody can read and save to oneself packages from my database, Oracle specifically. Can I prevent it? I mostly worry about tools like "Export schema" of Toad. How can I know somebody didn't something like exporting my database structure? ...
I currently have a project where we are dealing with 30million+ keywords for PPC advertising. We maintain these lists in Oracle. There are times where we need to remove certain keywords from the list. The process includes various match-type policies to determine if the keywords should be removed: EXACT: WHERE keyword = '{term}' CONTAIN...
Does Oracle have a column metadata for storing its printable friendly label? Say I have a column named prodDesc. I would like to be able to pull a column label such as "Product Description" for use in end reports & web pages. I plan to utilize the column size meta data as well so that when I generate an html form I can dynamically set th...
I'm having all sorts of trouble... Here is the code I'm using: $c = OCILogon('user', 'pass', 'host'); I get the following error: PHP Warning: ocilogon(): ociopen_server: Error while trying to retrieve text for error ORA-12514 in D:\Inetpub\wwwroot**\oracle.php on line 26 Anyone know what the hell I'm doing wrong? It's PHP4, II...
If I do this: loadjava -u user1 MyClass.class loadjava -u user2 MyClass.class are the two class definitions distinct? i.e., I can install a new version into user2 without affecting the code referenced by user1? ...
Hi, I am doing some practice with clsql. I want to connect my oracle server hence my connection function is; (connect '("192.168.2.3" "xe" "username" "password") :database-type :oracle) when i hit the return, the following error message shows up. Couldn't load foreign libraries "libclntsh", "oci". (searched *FOREIGN-LIBRARY-SEARCH-PA...
How can I optimize this query if given the following query returns either all entries in the table or entries that match only up to current date ? btw: The Query is targeted to a Oracle Linked Server on MS Sql 2005 as an Inline function.. Do not want this to be a table value function.. ALTER function [dbo].[ftsls031nnnHades](@withExpir...
BEGIN dbms_output.put_line('Welcome to PL/SQL'); END; / I have this code in sample.sql file. How to run sample.sql? ...
Range for Oracle Date Data Type: "January 1, 4712 BC to December 31, 9999 AD", Does the range has any logic behind it? I mean the range has any historic significance or it has something related to programming and memory size etc. I am just wondering, why only from January 1, 4712 BC to December 31, 9999 AD. ...
Using sqlplus 11g on windows to run sql script on 11g database. Sqlplus hangs if insert line left in script. If I comment out the insert line, the script returns the records. Script exec time is < 1 sec when run in sql developer. I have tried to make the insert statment one continuous line with same resutls. using echo on, it hangs r...