I am trying to drop a tablespace in oracle 10g , using my application . A bit about my application -- In my application I can create tablespaces.
I have a query select * from table where name in (\'52 T&M\', \'60 T&M\'); The \"&\" is causing the query to expect a parameter.How do I qualify the开发者_JAVA百科 \"&\" in the quer
How to compare dates which are in different tables and find the d开发者_如何学JAVAifference between two dates?take a look at this:
I am trying to invoke ExecuteNonQuery() method of two different objects of OracleCommand class. Both the objects use same connection object but have different commandText and parameters. I am using OD
I have to write a query which should do the following task select SID from v$session where username = \'some user\'
I am using OC4J 10.1.3.1. (It can be accessed via http://localhost/em) A connection pool is created. A Da开发者_Python百科taSource is created.
I am trying to find out what isolatio开发者_如何学编程n level a particular session (not my own) has on an oracle server. Is there a v$.. view to get this?You can test bit 28 in the flag column in v$tr
I am facing a JNDI Datasource lookup problem in Or开发者_开发技巧acle OC4JAS 10i deployment. This problem occurs only in quartz scheduler job. any ideas?Just add \"-userThreads\" switch in the command
I fixed and use Connection Pool to get the DB Connection from JSP to Oracle Database now. But then I found out from the OC4J console at once that there are many UNCLOSED/NOT-CLOSED connection.
Can somebody explain difference between \"before\" and \"after\" trigger i开发者_如何学运维n oracle 10g with an example ?First, I\'ll start my answer by defining trigger: a trigger is an stored proced
加载中,请稍侯......