• Insert table into existing Oracle column

    I noticed that whenever I try to add an existing to an existing column in Oracle, it's always down at the end of the table. Is there an Oracle command where I can tell it to put it in the table? Thank you.

    ITKE1,011,325 pointsBadges:
  • Compare SQL Server and Oracle databases

    Our department currently has an SQL Server database and Oracle database. One of the tables is labeled 'Inventory' - which has thousands of rows from both databases and it will continue to grow over time. Now, here's what we need to do: We have to compare the Oracle data to the SQL Server data so we...

    ITKE1,011,325 pointsBadges:
  • Create foreign key in Oracle using ON UPDATE CASCADE

    I'm working with both Oracle and SQL Server. And in SQL, I created a foreign key with the ON UPDATE CASCADE option. So basically, whenever I update the column in the primary key - all of the other foreign keys (in tables) will be updated too. But I'm not sure how to do this in Oracle. Can someone...

    ITKE1,011,325 pointsBadges:
  • Check whether Oracle instance has started

    Would there be a view in Oracle so I can see whether an instance has been started with a PFILE or SPFILE file? Thanks so much.

    ITKE1,011,325 pointsBadges:
  • I would like to take a backup of Oracle Database by using unix scripts

    I would like to take a backup of Oracle Database by using Unix scripts. Is it possible? If yes, please provide the details.

    shamcpt5 pointsBadges:
  • Oracle vs Java programming

    Which is better Oracle or Java? I have a interest in programming. What should I learn?

    Linux - Ask the Expert270 pointsBadges:
  • Data migration from SQL Server to Oracle

    For my job, I have to move over data (particularly table data) from SQL Server to Oracle. This usually happens on a weekly basis. What's the best way to do it automatically / repeatedly? Thank you.

    ITKE1,011,325 pointsBadges:
  • Oracle Certification?

    Hi, I want to know, the total procedure for Oracle data base certification. Thanks

    Amin4rmOvexTechnology250 pointsBadges:
  • Connect remote Oracle database through PL/SQL Developer

    We have an Oracle database which connects to a remote IP address. Is there a way we connect to it through PL/SQL Developer? Thank you very much.

    ITKE1,011,325 pointsBadges:
  • Convert hexadecimals to decimals in Oracle SQL

    For Oracle SQL, can I convert hexadecimals to decimals (and possibly back again if need be)? I appreciate the help available.

    ITKE1,011,325 pointsBadges:
  • Can two foreign keys reference the same primary key that is team table and fextures table having team a and team b referencing the team table primary

    Can two foreign keys reference the same primary key on another table. That I have team table attributes (Team_id, Team_name, Team_captain) and fixtures table having this attributes (Fixtures_id, fixture_time, fixture_date, fixture_venue, 1team_id, 2team_id). My question is this: Is it possible for...

    jupake15 pointsBadges:
  • Oracle SQL developer: Set column to auto increment

    Would there be a way for me to set my column to increment automatically using Oracle SQL Developer? Or is this just not possible? I've done with MySQL before but not this way.

    ITKE1,011,325 pointsBadges:
  • Database connectivity from Oracle Forms

    We are having a legacy running running on Oracle Forms and Reports. I want to change the database connection to point to a different database, how do I do that? P.S: I am pretty new to forms and reports

    Ms123115 pointsBadges:
  • Finding size of Oracle database

    We have a database in Oracle that we need to figure out the exact size of (it's currently on our disk). How can we do that? Is there a certain Oracle command? Thanks!

    ITKE1,011,325 pointsBadges:
  • When was a specific Oracle table created?

    For Oracle, can I find out when one specific table was created? Furthermore - how about when a particular row was last updated too? Thanks for the help:

    ITKE1,011,325 pointsBadges:
  • Display all views in Oracle database

    On an Oracle database, can I display all the views that are currently set? Can I do this through SQL Developer?

    ITKE1,011,325 pointsBadges:
  • How can I get the DDL of a column?

    How can I get the DDL of a column? Suppose I declared a column with varchar2(10). So I need to extract that length of varchar i.e 10.

    apsg112905 pointsBadges:
  • WebUtil configuration Oracle forms 11g

    I am trying to configure webutil with Oracle forms 11g. I followed the steps I found online. I have problem with signing jar files on windows but I read that if I am using JRE below JRE 7. I don't need to sign them then when I run the form webutil_demo when I press the client data it raise...

    AyaSaeed5 pointsBadges:
  • Can we find the Oracle queries used by a user on a particular date

    How can we find the list of Oracle queries used by a particular user on a particular date?

    Mridula5 pointsBadges:
  • WebUtil client_ole2 commands in Oracle Forms 10g

    I want to attach a sheet from an excel 2007 datasource to a word 2007 mailmerge using webutil client_ole2 commands in oracle forms 10g

    Petitejean5 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