• Is it possible to kill all sessions connecting to an Oracle database?

    I'm looking for a SQL Plus script that can quickly kill off all external sessions connecting to my Oracle database without the supervision of an administrator. Anyone know how to do this?

    ITKE347,785 pointsBadges:
  • Trying to connect to an Oracle database through Visual Studio 2010

    I'm trying to connect to an Oracle database through Visual Studio 2010. The only thing is that I don't actually want to download Oracle. I've referenced System.Data.OracleClient but it's not doing it for me. I do have an Oracle SQL Developer IDE to run SQL queries against an Oracle DB. Here' the...

    ITKE347,785 pointsBadges:
  • How can I connect Android to an Oracle database?

    I really need to access data from an external Oracle database through an Android application (so I can actually update the local database application). I'm not sure what's the best way to do it. Should I create a web service to access it or is there another way?

    ITKE347,785 pointsBadges:
  • Check the data between two dates in an Oracle database

    I have an Oracle database and I need to execute a query to check the data between two different dates. Here's what I have: NAME START_DATE ------------- ------------- Small Widget 15-JAN-10 04.25.32.000000 PM Product 1 17-JAN-10 04.31.32.000000 PM select * from where start_date BETWEEN '15-JAN-10'...

    ITKE347,785 pointsBadges:
  • How do I check the maximum number of connections in an Oracle database?

    Would be the best way, using SQL, to actually check the maximum number of connections that are allowed in an Oracle database. I need it to show the current number of sessions and the total number allowed. Appreciate any help.

    ITKE347,785 pointsBadges:
  • How to load an Excel spreadsheet to an Oracle database

    Does anyone know of a free tool that I can use to load an Excel spreadsheet into a Oracle database? I already tried Oracle SQL developer but it keeps giving me a NullPointerException. Can someone help me out there?

    ITKE347,785 pointsBadges:
  • Performing a multi-row insert into Oracle 9

    I've been trying to find the easiest way to perform multi-row inserts into our Oracle database (it's Oracle 9). This code has been working for me in MySQL but it's not working in Oracle: INSERT INTO TMP_DIM_EXCH_RT (EXCH_WH_KEY, EXCH_NAT_KEY, EXCH_DATE, EXCH_RATE, FROM_CURCY_CD, TO_CURCY_CD,...

    ITKE347,785 pointsBadges:
  • How do I solve the ORA-00933: SQL command not properly ended error message?

    For the past few weeks, I've been using an OLEDB provider for ADO.NET connecting to an Oracle database. Currently in my loop, I'm doing this insert: insert into ps_tl_compleave_tbl values('2626899', 0, TO_DATE('01/01/2002', 'MM/DD/YYYY'), 'LTKN', 'LTKN', '52', TO_DATE('01/01/2002', 'MM/DD/YYYY'),...

    ITKE347,785 pointsBadges:
  • How can I get the last row of a table in an Oracle database?

    I have an Oracle 11g Express database and I'm having trouble getting the last row in one of my tables. Can anybody help me with this? Thanks so much.

    ITKE347,785 pointsBadges:
  • How to insert BLOB in an Oracle database using C#

    We have to persist a .CSV in our Oracle database but we're trying to not to use procedures (so we have a more testable application). Basically, we want to generate a file and put it in the database. Anyone know how to do this with code (particularly BLOB with C#)?

    ITKE347,785 pointsBadges:
  • How to turn off password expiration permanently in Oracle 11g

    I've been using Oracle for my development testing. But now the password for my bootstrap account that I always use to rebuild my database has expired. Is there a way to turn off the password expiration for users permanently? I'm currently using Oracle 11g. Thanks so much.

    ITKE347,785 pointsBadges:
  • How can I determine if a table exists in Oracle?

    I've been writing some different migration scripts for an Oracle database and I'm hoping Oracle has something similar to MySQL's "IF EXISTS" construct. Whenever I need to drop a table in MySQL, here's what I use: DROP TABLE IF EXISTS `table_name`; So if the table doesn't exist, the DROP doesn't...

    ITKE347,785 pointsBadges:
  • Can I clone a user in the same Oracle database?

    I have the need for a SQL query that will clone an Oracle user. For the source, I already have a user that has the necessary privileges. Would there be a way to clone the user but with a different username in the same database?

    ITKE347,785 pointsBadges:
  • Benefits of Oracle database 10g vs. 11g editions?

    What are the benefits of Oracle 11 g edition over Oracle 10 g express edition?

    MUKUNDSAWANT55 pointsBadges:
  • Getting ORA-01882 error when accessing Oracle database through a Java application

    I've been trying to access an Oracle database through a Java application but when I try to run the app, I keep getting this error: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found Anyone have an idea on what I should do here?

    ITKE347,785 pointsBadges:
  • What’s the difference between Oracle 9i, 10g, 11g?

    And also what's the difference between oracle9i/10g/11g. Or if not wrong they are different versions only.

    Pooni20 pointsBadges:
  • How can I create a temporary table in a Oracle database?

    I've been trying to create a temporary table in my Oracle database but I'm not sure how to do it. I have this so far: Declare table @table (int id) And I need to populate with a SELECT statement too. Appreciate the help.

    ITKE347,785 pointsBadges:
  • How to get the list of all tables in Oracle database

    I apologize for the short question but is there a way that I can get my Oracle database to display the names of all the tables in it? A query perhaps? Thank you.

    ITKE347,785 pointsBadges:
  • How to create an Excel spreadsheet from an Oracle database

    I currently have a table in a Oracle database and I need to create a complex Microsoft Excel spreadsheet structure from that specific table. Should I use SSIS to do this? Is there another way to create it? Appreciate the help.

    ITKE347,785 pointsBadges:
  • How do you load a CSV file into Oracle?

    How do I load a .CSV file into Oracle?

    Dolly275 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following