• Adding a node in Oracle 10g

    How can a third node be added in Oracle 10g standard edition? Server being used is DELL 2850.

    Akansha150 pointsBadges:
  • Export data from Forms to Excel

    How to export the selected data from Forms to Excel?

    Brithivi5 pointsBadges:
  • External Table / SQL Loader

    Hi, We are using this new SQL loader for a month now and it is working fine, but suddenly when we upload new csv files from the client we received this error message when i select the table it gave me this message: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-29400: data cartridge...

    External10 pointsBadges:
  • Following Oracle WebLogic Server as a career

    Would following Oracle WebLogic Server turn into a good career?

    rajeshpvg265 pointsBadges:
  • Calculate time difference with Oracle 9i

    I want to calculate difference between current time and time which is stored in table. How will I calculate the difference between 2 time? After calculating this difference, if this difference is greater than 3 hrs my system should generate an email to technical head. How do I do this? Shall I go...

    Firasha25 pointsBadges:
  • How to install Oracle 7 in Windows XP

    There is an application which runs using oracle 7 and it is running in system which is win NT but now need to run that application in XP which does not have Oracle 7 it has higher version 8.1.7 and 9. Can anybody help me in finding the solution here? How can I install Oracle 7 in there. Thanks

    Pag285 pointsBadges:
  • How can we migrate Oracle database to Microsoft Access?

    How do I migrate an Oracle database to Microsoft Access?

    Vsrameshkumar025 pointsBadges:
  • Oracle Application Freezing up

    Oracle alert log has below error occurring frequently. How to troubleshoot message? Fatal NI connect error 12170. VERSION INFORMATION: TNS for 32-bit Windows: Version 11.1.0.6.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.1.0.6.0 - Production Windows NT TCP/IP NT...

    Cathyhaskins384115 pointsBadges:
  • Discuss the impact of Oracle-Sun with your peers and SearchOracle.com Editors

    Oracle has announced that it has reached an agreement to acquire Sun Microsystems for $7.4 billion. Please use the discussion comments below to discuss the Oracle/Sun deal with fellow members and the SearchOracle.com editors. Please use the Add to Discussion button (not the answer section) to...

    OracleATE190 pointsBadges:
  • Hibernate with clob type

    I am using clob of oracle 10 g in hibernate. When I tried to insert 5000lines of HTML code to the variable in Java, I'm getting the following error; Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes];...

    Arunpmk5 pointsBadges:
  • Getting the number of days between two dates in Oracle 11g

    I've been trying to find the number of days between two different dates in Oracle 11g. Here's what I have so far: select sysdate - to_date('2009-10-01', 'yyyy-mm-dd') from dual But it keeps returning an interval and I can't cast it to an integer too. Any idea what I should do here?

    ITKE350,835 pointsBadges:
  • Getting ORA-00904 error message when writing an inner JOIN query

    I'm pretty new to Oracle and I'm trying to write an inner JOIN query, like this: SELECT Employee.EMPLID as EmpID, Employee.FIRST_NAME AS Name, Team.DEPARTMENT_CODE AS TeamID, Team.Department_Name AS teamname FROM PS_TBL_EMPLOYEE_DETAILS Employee INNER JOIN PS_TBL_DEPARTMENT_DETAILS Team ON...

    ITKE350,835 pointsBadges:
  • How do I create an auto increment on Oracle?

    I've recently realized that there is no concept of AUTO_INCREMENT on Oracle. Would I be able to use "SYS_GUID()" to create an auto increment? Thanks so much.

    ITKE350,835 pointsBadges:
  • How would be my career on Oracle Apps Technical?

    Hi, This is Malleshwar from hyderabad. I'm a graduate in B.com Computers. I'm currently working for Dhanush Infotech for a fleet management project for the past 11 months. I'm planning to get trained in Oracle technology, but I'm a bit confused whether to go with Oracle Apps or Oracle DBA. Please...

    Malleshwar15 pointsBadges:
  • Does Oracle have a full text search service?

    Does anyone know if there's an Oracle equivalent to MS SQL's full text search service? If so, what's been your experience with it? I'm looking to use it for a project I'm working on. Thanks so much.

    ITKE350,835 pointsBadges:
  • How can I write a trigger that fires everyday at night 9′o clock?

    Actually I'm developing a project I want to write a trigger that should fire every day at night 9'o clock and that trigger should copy data from one table to another table.

    gowthamgk85 pointsBadges:
  • Enterprise One end user training

    Does anyone have any Enterprise One training materials?

    SSCTRAINER15 pointsBadges:
  • Is it possible to run a query on two tables in two physical databases using MySQL?

    I understand that an Oracle database allows users to query on several physical databases. Does anyone know if there's a MySQL equivalent? I'm trying to run a query on two tables (which are in two different physical databases). Would it be possible to do this in MySQL?

    ITKE350,835 pointsBadges:
  • Limit the number of rows returned by an Oracle query

    Would there be a way to make an Oracle SQL query behave like it contains a MySQL limit clause? So, for example, here's what I can do in MySQL: select * from sometable order by name limit 20,10 This allows me to get the 21st to the 30th rows (meaning skip the first 20, give the next 10). The rows...

    ITKE350,835 pointsBadges:
  • How to extract a query to a CSV formatted file using SQL Plus

    I'm trying to extract several queries to a CSV output format. The only problem is that I can't use SQL Client or Oracle. I need to use SQL Plus. How can I do it?

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