• Importing a CSV file to an Oracle table

    We currently have a CSV file that we would like to import into an Oracle table. After it's loaded in, we're going to use the table for another use. Can this be done using SQLPLUS? Thank you very much.

    ITKE350,300 pointsBadges:
  • What’s the easiest way to move data from SQL Server to Oracle?

    I'm an Oracle newbie so I apologize for the general question but what's the easiest way to move a data table from SQL Server to Oracle on a regular basis? My friend told me to SSIS. Is that the best way? Thanks!

    ITKE350,300 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'),...

    ITKE350,300 pointsBadges:
  • Database Oracle

    Hi, how do I create a database in Oracle 9 and link the database in SQL Server 2000

    Berouty3020 pointsBadges:
  • How can I create a user in Oracle 11g?

    I need some help! I'm trying to create a user in Oracle 11g and only grant them the ability to execute one stored procedure, along with the tables in the procedure. Is that possible? If so, what's the process to do it?

    ITKE350,300 pointsBadges:
  • install oracle developer suite 10g in windows

    without oracle database can i install oracle developer suite 10g in windows

    A15 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.

    ITKE350,300 pointsBadges:
  • Apache Maven support for Oracle JDeveloper?

    What options are available for Apache Maven integration with Oracle JDeveloper? Moderator Note: This is a submitted question.

    BrentSheets6,925 pointsBadges:
  • What’s the easiest way to test an Oracle stored procedure?

    We've been working on an ASP.NET project that's using an Oracle database. We've been using TOAD to add and manage stored procedures. This is where the problem lies....we're having too much trouble testing an Oracle stored procedure. Here's an example of one of our stored procedures: CREATE OR...

    ITKE350,300 pointsBadges:
  • Can I load data from a txt file to an Oracle table?

    I'm pretty new to Oracle so I have two big questions: Would there be a way to load data, from a .txt. file, to a table in Oracle not using SQL Loader? Just the opposite...can I unload the data from the table to a .txt file? Thanks so much!

    ITKE350,300 pointsBadges:
  • How to remove duplicate rows from an Oracle table

    I've been doing some testing in Oracle and just populated a table with some sample data. But, by accident, I loaded several duplicate records into as well so I can't create a primary key using some of the columns. Is there a way for me to delete all the duplicate rows and leave just one of them?

    ITKE350,300 pointsBadges:
  • Oracle: How to string to date with milliseconds

    I'm trying to convert the following string to date in Oracle: 2004-09-30 23:53:48,140000000 I've already using this: to_date('#', 'YYYY-MM-DD HH24:MI:SS,FF9') But I keep getting this error message: ORA-01821: date format not recognized. Would anybody have a suggestion on what I should do here?

    ITKE350,300 pointsBadges:
  • How can I resolve the ORA-30926 error in Oracle?

    In Oracle, I keep getting this error message every single time I run a query: ORA-30926: unable to get a stable set of rows in the source tables Here's the query as well: MERGE INTO table_1 a USING (SELECT a.ROWID row_id, 'Y' FROM table_1 a ,table_2 b ,table_3 c WHERE a.mbr = c.mbr AND b.head =...

    ITKE350,300 pointsBadges:
  • Connectivity of Visual Basic 6 and Oracle 10g

    Can you please suggest me the code of how to connect Visual Basic6 and Oracle 10g, I am facing problems while connecting. Please do reply at your earliest. -Supriya

    Umitit45 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#)?

    ITKE350,300 pointsBadges:
  • Error message through Email notification in Oracle Forms

    How do i send error message through Email notification in Oracle Forms?

    Swethareddy8815 pointsBadges:
  • Creating a copy of an Oracle table without the data

    Would it be possible to create a copy of an Oracle table without actually copying the data? I believe I already know the statement: create table xyz_new as select * from xyz; But I think this copies both the structure and the data. I'm just trying to get the structure. Thanks!

    ITKE350,300 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.

    ITKE350,300 pointsBadges:
  • What is RDBMS and ORDBMS?

    What is RDBMS and ORDBMS? I'm preparing for my presentation on Oracle 10g. Can you please help me out?

    momiarain10 pointsBadges:
  • Receiving ORA-00918 error when running SQL query

    In Oracle, I keep getting this ORA-00918 error: Column ambiguously defined when I'm running this SQL query: SELECT * FROM (SELECT DISTINCT(coaches.id), people.*, users.*, coaches.* FROM "COACHES" INNER JOIN people ON people.id = coaches.person_id INNER JOIN users ON coaches.person_id =...

    ITKE350,300 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