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.

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...

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...

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

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...

SELECT COUNT(e.ename), d.dname FROM emp e, dept d
WHERE d.deptno=e.deptno
GROUP BY d.dname HAVING COUNT(e.ename) > 20

It 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);

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.

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...

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...

 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...