• How to insert a UPSERT operation into an Oracle table

    I understand that UPSERT operation either updates or inserts a row into a table (depending if the table already has a row with matching data). Here's the code: if table t has a row exists that has key X: update t set mystuff... where mykey=X else insert into t mystuff... But in Oracle, it doesn't...

    ITKE351,965 pointsBadges:
  • Deploy a .NET application that talks to an Oracle database

    Would there be a way to deploy a .NET application that talks to an Oracle database? If so, what would be required? Thanks for the help.

    ITKE351,965 pointsBadges:
  • How to add a boolean field to an Oracle table

    This past week, I've wanted to add a "Boolean field" to one of my Oracle tables. But I noticed that there's no boolean data type in Oracle. Is there a way to simulate it? A friend of mine told me to "Use an enum with the CHECK restraint." Is that the way to go?

    ITKE351,965 pointsBadges:
  • Generating multiple PDF files using Oracle report builder

    I have about 25000 pages in a pdf file. I want to split this into multiple files. Please help me out to generate this using Oracle Report Builder 10g.

    Kumardev15 pointsBadges:
  • How to create a database in Oracle 11g Expressed Edition?

    I recently installed Oracle 11g Expressed Edition onto my Windows 7 PC, along with SQL Developer. I'm trying to create a database with two tables and then use the Developer to insert and query the data. But when I go into Developer, it asks me to create a new connection, meaning that it thinks the...

    ITKE351,965 pointsBadges:
  • Splitting strings into multiple rows in Oracle 10g

    Would anybody know the easiest way to splitting a string, that's comma delimited, into multiple rows in Oracle 10g and 11g? I have this table: Name | Project | Error 108 test Err1, Err2, Err3 109 test2 Err1 And I need it like this: Name | Project | Error 108 Test Err 1 108 Test Err 2 108 Test Err 3...

    ITKE351,965 pointsBadges:
  • Connecting to a Oracle 11 database remotely

    I'm trying to connect to an Oracle 11 database remotely using the following piece of code but I'm unable to do so. But the same code works fine when I connect it to an Oracle 9 database. Am I missing something here? import lotus.domino.*; import java.sql.*; import oracle.jdbc.*; public class...

    ITKE351,965 pointsBadges:
  • How can I connect Oracle Form 10g with Oracle 10g Express Database?

    HOW  I CONNECT ORACLE FORM 10G WITH ORACLE 10G EXPRESS DATABASE .IT GIVES ERROR  TNS 12560 TNS PROTOCOL ERROR

    RAHULDEOLE75 pointsBadges:
  • Getting a ORA-12514 error message: TNS:listener does not currently know of service requested in connect descriptor

    I have an application that's running locally (through Oracle 11g) for the past week and it's been working fine. However, I'm now getting this: ORA-12514 TNS:listener does not currently know of service requested in connect descriptor error. I've already tested the connection with TNSPing which...

    ITKE351,965 pointsBadges:
  • Why can’t I use aliases in GROUP BY clauses in Oracle SQL?

    I'm facing a situation with writing my SQL queries. I've noticed that when writing out the whole column (long case expressions, sum functions with long parameters) instead of creating aliases in GROUP BY expressions just makes the query even longer than it should be. But I don't think Oracle SQL...

    ITKE351,965 pointsBadges:
  • How to use variables in Oracle with SQL Developer

    Here's my situation: I'm able to use variables in SQL Server. Here's an example: DECLARE @EmpIDVar INT SET @EmpIDVar = 1234 SELECT * FROM Employees WHERE EmployeeID = @EmpIDVar But I can't seem to figure out how to do it in Oracle using SQL Developer. How can I do it?

    ITKE351,965 pointsBadges:
  • Should I create a temporary table in Oracle 10?

    I'm pretty new to Oracle but I want to process a large amount of data in stored procedure. I'm already using connection pooling and the application is multi-threaded so I'm wondering if I should use temporary tables. Should I go that route? If so, would there be a way to create the tables in a way...

    ITKE351,965 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?

    ITKE351,965 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!

    ITKE351,965 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?

    ITKE351,965 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') -...

    ITKE351,965 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...

    ITKE351,965 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?

    ITKE351,965 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