• adding partition to existing non-partitioned table

    Hello all! I have a tables without partitions and I now want to partition it. How do I go about this? I tired alter table ... add partition... but it errors with "ORA-14501: object is not partitioned " So I tried to re-create the table with partitions: create table quote_header_test as select *...

    Skovac0 pointsBadges:
  • How to run oracle 10g forms without browser !!

    I'm working on application using oracle 10g forms .. im done with it .. but i wanna run my application .. without the need to run browser with it . Is it possible ??? Please let me know and help me with it .

    Ahmedshahbo15 pointsBadges:
  • Oracle 9i error message in Windows 7: jrew.exe

    while installing oracle9i in laptop i a getting message jrew.exe stopping program(i am using windows 7)

    Sayedtawfik5 pointsBadges:
  • Should I do SAP or Oracle for my education background?

    Hi all, I'm Priyanka persuade betech (ECE), MBA (finance, HR). I'm currently working. I'm interested to learn SAP FICO. Can you please suggest doing SAP is best or Oracle for my education background?

    skpriyanka45 pointsBadges:
  • What is the best career opportunity between SAP and Oracle finance

    What is the best career opportunity in between SAP and Oracle finance? I have four years experience in Investment Banking domain and I'm from a commerce background. Can someone help me to suggest in selecting best career opertunity b/w SAP and Oracle Finance

    pavanmk65 pointsBadges:
  • VB6 with Oracle 10g as database: Using add, edit, delete and search button with following fields: title, author, publisher, year, category

    How can I set up a library system with add, edit delete, search button  with following fields: title, author, publisher, year, category using VB6 and Oracle as database? Thanks

    jeremy275 pointsBadges:
  • Create ER diagram in Oracle SQL Developer

    I'm fairly new to Oracle SQL Developer and I'm trying to create an ER diagram for my database tables. How can I go about this process? Any help would be appreciated.

    ITKE1,051,155 pointsBadges:
  • Making Oracle comparison operators case-insensitive

    For Oracle, is there a way I can make the comparison operators (such as LIKE) case-insensitive? I know the default is case-sensitive but I was hoping I can flip that?

    ITKE1,051,155 pointsBadges:
  • Oracle 10g CONTINUE keyword for T-SQL stored procedure migration

    I'm looking to migrate a T-SQL stored procedure to PL/SQL but I'm constantly running into one particular issue. I noticed that there isn't a CONTINUE keyword for Oracle 10g. Is there a workaround for this? My friend told me to just upgrade but I can't do that right now.

    ITKE1,051,155 pointsBadges:
  • Connect Oracle database from Microsoft Excel application

    Is it possible for me to connect to an Oracle database from a Microsoft Excel application without a DNS? I tried to do it already but it keeps giving me an error saying: The driver was not found. What should I do here? What driver am I supposed to use?

    ITKE1,051,155 pointsBadges:
  • Install Oracle 11g R2 on Ubuntu

    Does anyone know how I can install Oracle 11g R2 on Ubuntu? I'm currently using a 32-bit operating system but this would be for a x86 version. Desktop is 64-bit too. Thanks for the help.

    ITKE1,051,155 pointsBadges:
  • Create first database in Oracle Database 11g Express

    Recently, I installed Oracle Database 11g Express on my Windows 7 machine. Also, I installed Oracle SQL Developer too. Now, I'm looking to create a database with two tables, followed by using SQL Developer to add / query data. But when I opened Developer, it's asking me to make a new connection (I...

    ITKE1,051,155 pointsBadges:
  • Oracle Forms: Making item not visible

    For Oracle Forms, can I make one specific text item not visible? I looked in properties but couldn't find anything. I tried to resize it too but it's still readable. Thank you very much.

    ITKE1,051,155 pointsBadges:
  • Oracle Database 12C on Ubuntu

    Does anyone know how I can install Oracle Database 12c on Ubuntu? I tried but I keep getting errors during the linking phase. Thanks for any help.

    ITKE1,051,155 pointsBadges:
  • List Oracle database links

    Does anyone know if there's a way I could list all of my database links in Oracle? Here's what I have so far (but this is only user tables). select * from user_tables; Thank you!

    ITKE1,051,155 pointsBadges:
  • Name of server my Oracle database is hosted on

    I'm in desperate need here for some help: How can I find the name of the actually server my Oracle database is hosted on? Thank you so much!!

    ITKE1,051,155 pointsBadges:
  • Oracle 10g forms and reports

    When I run an Oracle Report through report builder, the document name in the print job shows the file as .eps . This report is not getting printed from HP 4645 printer, but gets printed from canon, dotmatrix, Line printer and from other HP printers. Are .EPS files are not compatible with certain...

    lacchhii5 pointsBadges:
  • Export Oracle SQL Developer query to CSV file

    I'm currently using Oracle SQL Developer and I need to export one of my queries to a text file. I would like it to be a CSV file. But I'm not seeing any export options at all. Even double clicking on the query itself didn't work. What should I do here?

    ITKE1,051,155 pointsBadges:
  • Confirm what version the Oracle Database is in SQL

    My partner and I are currently creating an installer for a new application. Basically, a user gets to select a data source for their configuration -> nominate what database it is. But here's what we have to do: Basically make sure that the database is Oracle / the version too (this will be done...

    ITKE1,051,155 pointsBadges:
  • Fuzzy Oracle text string search

    When searching a string I need to fetch all the words present in the database from that string. e.g. " Today is very hot day", if I am having (Today/very/very hot/day/etc..) in my database, so this should fetch all the related results to that string.

    shubhanshusriv15 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