freshers-oracleapplications.blogspot.com
Sunil Dutt's Oracle Apps Technical World: June 2008
http://freshers-oracleapplications.blogspot.com/2008_06_01_archive.html
Sunil Dutt's Oracle Apps Technical World. This blog is mainly to help Oracle Apps Community, if you have any good content to be posted mail me to sunilsreeduttb@gmail.com so that it can reach to all of us. Wednesday, June 25, 2008. Where do concurrent request logfiles and output files go? The concurrent manager first looks for the environment variable $APPLCSF. If this is set, it creates a path using two other environment variables:. It places log files in $APPLCSF/$APPLLOG. If $APPCPNAM = REQID: o.
freshers-oracleapplications.blogspot.com
Sunil Dutt's Oracle Apps Technical World: January 2009
http://freshers-oracleapplications.blogspot.com/2009_01_01_archive.html
Sunil Dutt's Oracle Apps Technical World. This blog is mainly to help Oracle Apps Community, if you have any good content to be posted mail me to sunilsreeduttb@gmail.com so that it can reach to all of us. Saturday, January 3, 2009. Labor Cost Distribution Program does not pick up items. The costing for employees is based on the business rule that ‘Maximum available hours per person per week unless the total hours that are billable are greater than the available hours’. This implies that ...If an employe...
freshers-oracleapplications.blogspot.com
Sunil Dutt's Oracle Apps Technical World: August 2008
http://freshers-oracleapplications.blogspot.com/2008_08_01_archive.html
Sunil Dutt's Oracle Apps Technical World. This blog is mainly to help Oracle Apps Community, if you have any good content to be posted mail me to sunilsreeduttb@gmail.com so that it can reach to all of us. Thursday, August 28, 2008. Oracle Interview Questions and Answers. Oracle Interview Questions and Answers. 1 To see current user name. Sql show user;. 2 Change SQL prompt name. SQL set sqlprompt “Manimara “. 3 Switch to DOS prompt. 4 How do I eliminate the duplicate rows? Duplicate values field name);.
freshers-oracleapplications.blogspot.com
Sunil Dutt's Oracle Apps Technical World: March 2009
http://freshers-oracleapplications.blogspot.com/2009_03_01_archive.html
Sunil Dutt's Oracle Apps Technical World. This blog is mainly to help Oracle Apps Community, if you have any good content to be posted mail me to sunilsreeduttb@gmail.com so that it can reach to all of us. Monday, March 2, 2009. Oracle Apps WIP KEY Tables. Oracle Apps WIP KEY Tables. WIP TRANSACTIONS stores information about WIP resource transactions. Each row represents a single resource transaction and includes a unique transaction Identifier, a transaction date, the job or repetitive schedule char...
freshers-oracleapplications.blogspot.com
Sunil Dutt's Oracle Apps Technical World: May 2008
http://freshers-oracleapplications.blogspot.com/2008_05_01_archive.html
Sunil Dutt's Oracle Apps Technical World. This blog is mainly to help Oracle Apps Community, if you have any good content to be posted mail me to sunilsreeduttb@gmail.com so that it can reach to all of us. Tuesday, May 6, 2008. DEBUGGING APPLICATIONS WITH SQL*TRACE. I How To Run SQL*Trace and Format the Trace File. This file can later be reviewed to determine:. 183; What SQL statements were executed. 183; How long and how much CPU time did each script take. SQL*Trace may also help identify the SQL script...
freshers-oracleapplications.blogspot.com
Sunil Dutt's Oracle Apps Technical World: September 2008
http://freshers-oracleapplications.blogspot.com/2008_09_01_archive.html
Sunil Dutt's Oracle Apps Technical World. This blog is mainly to help Oracle Apps Community, if you have any good content to be posted mail me to sunilsreeduttb@gmail.com so that it can reach to all of us. Sunday, September 14, 2008. 1 The most important DDL statements in SQL are:. CREATE TABLE - creates a new database table. ALTER TABLE - alters (changes) a database table. DROP TABLE - deletes a database table. TRUNCATE - cleans all data. RENAME- renames a table name. Greater than or equal. UPDATE table...
freshers-oracleapplications.blogspot.com
Sunil Dutt's Oracle Apps Technical World: February 2009
http://freshers-oracleapplications.blogspot.com/2009_02_01_archive.html
Sunil Dutt's Oracle Apps Technical World. This blog is mainly to help Oracle Apps Community, if you have any good content to be posted mail me to sunilsreeduttb@gmail.com so that it can reach to all of us. Sunday, February 22, 2009. Database Security And Admin FAQ's. 97 What is user Account in Oracle database? A user account is not a physical structure in database but it is having important relationship to the objects in the database and will be having certain privileges. System Control: ALTER SYSTEM.
freshers-oracleapplications.blogspot.com
Sunil Dutt's Oracle Apps Technical World: December 2008
http://freshers-oracleapplications.blogspot.com/2008_12_01_archive.html
Sunil Dutt's Oracle Apps Technical World. This blog is mainly to help Oracle Apps Community, if you have any good content to be posted mail me to sunilsreeduttb@gmail.com so that it can reach to all of us. Saturday, December 27, 2008. 1) Display the name of employees along with their annual salary (sal*12) the name of the employee earning highest annual salary should appear first? Select ename, sal, sal*12 "Annual Salary" from EMP order by "Annual Salary" desc;. 8)Display each job along with min of salar...
freshers-oracleapplications.blogspot.com
Sunil Dutt's Oracle Apps Technical World: November 2008
http://freshers-oracleapplications.blogspot.com/2008_11_01_archive.html
Sunil Dutt's Oracle Apps Technical World. This blog is mainly to help Oracle Apps Community, if you have any good content to be posted mail me to sunilsreeduttb@gmail.com so that it can reach to all of us. Tuesday, November 18, 2008. Creates a new record in the current block after the current record. Form Builder then navigates to the new record. Example clear record;. Creates a new record in the current block after the current record. Form Builder then navigates to the new record. Example create record;.