Revenue recognition master program PL/SQL stored procedure on daily basis. Need help!! How can I do that. What are the consequences of changing the master program. How can I change it so the revenue is...
Difference between view and table
In view also update, delete, insert fuctions possible only if it satisfies view condition.
View is a virtual table which do not have any physical existence but table is stored in the database. Tables have physical existence. Views are associated with tables.
What is autonomous transaction? Where are they used?
An autonomous transaction is a transaction that is started within the context of another transaction, called the parent transaction, but is independent of it.An autonomous transaction can be committed...
A autonomous transaction starts with the first sql statement of the pl/sql block and ends with a commit. It starts within the context of an another transaction called parent transaction and independen...
Can someone give an example of loading data from a control file for AR lockbox.
What is the difference between in, out, inout parameters. Can we pass value or reference or both to the in out parameter.
Here is the answer in 1 lineIN-- value is used in a program. It cannot be a variable .COuld be literal,expression,value .OUT-- value is returned back from the progr...
hi friends,To make it simple, keep in mind,IN : It is a CONSTANT in the sub-program and u can not modify its value in sub- program. if its value is modified in the s...
How do we restrict the insert/ updates on the foreign column in a table if that table is in different instance that the table with primary key. Say for example emp and dept table. We have deptno in both...
see if you want totally restric insert and update create a view with required columns and give it to them. dont forget to readonly while creating the view.
We can do using databasename.tablename
In the real world, where do we use savepoint command.
nice reply sir
good question.remember... you are doing huge work. means assume that you have execute 100 queties. ok . you already finished 50 queries. after executing the 51 query you thaught there is a mistic. wha...
SQL queries- say for eg.Two tables - emp and deptemp tables consist of empno, deptno, mgrid, empname, locationdept table consist of deptno, deptname.1. Write a query to select department name for which...
SELECT COUNT(e.ename), d.dname FROM emp e, dept d WHERE d.deptno=e.deptnoGROUP BY d.dname HAVING COUNT(e.ename) > 20It is the same...only diff is...use "dname" in group by clause , not "deptno"Thanks
select e.empno "Subordinate",e.ename "Emp Name",e.mgrID "ManagerID",m.ename "Manager Name",m.empno "Employee Number" from emp e JOIN emp m where (e.mgrid=m.empno);
What are the advantages and disadvantages of view?
Advantages of views:
1. View the data without storing the data into the object.
2. Restict the view of a table i.e. can hide some of columns in the tables.
3. Join two or more tables and show it as one object to user.
4. Restict the access of a table so that nobody can insert the rows into the table.
1. Can not use DML operations on this.
2. When table is dropped view becomes inactive.. it depends on the table objects.
3. It is an object, so it occupies space.
Pls. add , if I miss any of them.
View when called always contacts the base table, on which it is built to get the data .so it always goes to the server thats why it degrades the performance of the server.
DML operation can performed on views.
How can we tell the difference between seeded tables, static tables and the main transaction tables?
You can tell based on the TABLESPACE the table belongs to - this is the new Oracle Applications Tablespace Model (OATM)Run the following code to see:SELECT tablespace_name, table_nameFROM all_tablesWH...
Hi Seeded Tables - Fnd_table name are the seeded tables in apps Static Tables - Static tables are one that are updated using some scripts or triggers.Transactions tables - Tables that link the trasact...
Is the accounting entry different for credit card transactions or normal invoice - payment transactions. If so, how?
When you complete an invoice schedules are created in ar payments schedules all and the transaction distributions are elgible to send to GL
A credit card order is same as any other order for accounting. i.e. DR Rec CR RevBut the receipt process can be different depending on ur clients requirements to categorize remitted receipts and clear...
What are the setup steps to setup credit card transactions?
Hi, For the setup of Credit Cards, we have to initally set Credit Card Programs and Code Sets Window. We are setting credit card programs for our enterprise's credit card and procure...
How do we change a custom API to include business needs?
How to handle academic gap while applying for a job?
What will you do when you are not able to get your message across to your audience?
Has there been a time when you were presented a problem and solved it?
How productive are you?
Have you experienced being given too many tasks?
Do you find yourself busy most of the time? Why?
BPO Career for BTech Graduates
Describe a time when you had to convince a friend ?
What are the career opportunities available for MCA Graduates?
What do you think about our company?
Ask Interview Question?
Have Career Question?
Ask Only Career questions.