Oracle sql required

I am a novice in database. But I hope this is the right group for asking this. I have an sql script for creating tables. Problem : but I want to drop the table if it already exists and re-create it. Any pointers as to how it can be done best?

I am trying to get a graph of index io on a daily basis, the trouble is the stats are cumulative since database startup and the database is rarely bounced. So what I actually get is a growing value for each day. What I really need is the difference b

If you have a table:- Description (varchar) DBKey (integer – unique) SortOrder (integer) And some data… Description DBKey SortOrder A 1 0 S 2 0 B 3 0 H 4 0 And you want to set the SortOrder field to reflect the correct Alphabetical Order of the Descr

What I'm looking for is the number of IDS where the minnumber or maxnumber is different within the same ID. For instance: ID 12345 has 3 groups Group min max 11111 19 25 22222 19 25 33333 19 25 ID 56789 has 3 groups Group min max 44444 19 25 55555 23

I am the Oracle Database SQL Expert. Do I need the "1Z0-942 Oracle Database 10g OCA Exception to SQL Requirement"?

When I go the the books store there are many books that cover beginners SQL, but I am looking for a book that is at a more advance level. Can people recommend any. Looking for ORACLE SQL or SQL in general. Brendon

I have don't really have much knowlege with SQL - Oracle relationships so any general conceptual knowlege would be greatly appreciated. I want to write a SSIS package in SQL Server that will use the OLE DB Provider for Oracle that comes with SQL 2005

I have open office 2.2.0 installed at my compute, now i want to connect my spread sheets to Oracle SQL through database drivers. So kindly tell me that what is the whole procedure to connect Oracle SQL with Open Office Spread Sheets, which driver wil

I have recently come across a requirement in which I am supposed to send mails with csv file as an attachment through oracle(SQL SCripts / Stored Procedure) . The contents of the csv file are to be retreived from the Database as well as the content o

My question is rather very trivial/basic, and that is with regards to internal working of Oracle.sql.Array when being used e.g. to return an array of Strings from java-stored-procedure to pl-sql stored-procedure (i.e the caller) as shown in this arti

Platform: Linux RHAS 3.0 RDBMS version: 10.1.0.4 What libraries, besides libxdb.so should be present in LD_LIBRARY_PATH for OPAQUE to function? I have a java application built on XDB access ... it works fine as stand alone access, but when accessed t

I'm in a position where I frequently receive job applications for Oracle SQL and PL/SQL Developer. I would like to compare my impressions for the different certification levels with your experience. Currently there are 3 certification levels that are

Oracle Version: 10.2.0.4.0 OS Version: SunOS 5.10 CPU load on the server use to be high occasionally for brief time and the high CPU usage sessions execute this below query. But i found two different execution plan for the same SQL statement. 206 pro

Job Designation - Oracle SQL DBA Job Code - Oracle SQL DBA - HTCHN Client Details - Our Client is a global provider of IT and Process outsourcing services. They have extensive experience in managing large IT applications in real time as well as in pr

I have connection to oracle and Access dbs’ on my oracle sql developer. When i try to create a database link from oracle db to access db i have to add Host Name. Connection details to access looks like this : @jdbc:odbc:Driver={Microsoft Access Drive

After I install Oracle sql developer, it works. Then I change the preferences, change window from oracle to window, then I can't start it up, although I can see the program is running in task manager. Then I delete it and reinstall, still same thing.

Can someone throw light on oracle.sql.* pacakge. There are tons of classes available like LobPlsqlUtil but I don't find any proper documentation on usage. Is it possible to use these Classes to write to CLOB or do we have to use only DBMS_LOB pacakge

While logging to sqlplus I'm getting the following message "sp2-0575: Use of oracle SQL feature not in sql 92 entry level." and login is successful, but I'm not able to generate next value from the sequence . t says no rows selected when i request fo

I am trying to connect to remote machine database through Oracle SQL Developer, it is giving me teh following error. Status: Faliure -Test failed :io connection :The Network Adapter could not establish the connection . I had given the hostname as the

I just created a script to query unique records in the Oracle SQL Developer. The results when run in Developer are unique but when i tried the script in SQL*Plus, it gives duplicate records. I tried the same script in TOAD and it did give unique reco