Search results for query: *

A simple one.I need a script to drop all packages in a schema where name starts with 'T_%'

Hi For testing purposes i need to create a schema in an oracle database which is an exact copy of an existing schema in the same database. Which is the simplest way to do this? Is there any command Thanks PJ

Thanks a lot!! Wangdong

I have an application which opens a URL connection and i found that even after completing the operation the session is hanging and not getting closed Any suggestions import java.net.URLConnection; import java.net.URL; import java.io.IOException; import java.util.HashMap; import...

Is there any way to edit this now?

I have an application which opens a URL connection and i found that even after completing the operation the session is hanging and not getting closed Any suggestions import java.net.URLConnection; import java.net.URL; import java.io.IOException; import java.util.HashMap; import...

Hi The lang package is by default imported into the class. Therefore the issue is something else. I tried with the import statement but still the same error

I am trying to compile this class import java.sql.*; class JdbcTest1 { public static void main (String[] args) { try { // Step 1: Load the JDBC driver. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Step 2: Establish the...

Any idea why this error C:\>javac JdbcTest.java JdbcTest.java:14: cannot resolve symbol symbol : variable currentThread location: class java.lang.Thread Thread.currentThread.sleep(2000); ^ 1 error C:\>

Thanks to you Tim :)

Thanks a lot :)

This is the script import java.sql.*; class JdbcTest1 { public static void main (String[] args) { try { // Step 1: Load the JDBC driver. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // Step 2: Establish the connection to...

Thanks for all the replies Actually what i need to do is connect to an oracle database, wait for 2 secs and then disconnect (This need to be done only once).

Thanks Dian for your reply I need to launch the connection every 5 secs. Is this possible?

Hi I am writing a small java program to connect every 5 seconds via the jdbc-odbc bridge driver. Is there any option to refresh connection every 5 secs? Thanks in advance

yeah .I have voted now. He responded so fast :). Thanks for reminding me

Thanks a lot Mufasa. It is working fine. Really appreciate your help :)

I need to list public views, their owners and column names in each view I have written the query to display views and owner names but cant figure out how to display column names for each view under the view. I am adding my script below Could someone help me with this declare viewname...

Nothing :)

Hi Can anyone suggest an easy way to display the data in a txt file in tabular format in HTML page dynamically The content of text file is something like this prompt prompt List user information V8 @user column c1 heading "User Information@100" format A30 column c2 heading "User ID@45"...