• Learn to use SQL queries

    I'm a beginner in computer science so how can I make grip on Oracle SQL Plus. Is there any website or any electronic book that contains preset queries on SQL which can help me in working in SQL. I want a guide book which has queries to start and work in SQL Plus and developer.

    Yasir oracle5 pointsBadges:
  • Duplicate values in an Oracle database

    Is there a SQL statement that would return duplicate values for a given column / count of their occurrences in an Oracle database? Thank you very much.

    ITKE435,850 pointsBadges:
  • How to validate user parameters in Oracle Reports 6i?

    Hi! I am using Oracle reports 6i to modify a standard report. I need to add two user parameters and a field retrieved should be between them if they are not left blank. If they are left blank, then, they should not be taken into consideration. My problem is: These two parameters are included in my...

    Nafy5 pointsBadges:
  • Oracle Development or Oracle JDevelopment?

    Which course is best for my career: Oracle Development or Oracle JDevelopment? Please help me.

    waqar00135 pointsBadges:
  • What is Oracle Sphere?

    I have been tasked to find out about the product Oracle Sphere. What is Oracle Sphere? Is this a combination of products because am unable to find this name on the oracle website. Please advise.

    kabwalya5 pointsBadges:
  • Oracle: Getting list of all tables

    In an Oracle database, is there a query that would display the name of all the tables in it? Thanks so much!

    ITKE435,850 pointsBadges:
  • PL/SQL – How to make a check whether the attribute is positive or zero

    Hi Experts, How to make a check on attribute(NUMBER) is positive or zero?

    Inprise610 pointsBadges:
  • Roadmap for Oracle database

    Hello, Can you tell me where I can the roadmap for Oracle Client and Oracle database? Thank you!

    ablouin5 pointsBadges:
  • Display date in Oracle Toad

    How to display all the months between two dates. My fromdate format is 'mon-yyyy' and todate format is 'dd-mon-yyyy'. Please suggest.

    Deb4u50 pointsBadges:
  • To show two columns using select syntax in Oracle 11g referring another column in same table

    Hi everyone, I really need help on one thing. Suppose I have a table employee and there are many columns and three of them are empno, ename and managerno(of employees) and o want to show results using select syntax and the managerno contains the empno of employees and I want to show ename and (a...

    Pranay9988775 pointsBadges:
  • Best for IT career: Networking and Oracle?

    Which field is best for an IT career: Networking or Oracle?

    waqar00135 pointsBadges:
  • Qui.exe has stopped working

    Qui.exe has stopped working while installing Oracle 10g in Windows 8.1?

    revathy5 pointsBadges:
  • Pl/SQL for all database table relationships

    I need PL/SQL code to list all parent-child relationships of all my database tables. I want to list and table relationships, that is, primary and foreign keys.

    llkhoutx45 pointsBadges:
  • Solution for ORA-6413 error showing connection not open

    Does anyone have a solution for ORA-6413 error: Showing connection is not open. I'm using VB.NET and Oracle 10g.

    Shaz255 pointsBadges:
  • Error occured while accessing the safe array.

    Hi all., I was using HFM 11.1.2.2., when I'm trying to open application, I was getting the following error. Could any one guide me and tell what exactly why this error will occur and how to resolve this? File: CHsvMetadata.cpp Version: 11.1.2.2.500.4569 Line: 750 Error:...

    Kishan34115 pointsBadges:
  • Oracle Taleo: Remove comma separation in numeric field

    How do I remove the comma separation in numeric field?

    Joyceleena10 pointsBadges:
  • Run an Oracle 6i application on Windows

    I have an old software built using oracle 61 forms and odbc:ms-access. Currently it's running on Windows XP. How can I migrate it to Windows 7? I don't have installation disk of Oracle 6i and I'm totally noob to it.

    abhigyan00825 pointsBadges:
  • Advanced Pricing Question in JDE

    I have a pricing question/issue. We have a customer and two of their part numbers interchange to one of our part numbers. We quoted the customer 2 different prices. We don't want to go back and tell the customer we made an error on the pricing. For example customer part number 12345 interchanges to...

    mell4135 pointsBadges:
  • What’s this Oracle substring mean?

    I get this substring from string which is separated by (-) in below string. 911423900006406-417020016-17020016HOS70515010-USPCiTsLaSh003340695 Anyone know what this means?

    anuj2415 pointsBadges:
  • Is it an option to extract data from SAP MM using ETL tools such talend, SSIS or PowerCenter in order to load data into Oracle DW?

    Instead of using BW or Hanna, is it a good alternative to design and populate an Oracle Data Warehouse, using ETL tools such Talend, SSIS or PowerCenter to extract data from SAP Modules? Any suggestion about an outstanding open source solution of query & BI tools to access this Oracle DW?

    MarceloMSP5 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