1 - 12 of 12
PREVIOUS 1 NEXT
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.
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.
110 pts.
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.
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.
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...
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...
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?
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?
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?...
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?...
Need help with Oracle query
how to display the third highest salary from an employees table thanks in advance
how to display the third highest salary from an employees table thanks in advance
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...
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...
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...
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...
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 ?
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 ?
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?
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?
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...
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...
1 - 12 of 12
PREVIOUS 1 NEXT
