1. Why isn't querying a JDBC-compliant database from Oracle as easy as pie? stackoverflow.comOk, so it's almost as easy as pie already. But it really should be as easier than it is. I think I should be able to connect to another database just by ... |
2. Java library or code sample to parse CTXCAT query syntax (for Oracle CATSEARCH) stackoverflow.comI am interested in pre-parsing a user's input via Java for valid CTXCAT syntax before it is used to search against an Oracle CATSEARCH implementation (http://www.oracle.com/technology/products/text/htdocs/ctxcat_primer.html). The reason being is ... |
3. Concurrent queries on a given JDBC connection? stackoverflow.comI'm seeing OraclePreparedStatement executeQuery() exhibit serialization. That is, I have two queries that I want to run concurrently against an Oracle database, using the same connection. However, the OraclePreparedStatement ... |
4. How to convert Oracle "TIME" to JDBC Time in query? stackoverflow.comOracle doesn't support the TIME datatype, but you can use DATE to store a TIME. My problem:
yields:
|
5. JDBC: How can I query by time in Oracle? stackoverflow.comI have this JDBC SQL query:
This returns some rows. Note that, since Oracle has no TIME type, both columns are ... |
6. Simulation of long-running Oracle DB query stackoverflow.comWhat is the simplest (preferably without any new table creation) way of running a database query which takes long time (at least several minutes) in Oracle DB? |
7. What locale should I use for case-insensitive queries from Java? stackoverflow.comThe classic way to query an SQL database case-insensitively from Java is as follows:
|
8. How is Oracle's JDBC query timeout implemented? stackoverflow.comI was curious as to how the Oralce JDBC thin client implement query timeout. This can be set by calling java.sql.Statement's setQueryTimeout(int seconds) method. Is this implemented in the driver itself on the client ... |
9. (Design Idea) Best Practise to reserve record for multi-process workflow engine stackoverflow.comI'm designing multiple process to query job from database. Each job wake up once per minute to query task and send to workflow system. I need advice about which best way to mask ... |
10. JDBC query to Oracle stackoverflow.comWe are planning to migrate our DB to Oracle.We need to manually check each of the embedded SQL is working in Oracle as few may follow different SQL rules.Now my need ... |
11. Oracle: where can I query java grants? stackoverflow.comI need to check the current user's java grants, something similar to what has been set by: dbms_java.grant_permission('SCOTT','java.net.SocketPermission','*','connect');Can this be done without system privs from the current account? ... |
12. How to handle massive data query and control the time within 1 sec? stackoverflow.comI am thinking through a problem, if I get a table, and the data in it keep growing, thousand, million, billion .... |
13. Java web application & database design stackoverflow.comI have developed a work flow web application in Java with an Oracle backend. The workflow requires the user to complete a series of checklists. |
14. how to check if a value exists in table or not in java? stackoverflow.comcan any one suggest me that how can i check if value entered by user is exist in some specific table or not through javaCode? Thanks in advance!!! |
15. Oracle - Berkeley DB XML Java API - XML query to get attribute values at multiple level stackoverflow.comEvaluating Berkeley DB with Java APIs. Following is one of my test XML data:
|
16. Optimize the speed on performing "select" query in a big loop stackoverflow.comI'm performing a simple 'select' query in a Java loop as what is shown below. The size of the List can grow up to 10000+. How can I improve the query ... |
17. Oracle DB query data_length(what's it return) stackoverflow.comI am running some queries on an Oracle DB from my java program. Once a certain table is selected this query runs and returns some traits for the user. A simplified version ... |
18. Save result of XSQL query to a file in Java stackoverflow.comI want to Save result of an XSQL query to a file using Java. Does any one know a way to do this? |
19. Oracle DB Query Runs in sqlDev but not in Java Program stackoverflow.comI have been messing with Oracle DB queries that run from my JAVA app. I can successfully get them all to run in sqldeveloper. But when I am trying to execute ... |
20. The obsession of Java Socket and Oracle stackoverflow.comall. First,forgive my poor English. I suppose my Android client to post data to the TCP server that I created with using the java NIO . So the TCP Server can get data from ... |
21. Query view joining two tables over dblink does not work the first time stackoverflow.comI have a oracle 10g database A and B connected over a dblink and a view ( |
22. Query returning values from Oracle and no records when run from Java stackoverflow.comThis query is returning the record with Min Create time Stamp for the Person Pers_ID when I run it in SQL Developer and the same query is not returning any value ... |
23. Need advice on fixing my JAVA query statement? stackoverflow.comMy JAVA script consists of 2 JAVA classes: |
24. JDBC oracle newbie query coderanch.comHello everyone, I am a new user to both JDBC and Oracle and am unable to proceed with the following queries. It would be helpful if someone can assist me with the same. The schema for a store is: user (uid, addr) region (rid, rname) shop (sid, rid) category (cid, cname) product (pid, cid, pname, cost) transaction (tid, uid, sid, date) ... |
25. How to pass values to a Oracle query with a IN clause coderanch.comHi, May be the String that you are setting to the prepared statement would be treated as one String arguement..so the final Query would look like SELECT * FROM test WHERE a IN (' '0515','0514','0516' '); // Note the Quotes I dont know if this should actually result in an SQLException. try using SELECT * FROM test WHERE a IN (?,?,?); ... |
26. Querying Oracle for information between a time period coderanch.comHi, I would like to query Oracle 9i database to get information from a table between a given time period. My code passes me two Strings, which I convert into date (using SimpleDateFormat). One of these strings correspond to "Start Date" and the other one refers to "End Date". E.g, Start Date can be "11/23/2004" and End Date can be "12/23/2004". ... |
27. Oracle Query coderanch.comSelect the count of each using count(*) in the SQL query and then add the results which can also be done in the same SQL statement. Depending on your grouping requirements though, you might get duplicates (for example if the same parent reference appears in both child tables). Again, your requirements would dictate how to proceed, but if you need the ... |
28. how to access MSAccess and Oracle in one query coderanch.comWelcome to JavaRanch. While with some DBs it is possible to retrieve data from two of them in the same query, there is no way to do that if you have two different kinds of databases. You will have to write two queries. It is possible to come up with a transaction that spans two different kinds of databases, but not ... |
29. using :new in oracle JDBC Query coderanch.com |
30. Oracle driver query coderanch.com |
31. Querying Oracle with Java for To_Date coderanch.comI am attempting to query an oracle DB with Java. I'm brand new to Java so just learning, learning about Oracle too. I would like the results to be all entries that are before and including 7/6/2006, regardless of the time. But the oracle field is a date & time field. This is the baseline query I am attempting to modify. ... |
32. Querying Oracle with Java for To_Date coderanch.comI am attempting to query an oracle DB with Java. I'm brand new to Java so just learning, learning about Oracle too. I would like the results to be all entries that are before and including 7/6/2006, regardless of the time. But the oracle field is a date & time field. This is the baseline query I am attempting to modify. ... |
33. Problem with Oracle Query coderanch.com |
34. query in oracle coderanch.com |
35. Oracle update query question coderanch.comProbably not the ideal forum to post this, but I know you tend to get quick resulst here so I thought I'd give it a go. I have a tabel where I need to update a column, but I can only find the ID of that record by search a second table. Basically the pseudo code query is... Update table1 status='Effective' ... |
36. Oracle Query is not running coderanch.comSQL> ed Wrote file afiedt.buf 1 merge 2 into expertise t1 3 using (select 5 expertise,1 emp_id from dual) t2 4 on (t1.emp_id = t2.emp_id and t1.expertise = t2.expertise) 5* when not matched then insert(expertise,emp_id) values(t2.expertise,t2.emp_id) SQL> / 1 row merged. SQL> ed Wrote file afiedt.buf 1 merge 2 into expertise t1 3 using (select 5 expertise,1 emp_id from dual) t2 ... |
37. Can't access Oracle Schema for query coderanch.comI have a sales database with a customers table, but when I do a "select * from customers", Oracle tells me the table or view does not exist. Huh? If I go into SQL*PLUS and connect to sales ("Successful"), then do a SELECT * FROM CAT, I see the tables in the sales database (schema), including the customers table. The only ... |
38. Query works with Oracle but not with java/jdbc coderanch.comHello, has anyone seen a problem similar to this? I'm executing the following procedure with a PreparedStatement (no ? parameters). The section with 'VA' and current_date [or (stat_cd = 'VA' and updt_dts < current_date - 30/1440))] doesn't work - however the query works perfectly if I run it using SQLDeveloper or Toad for Oracle! Any ideas? Thanks. SELECT crte_dts, crte_usr_id, dm_3pty_ref_num, ... |
39. Oracle Queries performace coderanch.comHi I would like to know how we can imrove oracle queries performance. For example i have following sample queries which i need to optimize. 1) select count(0) totalCount from analyst_call_log rl,analyst_team at, (select associate_id from associate)creted_by_detail where rl.added_by_assoc_id = creted_by_detail.associate_id and at.associate_id = rl.added_by_assoc_id and at.team_id = rl.team_id and rl.confidential != 'Y' and rl.analyst_call_log_id in(select ac.analyst_call_log_id from analyst_call_log_contact ac where ... |
40. A query regarding using GROUP BY using Oracle as DataBase coderanch.comHI , Can anybody give me a clear idea on using GROUP BY Syntax : Here is the sample syntax , which i am currently using : SELECT column_name, SUM(AMOUNT) FROM TRANSTABLE WHERE column_name operator value GROUP BY column_name Please let me know what is the column name that should be supplied in case of column_name (In first Line of Query) ... |
41. oracle query with date question java-forums.org |
42. Querying in JDBC to oracle DB java-forums.orgHi, I have done a JDBC connection to an oracle database and trying to run update and select statements using prepared statements. The Problem is when i write a select * from tablename; i am getting the correct result but when i do select * from tablename where columnname=? and preparedStatement.setString(1, value.toUpperCase); i am getting 0 rows when i did a ... |
43. in an oracle query java-forums.org |
44. querying an Oracle database using Java forums.oracle.comBasically I'm developing a system which uses an artificial neural network to predict diagnoses for patients. The patients will select their symptoms in the form of checkboxes. I was just wondering how you would go about querying a database using the checkbox label. E.g., JCheckBox btn = new JCheckBox("Nausea", false); So when this checkbox is clicked the database is queried to ... |
45. Issue in Querying Oracle Database forums.oracle.com |