• Oracle sub query

    I need to display the names of male and female programmers. I have name as a field in the programmer table and now depending on the sex I have to display the names separately. Can you help me out with the query?

    udayasri5 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:
  • Oracle: Update two columns from other table having max date


    235235235250 pointsBadges:
  • Using select statement in an update query of Oracle SQL

    how to update an entire column of an table by an subquery in an update statement.and that subquery is returning multiple rows

    Farhandgr85 pointsBadges:
  • Generate an Oracle query

    How to I generate a query that would display the various job_ids, the sum of salaries, average salaries, minimum salary, maximum salary and the number of people in each job_id?

    berknernice27135 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...

    ITKE440,495 pointsBadges:
  • How to group by alias in Oracle

    How would I be able to "group by" a query using an alias. Something like this: select count(*), (select * from....) as alias_column from table group by alias_column The only thing is that I keep getting this 'alias_column' : INVALID_IDENTIFIER error message. What should I do here?

    ITKE440,495 pointsBadges:
  • How to check if a value is a number in Oracle 10g

    I'm wondering if there's a way to check if a value, from a column in Oracle 10g query, is actually a number so I can compare it. This is what I have so far: select case when ( is_number(myTable.id) and (myTable.id >0) ) then 'Is a number greater than 0' else 'it is not a number' end as valuetype...

    ITKE440,495 pointsBadges:
  • oracle 10g query

    i need sum of income amount from income table and sum of expense amount from expense table to calculate the profit or loss. i have no idea how can i link these two tables.

    Zaman31502110 pointsBadges:
  • Multiple values

    When we have to insert multiple values in a table in one column only, then what's the query?

    ptani10 pointsBadges:
  • Connect to Oracle 10g with VB6 using ADO

    I created a query by using a query builder in Oracle 10g and I want to connect it to VB 6.0 through ADO. What steps should I follow? Please help me out. Thanks!

    Gasper5 pointsBadges:
  • How to sort a resultset from a ‘group by’ statement

    I have written a query like this: select to_char(order_date,'mon-yyyy') "months", sum(nob) "number of bags" from p_in where order_date between '1-apr-11 and '31-mar-12' group by to_char(order_date,'mon-yyyy') The above query returns me a resultset which gives me number of bags sold in every month,...

    hussain22juzer530 pointsBadges:
  • Image in Oracle 8i

    i have connect vb and oracle. i want to store a image in oracle 8i throw vb? plz help me

    Arunraj5 pointsBadges:
  • Running a query in Oracle 10g

    How to rung query in oracle 10 g, if i run query it will be error coming, it will ask connection. can u tell me how connect databse file in sql developer which is install from oracle.com?

    Varsha500950 pointsBadges:
  • Are Oracle direct queries straightforward?

    Hi,  Our company uses an Oracle driven database application (java through internet explorer).  At some point I can get reports in PDF for several predefined reports, but there isn't a way to retrieve the data from Oracle to an Excel spreadsheet, for easier post-processing.  Is there any feasable...

    Acseven30 pointsBadges:
  • COmplex update takes a 90 minutes to run in Oracle

    In the following procedure, the update is taking 90 minutes. The client table has 22 million records, the CPDS table has 40 records. It has been written by someone else, I don't have access to Oracle so can't check my thinking, but I believe, if we select the data to be updated into pl/sql tables,...

    Abhigreen10 pointsBadges:
  • Error with this Oracle 10g Express Edition query

    SET HEADING OFF; SELECT 'Song Name: ', S.TITLE FROM SONG S I don want to display heading in the result table. I need result like: Song Name: Mungaru Male Song Name: Titanic Song Name: Milana But the Statement "SET HEADING OFF;" results in a result

    Prcvjr220 pointsBadges:
  • Can I direct query the Oracle database with SQL Plus?

    I am about to start work on a SAP system which has an underlying Oracle(version 10) database. I would like to know if it straightforward to query the Oracle database directly iusing SQL*Plus for example ?

    Mikecold10 pointsBadges:
  • How does oracle avoid dead lock when I create an index on the foreign key column?

    How does oracle avoid dead lock when we create an idex on the foreign Key column ? Found many experts say this, but i never really found what is the logic behind this. So any replies provided are appreciated . thanks in advance gangadhar

    Gangadhar2610 pointsBadges:
  • Need query to retrieve data from a given date in Oracle 10g

    i have some data to retrive from one table based upon certain condition.when ever i will query to retrive data [strong]it will return all the data based upon the date range.suppose i will enter 22-jul-2010 then the query should return from the year july-2010 to may be 2011 or 2021.upto the last...

    Deb4u50 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.