• 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?

    ITKE434,525 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:
  • What do the quotation marks around the table name do in Oracle?

    In Oracle, I need to know what exactly do the quotation marks around the table name do. I thought it was for some grouping marker but I was doing some debugging on a Hibernate code, I noticed this: SELECT * FROM site WHERE site_id = 3; That works fine but this code doesn't: SELECT * FROM "site"...

    ITKE434,525 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,...

    ITKE434,525 pointsBadges:
  • How to create a command list of values in Oracle

    I've been trying to convert a single-columned subquery into a command-separated VARCHAR typed list of values. I understand how to do it on SQL Server but now I need to do it on Oracle. Can someone help me?

    ITKE434,525 pointsBadges:
  • apex or html.db freeware

    Where can I download Oracle freeware apex or html.db from?

    Bditchbu5 pointsBadges:
  • Installing Oracle on Windows 7

    How to install Oracle in Windows 7 home basic?

    966261873120 pointsBadges:
  • 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.

    ITKE434,525 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!

    ITKE434,525 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?

    ITKE434,525 pointsBadges:
  • install oracle developer suite 10g in windows

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

    A15 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:
  • 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!

    ITKE434,525 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 =...

    ITKE434,525 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#)?

    ITKE434,525 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!

    ITKE434,525 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.

    ITKE434,525 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.

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

Following