1
  • Running a query on both SQL Server and Oracle databases

    How do I run a query that queries a SQL Server database and an Oracle server database, on two different servers, and uses all the data?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Bulk Collect vs Cursor in Oracle

    Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create Cursor for this work table and...

    Nikhildhar35 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:
  • 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:
  • oracle 10g query

    attributes of income table are(id,date,income_amount) and of expense table are(expid, expdate,exp_amount,paid,unpaid).i need sum of "income_amount" and sum of "paid" to calculate the profit or loss.

    Zaman31502110 pointsBadges:
  • Oracle 10g Query

    i made two tables in oralce10g,income and expense they have no relation with each other plz tell me a query how can i get the data from these tables with one query.

    Zaman31502110 pointsBadges:
  • Need help with this Oracle Query

    BPC_APPLICATIONS_TRANSACTIONS (Table) Application_no,Transaction_no,Transaction_date Step_id Dept_code Decision 20090045 1 01/14/2009 10:07:17 1 001 0 20090045 2 01/14/2009 10:07:17 70 007 0 20090045 3 01/14/2009 10:08:57 1 001 0 20090045 4 01/14/2009 10:08:57 60 006 0 20090045 5 01/14/2009...

    FidanSheza10 pointsBadges:
  • Query to find Oracle memory space

    how to find out the memmory space in oracle using queries?

    Kaninfoway15 pointsBadges:
  • Looping Queries in Oracle using data from SQL Server

    I have a table of entries from SQL server called PID. Each of this entry should follow the following select * from HR.TABLES a START WITH a.SID = '0' CONNECT BY PRIOR a.parentid = a.sid' Where I have '0' in the query above, should take all the values from PID. Is there a easy way to write this? or...

    Sreedhar775 pointsBadges:
  • Need help with Oracle query

    how to display the third highest salary from an employees table thanks in advance

    Xaviervicky30 pointsBadges:
  • Search for a keyword in all columns of all database tables

    Dear Team, i have an requirement that : i want to search all the columns of all the tables in the particular database based on the specific key word or an free text. example : table 1: columns data empname sam empid 01 table 2 columns data deptname sam departmentid 10 table 3 columns data...

    Abdulgani5 pointsBadges:
  • Pull all data (no of datas 7500) from Oracle at a time

    i am trying to pull all data (7500)form oracle but it gives me only 2313 data at a time.So how i can pull all data at a time ?

    ajitnarayan35 pointsBadges:
  • How do you display the number of rows selected if there are only 4 or 5 rows there?

    when i have 6 values for any column, in select statement i get display of 6 rows selected while if i have 5 values for one column i don't get display of 5 rows selected, how to get that display?

    Minky795 pointsBadges:
  • batch queries in oracle

    We are developing a .NET web application and have decided to use CSLA as our business architecture framework. Because CSLA is based on Microsoft technology, it is designed to work with MS sql. Much of the framework uses batch queries to grab multiple result sets in one query but it appears that...

    Dhworth5 pointsBadges:
1

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