• 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,520 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,520 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:
  • 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,520 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,520 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,520 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,520 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,520 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,520 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,520 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,520 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:
  • How can I split CSV strings in Oracle 9i?

    I'm trying to to split several CSV strings in Oracle 9i but I'm running into a few issues so I have a couple of questions: Is this possible in Oracle 9i? Do I need to create a new data type? Would I be able to declare the type within the function? Thank so much!

    ITKE347,520 pointsBadges:
  • Losing JBoss connection to Oracle

    We currently have Oracle on JBoss on two separate servers. The connections seem to be dropping and it's been causing issues on JBoss. Is it possible to reconnect to Oracle if the connection is bad while we figure out what's happening with the connection itself?

    ITKE347,520 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,520 pointsBadges:
  • PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being NULL

    Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure I can check IF address 3 IS NULL THEN ... END IF But i want to test with test case tat it can't take NULL but...

    Inprise610 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,520 pointsBadges:
  • about oracle with Java

    What is future of Oracle with Java regarding jobs for freshers and distance learners. Why I am asking this because I am learning oracle from SQL star tutorial in delhi and doing MCA from Sikkim Manipal University in distance learning.

    Qqqq10 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