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

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...

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...

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

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...

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"...

Hi I am using ORacle thin driver to establish connection to Oracle 9.0.1 but found that the connection is extremely slow and i have problems accessing table in database. Does anyone have the coding for using oracle thin driver with oracle 9.0.1 This is my coding...

Hi, I am using Apache POI to write data to an excel sheet from oracle table using java.I downloaded zipped file for poi from the site.But i am not able to locate jakarta-poi-1.5.1-final-20020615.jar file anywhere after unzipping the same. How to install the same? Also i need to overwrite an...

Hi, Importing data to oracle from Excel is working perfectly with the JDBC-ODBC brdige driver.But when i try to export data back from oracle to Excel using the same method its raising exception Exception:[Microsoft][ODBC Excel Driver] Operation must use an updateable query. I'm adding the...

Hi, I have an XLS file with over 1000s of records which i need to export to an oracle table with the same record structure as excel doc.I wrote this code for transferring data from excel to oracle. import java.sql.*; public class XLSHandler { public PreparedStatement xlsData; public...

hi, Hi, I have a dynamic JTree built from records in an oracle database.I created the tree with two fields location and description displayed side by side on the tree, something like this : Root | location :: description . . location4000 :: description4000 There is a third field parent in...

Hi, I have a dynamic JTree built from records in an oracle database.I created the tree with two fields location and description displayed side by side on the tree, something like this : Root | location :: description . . location4000 :: description4000 I want the description field to be...

Hi, Can anyone help me with a code for dynamically create a JTree hierarchy using data retrieved from an oracle table. Thanks, Priya