• 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,795 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,795 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,795 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,795 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,795 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,795 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,795 pointsBadges:
  • Is there a way to make Oracle comparison operators case-insensitive?

    In Oracle, I realize that the default behavior of LIKE and other comparison operators are case-sensitive. Does anyone know if there's a way to make them case-insensitive? Appreciate the help

    ITKE350,795 pointsBadges:
  • How to install Oracle Developer forms 11g R2 and connect the forms and reports to Oracle 9i

    I want to install Oracle Developer forms 11g Release 2 and connect the forms and reports to Oracle 9i Enterprise Edition Release 9.0.1.1.1 – Production. Can you give me the step-by-step to make installation and the connection to my local server in the local network? Best Regards, Jamil...

    MAY0565929271495 pointsBadges:
  • How to select Oracle TOP 10 records

    We have a huge problem with our SQL statement in Oracle. We're trying to select the TOP 10 records that are ordered by STORAGE_DB (which aren't in a list from another SELECT statement). This code works fine for all records: SELECT DISTINCT APP_ID, NAME, STORAGE_GB, HISTORY_CREATED,...

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