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
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
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
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
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 to convert the oracle text fields into table in an oracle form
Answer Question | August 6, 2009 12:20 PM
Oracle Forms, Oracle Tables
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
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
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
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
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
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
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
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
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
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
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
Best way to load an Oracle EBS database with Mainframe data?
Answer Question | July 30, 2009 3:37 PM
Orace database load, Oracle EBS
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
hi, pls provide me dummy oracle implentation wizard. SOP and finnace and SCM modules mail address- email@example.com
Answer Question | July 30, 2009 12:19 PM
Oracle applications, Oracle Financials, Oracle Implementation Wizard, Oracle SCM