Like the title says, if anyone has the answer I would like to know. I've been googling but couldn't find a straight answer. Example: This works SELECT COUNT(*) FROM Table1 TB1, Table2 TB2 WHERE TB1.Field1 = TB2.Table2 This seems to take hours SELECT COUNT(*) FROM Table1 TB1, Table2 TB2 WHERE TB1.Field1 <> TB2.Table2 ...
I need help with writing a select clause query. For example, lets say I have a query like that: select value from some_table order by value asc; as a result I get this: 1 2 3 4 5 6 7 8 9 10 but a special query I want to write, is the one which still will give me sorted values, but will put 5 after 8. this means I need one value ...
This is a particular problem that I have come across many times, but I have never really found a simple solution to this (seemingly) simple problem. How to you ensure that a given parent has a fixed number of children? 1) Example. How do you make sure a given class has only , say, 50 students enrolled..? create table class( class_...
In Oracle db we have a table with varchar2 type of column (for example USERNAME). How can I set a exact (or at least minimum) length for this column? So that all usernames inserted into this table can be only 10 (or have to be at least 10) characters long. ...
I might be lazy to search this, but I have no idea how to insert an array of records in to an Oracle table using C# and ODP.Net. I have seen basic examples with inserting primitive types but never found any with something like array of records. Any help? I basically need to have a record type which would have three out of five columns i...
I need to write a query which takes rows and converts it into columns - here's my table: Count fname lname id ----------------------------- 1 abc def 20 2 pqr 20 3 abc xyz 20 4 xyz xyz 20 1 abc def 21 1 pqr xyz 22 2 abc abc...
Is it possible to connect Oracle with ArcGIS for doing spatial query? ...
Hello, We need to bulk load many long strings (>4000 Bytes, but <10,000 Bytes) using cx_Oracle. The data type in the table is CLOB. We will need to load >100 million of these strings. Doing this one by one would suck. Doing it in a bulk fashion, ie using cursor.arrayvar() would be ideal. However, CLOB does not support arrays. BLOB, LOB,...
Hi I need to write script to capture the excel datas to a database table.Table name is B_USER So select * from ..? Any help will be appreciated INSERT INTO B_USER (SELECT U_ID, U_NUMBER FROM ???? ) ...
I know this question will probably provoke more discussion than concrete answers (which I know isn't preferable). But with the recent acquisition by Oracle, I was wondering if there's been any word that Java might (someday) get reified generics? I've heard that Oracle wants to give Java a bit of a boost, and I can think of no better wa...
Hi, Does anybody know if there is a way to find what the length of the longest row in a column in Oracle? Basically I need to get the length of the longest row and then use that length plus 1 with SUBSTR to make the output of the column one character longer than the longest string. Thanks EDIT: Thanks for the advice. However, the MA...
Is there a reason MySQL doesn't support FULL OUTER JOINS? I've tried full outer join syntax in mysql many times and it never worked, just found out its not supported by mysql so just curious as to why? Thank you inadvance;-) ...
What are the differences/equivalences between Microsoft Sql and Oracle connection parameters, and are there some common names they map to? Things like "database", "instance", "username", "tablespace". From Help me put Oracle terminology into SQL Server terminology we get: | Oracle | Sql Server | Universal| ==================...
Hello, After rebooting the server the oracle connection from the Tomcat server times out every night. Prior to the reboot, the connection didn't timeout. Now, in the morning the application throws a JDBC connection error accessing the DB. Restarting Tomcat corrects the issue. I'm assuming that's due to the connections being re-establish...
For some reason, the files in the database won't open if they have the # character in them... One thing i noticed was in the file name, the link doesn't have %20 for the space characters after the # sign, but even when i replace the rest of the number characters with the %20 character, the link still doesn't work.. Any ideas why it cou...
Hi. In a Rails app I have a Company ActiveRecord Object and one of its field is a :text. This app must to work (please don't ask why... is my boss decision) in mysql and Oracle. in mysql works without problem (is a text datatype), but in Oracle is a CLOB and every time I tried to save (a new object or updated a existing one), this error ...
The only good reference that I can find on the internet is this whitepaper, which explains what database tiering is, but not how it works: The concept behind database tiering is the seamless co-existence of multiple (legacy and new) database technologies to best solve a business problem. But, how does it implemented? How does...
I'm looking for a better way of searching through numeric ranges in Oracle Text. I have a DB app that does a lot of GIS-type things, but we now want to add street range searching to it. So I'd like to store the min and max values in a column, and search for a number within those values. I'm happy to go explore options, but I'd like som...
I'm trying to open a REF CURSOR using a select statement like.... OPEN myREF FOR SELECT * FROM MYTABLE WHERE MYID IN (:Values) USING myPassedInValList; But this only work when myPassedInValList has only a single ID in it. I'm trying to use a list like '1','2','5', etc... Can someone tell me why this doesn't work. I tried to Google...
I have the follwoing query which works but I'm wondering if it could be more efficient. I need the first and last name of the 4 employees from the phonebook table (pb) who's badges (the employees ID) are stored in the Commitment table SELECT Originator_ID, (SELECT pb.lname FROM pb WHERE pb.badge = Commitment.Originator_ID) AS Origina...