• Disable all table constraints in Oracle

    Would I be able to disable all the table constraints in Oracle using one single command? It doesn't matter what table it is. It can be for a a single table, list of tables or for all tables. Thanks so much!

    ITKE347,815 pointsBadges:
  • How can I reset a sequence in Oracle?

    Does anyone know how to reset a sequence in Oracle? I know that in PostgreSQL, I used this: ALTER SEQUENCE serial RESTART WITH 0; Is there anything like this in Oracle?

    ITKE347,815 pointsBadges:
  • Getting the size of an Oracle 10g table

    I've been using MySQL and I'm fairly new to the Oracle world. I'm trying to figure out how to get the size of a table in Oracle 10g. What's the best way to do this? Would this work? begin dbms_stats.gather_table_stats('MYSCHEMA','MYTABLE'); end; / Thanks!

    ITKE347,815 pointsBadges:
  • Distributing Oracle Express licensing fee

    Oracle Express Edition Licensing. I would like to distribute Oracle express 11 with my commercial application. Can I distribute oracle express free. I am sure that my client is ready to accept the technical limitation set forth in the express edition.

    Vinodhariharan5 pointsBadges:
  • Getting ORA-011033 error message: Oracle initialization or shutdown in progress

    I've been trying to connect to an Oracle user through TOAD or Oracle Enterprise Manager but I keep getting this error: ORA-011033: ORACLE initialization or shutdown in progress What should I do here?

    ITKE347,815 pointsBadges:
  • How to store Form values in Oracle 10g with VB.NET

    How do I store form values in Oracle 10g database storage in VB.NET 2005?

    Shaz255 pointsBadges:
  • How to calculate two business days in Oracle

    I've been trying to calculate business days between two different dates in Oracle select. I've reached the point that my calculation is giving me the correct results (mostly) for the dates but sometimes it varies from 2 days to -2 days. Here's what I have: SELECT ((to_char(CompleteDate,'J') -...

    ITKE347,815 pointsBadges:
  • How to create a trigger in Oracle Express

    I'm fairly new to Oracle (and triggers particularly) but I need to do an auto-increment in Oracle 11g Express and SQL Developer. This is what I have so far: CREATE TABLE theschema.thetable (id NUMBER PRIMARY KEY, name VARCHAR2(30)); CREATE SEQUENCE theschema.test1_sequence START WITH 1 INCREMENT BY...

    ITKE347,815 pointsBadges:
  • How to use bulk insert from Java to Oracle

    I'm looking to insert several small rows quickly into Oracle. Using MySQL, I broke the inserts into groups of 100, then use one insert statement for every group of 100 inserts. But with Oracle, the mass inserts are way too slow. Is there a way I can speed it up?

    ITKE347,815 pointsBadges:
  • How to group by alias in Oracle

    How would I be able to "group by" a query using an alias. Something like this: select count(*), (select * from....) as alias_column from table group by alias_column The only thing is that I keep getting this 'alias_column' : INVALID_IDENTIFIER error message. What should I do here?

    ITKE347,815 pointsBadges:
  • ORA-27101: Shared memory realm does not exist

    I'm getting the ora-27101:shared memory realm does not exist error message. What should I do?

    Knikhil10 pointsBadges:
  • 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,815 pointsBadges:
  • Inserting multiple rows in Oracle 10g

    I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific...

    Ora mer20 pointsBadges:
  • Writing a SQL query for an Oracle table

    We have this data in an Oracle table (here it is below): MONTH VALUE 1 100 2 200 3 300 4 400 5 500 6 600 So we need to write a SQL query so the results are showing like this: MONTH_JAN MONTH_FEB MONTH_MAR MONTH_APR MONTH_MAY MONTH_JUN 100 200 300 400 500 600 Any help would be appreciated.

    ITKE347,815 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,815 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,815 pointsBadges:
  • How to check if a value is a number in Oracle 10g

    I'm wondering if there's a way to check if a value, from a column in Oracle 10g query, is actually a number so I can compare it. This is what I have so far: select case when ( is_number(myTable.id) and (myTable.id >0) ) then 'Is a number greater than 0' else 'it is not a number' end as valuetype...

    ITKE347,815 pointsBadges:
  • How to give Oracle user access to another user’s schema

    We have two users in Oracle that were created by running the following commands as SYSDBA from SQL Plus: create user $blah identified by $password; grant resource, connect, create view to $blah; Now we need to give one of those users access to the other user's schema but we're not sure on how to...

    ITKE347,815 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,815 pointsBadges:
  • USB Storage Device Problems

    I have a Maxell USB storage device which I'm having problems accessing. Whenever I connect it to my desktop it takes ages to recognise that the device has been connected, and showing the folder in the My PC. When it finally does and I try open it and I have to wait for the green bar to fill up at...

    Baaliefiy25 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