Tuning SQL query with hierarchy result through DB link
I have the below SQL query: /********************************************************************************************************/ SELECT tm_super.tm_nbr ,tm_super.tm_fname ,tm_super.tm_lname ,tm_super.super_tm_nbr ,tm_super.super_fname ,tm_super.super_lname ,tm_super.super_job FROM (SELECT papftm.employee_number tm_nbr ,paaftm.supervisor_id tm_super_id ,paaftm.person_id tm_person_id ,papftm.first_name tm_fname ,papftm.last_name tm_lname ,papfsuper.employee_number super_tm_nbr ,papfsuper.first_name super_fname ,papfsuper.last_name super_lname ,UPPER(pjsuper.name) super_job FROM per_all_assignments_f paaftm ,per_all_people_f papftm ,per_all_people_f papfsuper ,per_all_assignments_f paafsuper ,per_jobs_v pjsuper WHERE papftm.person_id = paaftm.person_id AND paaftm.supervisor_id = papfsuper.person_id AND [...]

Answer Question   |  August 11, 2009  7:22 AM
DBLink, SQL tuning

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.

Answer Question   |  August 27, 2009  3:51 AM
Oracle 10g, Oracle queries

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.

Answer Question   |  August 7, 2009  8:31 AM
Oracle 10g, Oracle Query

Oracle Reports server
Reports server fails with REP-52266

Answer Question   |  August 7, 2009  1:00 PM
Oracle error messages, Oracle Reports, Oracle Reports Error Messages, Oracle Reports Server, REP-52266

oracle reports 6i – compatibility with windows 2003 64 bit
I have a set of oracle reports duly compiled on oracle reports 6i- working very fine on windows 2003 server with 32 bit architecture. – We have moved to 64 bit architecture to over come the limitation of RAM of 4 gb as we have 16 GB on the server left unrecognized. May any one [...]

Answer Question   |  August 6, 2009  11:57 AM
Backup and recovery software; Windows Server 2003, Oracle 6i, Oracle Reports, Oracle Reports 6i, Windows Server 2003 64 bit

how can we change Oracle text fields in a tabular form to a row and columns
how to convert the oracle text fields into table in an oracle form

Answer Question   |  August 6, 2009  12:20 PM
Oracle Forms, Oracle Tables

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.

Answer Question   |  August 5, 2009  5:37 AM
Oracle 10g, Oracle queries, Oracle Tables

JD Edwards
I’m looking for training materials for Enterprise One.

Answer Question   |  August 4, 2009  4:40 PM
EnterpriseOne, EnterpriseOne Training, JD EDWARDS, JD Edwards EnterpriseOne, JDE

oracle auto star suspection
after i login into oracle at scott user, immediately my own user defined programme like(tamil.sql) will run automatically (like autoexec.bat in dos). what sould do ?

Answer Question   |  August 4, 2009  4:10 PM
Oracle

oracle 10g database migration
Hi Exprts, we migrated a database in terabytes in size in Oracle 10 g using data pump it took 10 hrs for export and 46 hrs to import i am sure this is not the efficient method can you please suggest wat possiblities there to improve the export/import to happen fast for such huge sized [...]

Answer Question   |  August 5, 2009  8:29 AM
Oracle 10g, Oracle administration, Oracle migration

Is there any compatibility in migrating from Delphi 6.0 to Oracle 11g?
When migrating from Delphi 6.0 to Oracle 11g, are there any compatibility? If yes, what are they?

Answer Question   |  August 16, 2011  1:01 PM
Delphi, Delphi 6.0, Delphi 6.0 to Oracle 11g Migration, Delphi to Oracle Migration, Oracle 11g

Oracle Developer problem
how to connect developer 2000 form 5,6,6ior 10g from oracle database in NT 2000 o/s?

Answer Question   |  August 3, 2009  10:00 AM
NT 2000, Oracle 10g, Oracle Developer, Oracle Developer 2000

Store .wav file in a oracle db
I want a java program to store a .wav file to be stored in oracle. I know that we use blob, but my problem is I want to know the things to do in between upload and the insert statment used to store in the db

Answer Question   |  August 10, 2009  1:59 PM
Java, Java programming, Oracle Database

Oracle Net8 Assistant – jrew.exe needs to close and has encountered errors”
When I try to start Net8 assitant nothing happens oor I get an error msg “jre.exe or jrew.exe needs to close and has encountered errors”. Any help will be appreciated. thanks in Advance

Answer Question   |  August 4, 2009  10:05 AM
Net8 Assistant, Oracle 6i, Oracle 6i runtime installation, Oracle error messages

Oracle Forms 6i – “when timer expired”
i dont know the logic of “When Timer Expired” trigger in forms 6i. Someone plz explain it with example.

Answer Question   |  February 7, 2012  3:48 AM
Oracle 6i, Oracle Forms, Oracle Forms 6i, When Timer Expired Trigger

UPK scripts/Excel Scripts and HP Quality Center
How time consuming is it to convert UPK Scripts into HP Quality Center and set them up for automated testing? What about test scripts in excel

Answer Question   |  August 3, 2009  8:25 PM
Automated Testing, Excel Scripts, HP Quality, Microsoft Excel, UPK

64bit client to 32bit database
I have a 64bit client that is trying to connect to my oracle database which is a 32 bit machine is this possible? they have tryed to use the 32bit client software on the 64bit machine is this the problem? Is there 62client software for oracle 9i? really need your help on this one thanks

Answer Question   |  July 30, 2009  4:55 PM
32-bit, 64-bit, Oracle 9i, Oracle Database

Oracle – EBS
Best way to load an Oracle EBS database with Mainframe data?

Answer Question   |  July 30, 2009  3:37 PM
Orace database load, Oracle EBS

Cannot fetch rows with float values under Oracle 10g
We are currently porting applications from a DEC Unix environment to Solaris. Our previous Oracle version was 8i and we are now using 10g on the Solaris system. We have several tables and are able to insert and fetch from all excpet one of the defined tables. The one table causing the issue contains a [...]

Answer Question   |  July 31, 2009  3:10 PM
float values, OCIStmtExecute, Oracle 10g, Oracle Fetch Rows

Oracle implentation wizard
hi, pls provide me dummy oracle implentation wizard. SOP and finnace and SCM modules mail address- buxiin@gmail.com

Answer Question   |  July 30, 2009  12:19 PM
Oracle applications, Oracle Financials, Oracle Implementation Wizard, Oracle SCM