I have a logging table that contains data that looks like this: ID MSG DATE --------------------------------------------- 1 TEst 2010-01-01 09:00:00 2 Job Start 2010-01-01 09:03:00 3 Do something 2010-01-01 09:03:10 4 Do something else 2010-01-01 09:03:12 5 Do so...
I'm using php 5.2 with oracle 11.1. This code: $query = oci_parse($conn, "SELECT * FROM COMMENTS WHERE PINID=$pinID and COMMENTID=$commentID"); results in this error: <b>Warning</b>: oci_execute() [<a href='function.oci-execute'>function.oci-execute</a>]: ORA-00904: "COMMENTS": invalid identifier in <b>C:\IODwww\hello.php...
Hi, I'm migration Access 2003 to 2007. There are a lot of linked table from Oracle. I create a ODBC point to Oracle instance, then in Access I link all table through ODBC. I use this code login, so the "Oracle ODBC Driver Connect" dialog box would not popup to ask password: strConnect = "ODBC;DATABASE=" & strFCPD & ";DSN=PBRIS;UID=...
I want to check the last time stats was run on my Oracle 10g server. I would normally do this via OEM, but for unrelated reasons OEM is down. Is there some way I can check this using just sqlplus? It would be extra helpful if the output was reasonably formatted. ...
Hi all! Maybe this sounds a little bit crazy, but I need to come up with a query to retrieve only letters out of an alphanumeric field. For example: TABLE 1234ADD 3901AC 1812OPA 82711AUU RESULTS EXPECTED ADD AC OPA AUU Thank you! ...
Hi folks I have a table that containts a set of columns one of it is a Date column. I need to count how many occurrences of the values of that column refer to the same month. And return if for one month, that count sums more than 3. For example: ____________________ | DATE | .... | --------------------- 1998-09-02 1998-09-03 19...
I am migrating a database from Oracle 10.1 to 11.2 and I have the following problem. The statement SELECT '<?xml version="1.0" encoding="utf-8" ?>' || (Xml).getClobVal() AS XmlClob FROM ( SELECT XmlElement( "Element1", ( SELECT XmlAgg(tpx.Xml) FROM ( SELECT XmlE...
Hi, I 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 side? Is a new thread spawned and joined? Or does the JDBC driver simply send a parameter to Oracle, and then it e...
I'm mostly an oracle novice, so forgive me if this is a stupid question... I have a schema called 'CODE' with a stored proc that executes arbitrary SQL (for now, please ignore the potential security issues associated with that). The SQL that is passed in will select data; but all of the data resides in either schema A, B, or C - but th...
SELECT NAME FROM ABCD WHERE NAME LIKE "+aero+%"AND ROWNUM <= 10 what is the syntax error in this line......SELECT NAME FROM ABCD this is working ...
Hi. Ive got problem with using overlapped theme based foi's in firefox. The problem is that only one foi is clickable, and the foi under the upper one is only displayed but not active. It works in IE. One foi is polyline and other is polygon. Is there any solution ? ...
I need to extract the 'full' hour of a timestamp. Like for 2010.03.04 13:13 I want 2010.03.04 13:00 (as a timestamp again). My current approach is: TO_TIMESTAMP(TO_CHAR(m.begin, 'yyyy.mm.dd hh24'), 'yyyy.mm.dd hh24') Is this really the way to go? Who good/bad does it perform (I plan to do a GROUP BY on it). Thanks for your input! ...
How can create a New user in ORACLE with full access (alter, delete, select, inset, debug, etc) to an only one specific SCHEMA. ...
I am using VB.Net 2008 and ADO.Net to do a Batch Update to our Oracle database. The updates are working, but there is a trigger on the table before the row is updated to enforce a member's termination termination date. So if I was trying to set the termination date (via the batch update) to 31-Jan-2010 but the member had a claim that w...
Hello, Is it possible to use Oracle JDBC implicit connection caching in conjuction with Oracle TAF failover? Or is this available only to Fast Connection Failover? Thanks. ...
Out of habit I've been using try/catch blocks in my application code for all SQL queries, with a rollback at the beginning of the catch block. I've also been committing those which are successful. Is this necessary for SELECTs? Does it free up something on the database side? The select statements aren't altering any data so it seems ...
I want to update a table to indicate that some rows are parents of others, so I added a "parentid" column to the table. The following query finds all the parents: SELECT ca1.id, ca2.id FROM contactassociations ca1 JOIN contactassociations ca2 ON (ca1.contactid = ca2.contactid) where ca1.entitytable = 'EMPLOYER' AND ca2.entitytable = '...
Wich role is recommended for an ORACLE user used internally by an desktop or web application? this application makes querys, updates and inserts over only one schema. Exist a default o recommended role for this task? ...
I have a following oracle query: SELECT a.USER_ID, c.first_name, c.last_name, TO_CHAR( b.logon_date, 'MM/DD/YYYY HH:MI:SS am') logon_date, NVL(TO_CHAR( b.logoff_date, 'MM/DD/YYYY HH:MI:SS am'), '') logoff_date, a.session_id FROM table a, table b, table...
Am trying to do the union of the results of two queries. But I'm getting the following error: Error at Command Line:9 Column:81 Error report: SQL Error: ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis" SELECT application_id, clicks, datee, client_id FROM( (select APPL_CD AS application_id, count...