• 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,945 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?

    ITKE350,945 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...

    ITKE350,945 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,...

    hussain22juzer500 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:
  • 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:
  • SQL or How to find out Oracle COLUMNS containing value

    SQL or How to find out Oracle COLUMNS containing value "0" in a table. Suppose we have 20 columns in a table lets say 'T1' having column like C1, C2, C3, ----- upto C20, and we have to know in how many column zero or any other user specific value is present. Lets say in C1, C5, C7 there is/are zero...

    Maheshmamu20 pointsBadges:
  • hi can anybody tell me how to combine these two queries

    1. SELECT count(*) AS Cnt1 FROM tsau_pre_msges WHERE ( (EXTRACT (DAY FROM Jms_timestamp)-EXTRACT (DAY FROM ins_time))*24*60 + (EXTRACT (HOUR FROM Jms_timestamp)-EXTRACT (HOUR FROM ins_time))*60 + EXTRACT (MINUTE FROM Jms_timestamp)-EXTRACT (MINUTE FROM ins_time) ) BETWEEN 1 AND 5 It will count...

    RizwanSharief30 pointsBadges:
  • Getting the error unable to perform query ora 00904 on an item of previous form which is already deleted.

    using oracle 6i i save as a form to make another one and deleted all the items,triggers and other programme units,lovs from it. I added new items and new data source to its block. But its giving the error unable to perform query ora 00904 on an item of previous form which is already deleted. I have...

    Mariaali10 pointsBadges:
  • how to reference one Oracle 6i rpt param value from another param?

    I am trying to validate that two report parm dates are nomore than 2 years apart, how can I reference the from date while validating the to_date

    Dwatters5 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