Recent posts under tag oracle

0 votes

1 answer

what is DATA MODEL in Oracle Apps?

posted Oct 30, 2015 by Kunal Kapoor

+1 vote

1 answer

What is Oracle Applications?

posted Oct 30, 2015 by Kunal Kapoor

+2 votes

1 answer

how to Create a User in oracle apps?

posted Oct 28, 2015 by Archana

+2 votes

1 answer

what is the File Architecture Oracle Apps?

posted Oct 28, 2015 by Archana

+2 votes

1 answer

What is difference between Index Seek vs. Index Scan?

posted Oct 27, 2015 by Shivaranjini

+2 votes

1 answer

What is use of EXCEPT clause? How it differs from NOT IN clause?

posted Oct 27, 2015 by Shivaranjini

+3 votes

1 answer

what are the steps to Register a Report in oracle Apps?

posted Oct 27, 2015 by Vidhya Sagar

+2 votes

1 answer

what are the Types of Docs in Oracle Apps?

posted Oct 27, 2015 by Vidhya Sagar

+3 votes

1 answer

In what order should a open/fetch/loop ...... %NOTFOUND cursor variable in the exit when statement? Why?

posted Oct 22, 2015 by Shivaranjini

+3 votes

1 answer

What is the use of %ROWTYPE and %TYPE in PL/SQL?

posted Oct 22, 2015 by Shivaranjini

+3 votes

1 answer

What is a mutating table error and how can you get around it?

posted Oct 22, 2015 by Shivaranjini

+1 vote

1 answer

what is AIM in oracleapps?

posted Oct 12, 2015 by Suchithra

+1 vote

1 answer

what is ERP ? what are its Purpose?

posted Oct 12, 2015 by Suchithra

+3 votes

1 answer

what are Package Specifications in plsql?

posted Oct 9, 2015 by Kunal Kapoor

+2 votes

1 answer

what are the Predefined Exceptions in plsql?

posted Oct 9, 2015 by Kunal Kapoor

+1 vote

1 answer

what are the Processing Explicit Cursors in plsql?

posted Oct 8, 2015 by Viswas Kumar

0 votes

1 answer

what is the Anonymous Block in PL/SQL?

posted Oct 8, 2015 by Viswas Kumar

0 votes

1 answer

What is SQL Trace and what are the steps for generating Trace file?

posted Oct 7, 2015 by Archana

0 votes

1 answer

what is the PRODUCT DIRECTORY STRUCTURE in oracle Apps?

posted Oct 6, 2015 by Vidhya Sagar

0 votes

1 answer

Can database trigger written on synonym of a table?

posted Oct 6, 2015 by Vidhya Sagar

+1 vote

1 answer

If we delete the base table whether the synonym will exists or not?

posted Oct 5, 2015 by Suchithra

0 votes

1 answer

What is the difference between PRIVATE AND PUBLIC SYNONYM?

posted Oct 5, 2015 by Suchithra

+1 vote

1 answer

Oracle: What is a SYNONYM?

posted Sep 24, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What is the difference between view and Snapshot?

posted Sep 24, 2015 by Viswas Kumar

+2 votes

1 answer

Oracle: What is the difference between snap shots and materialized views?

posted Sep 18, 2015 by Kunal Kapoor

+1 vote

1 answer

Oracle: What is a SNAPSHOT?

posted Sep 18, 2015 by Kunal Kapoor

+1 vote

1 answer

Oracle: Can we create index on view?

posted Sep 17, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: Can a trigger written for a view?

posted Sep 17, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What is the difference between view and table?

posted Sep 15, 2015 by Suchithra

0 votes

2 answers

Oracle: What is the difference between a View and Materialized View?

posted Sep 15, 2015 by Suchithra

+1 vote

1 answer

What is the function of 'force' in view?

posted Sep 10, 2015 by Viswas Kumar

0 votes

1 answer

If a View on a single base table is manipulated will the changes be reflected on the base table?

posted Sep 10, 2015 by Viswas Kumar

0 votes

1 answer

Oracle: Can a view be updated/inserted/deleted?

posted Sep 9, 2015 by Archana

0 votes

1 answer

Oracle: How can you find out View is updatable or not?

posted Sep 9, 2015 by Archana

+1 vote

1 answer

Oracle: How to update COMPLEX VIEW?

posted Sep 8, 2015 by Vidhya Sagar

+1 vote

1 answer

Oracle: What is the difference between SIMPLE and COMPLEX VIEWS?

posted Sep 8, 2015 by Vidhya Sagar

+1 vote

1 answer

Oracle: What are the advantages of VIEW?

posted Sep 7, 2015 by Suchithra

0 votes

1 answer

Oracle: What is a view?

posted Sep 7, 2015 by Suchithra

0 votes

1 answer

Oracle: Consider a sequence whose currval is 1?

posted Sep 3, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What are CYCLE/NO CYCLE in a sequence?

posted Sep 3, 2015 by Viswas Kumar

0 votes

1 answer

oracle: What are the parameters in SEQUENCE?

posted Sep 1, 2015 by Vidhya Sagar

0 votes

1 answer

Oracle: What is a sequence?

posted Sep 1, 2015 by Vidhya Sagar

+1 vote

1 answer

What is the fastest way of accessing a row in a table?

posted Aug 31, 2015 by Suchithra

0 votes

1 answer

Oracle: What are the pre-requisites to (i) modify data type of a column (ii) add a column with NOT NULL constraint?

posted Aug 31, 2015 by Suchithra

+2 votes

1 answer

Oracle: What are the limitations for CHECK constraint?

posted Aug 27, 2015 by Viswas Kumar

+2 votes

1 answer

ORACLE: What is created implicitly for every UNIQUE and PRIMARY KEY column?

posted Aug 27, 2015 by Viswas Kumar

+2 votes

2 answers

Oracle: If a unique key constraint on DATE column is created, will it validate the rows that are inserted with sysdate?

posted Aug 21, 2015 by Kunal Kapoor

+2 votes

1 answer

Oracle: Where the integrity constraints are stored in Data Dictionary?

posted Aug 21, 2015 by Kunal Kapoor

+1 vote

1 answer

Oracle: What is ON DELETE CASCADE?

posted Aug 20, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What is a CONSTRAINT? What are its various levels?

posted Aug 20, 2015 by Viswas Kumar