Most viewed questions under tag oracle

+1 vote

3 answers

What are the Disadvantages of a CLUSTER?

posted Jul 22, 2015 by Archana

0 votes

1 answer

what is PROFILES and its Option in Oracle Apps?

posted Dec 1, 2015 by Suchithra

+1 vote

2 answers

What is Deadlock in Oracle?

posted Jul 10, 2015 by Kunal Kapoor

+1 vote

2 answers

How to call DDL statements in Oracle PL/SQL

posted Sep 15, 2014 by Suchithra

+1 vote

1 answer

How to add Comments on table and columns in Oracle?

posted May 11, 2015 by Suchithra

+3 votes

1 answer

How to write a query to find the weather string is Palindrome or not?

posted Sep 19, 2014 by Archana

+1 vote

1 answer

What is difference between Cartesian join and cross join?

posted Jul 21, 2016 by Mohammed Hussain

0 votes

1 answer

oracle: How does one code a matrix report in SQL?

posted Jun 22, 2015 by Suchithra

+1 vote

1 answer

how to update table using values of multiple columns from other tables in Oracle SQL

posted Sep 12, 2014 by Archana

+1 vote

1 answer

what is DESCRIPTIVE FLEX FIELDS (DFF) and its types in Oracle Apps?

posted Nov 17, 2015 by Vidhya Sagar

+3 votes

1 answer

Oracle: Give two methods you could use to determine what DDL changes have been made

posted Mar 31, 2015 by Archana

+2 votes

1 answer

What is the Difference between a post query and a pre query?

posted Oct 20, 2014 by Suchithra

0 votes

1 answer

Oracle: Can dual table be deleted, dropped or altered or updated or inserted?

posted Jan 19, 2015 by Archana

+2 votes

1 answer

Oracle: What are the limitations for CHECK constraint?

posted Aug 27, 2015 by Viswas Kumar

+1 vote

1 answer

Oracle: What is difference between SUBSTR and INSTR?

posted Feb 12, 2015 by Kali Mishra

+2 votes

1 answer

what are the constructs of a procedure, function or a package?

posted Dec 4, 2014 by Suchithra

+1 vote

1 answer

How to set the values for existing Profile Options in Oracle Apps?

posted Dec 2, 2015 by Archana

+2 votes

1 answer

Oracle: What view would you use to determine free space in a tablespace?

posted Apr 6, 2015 by Vidhya Sagar

+1 vote

2 answers

What are the advantages of clusters in Oracle?

posted Dec 17, 2014 by Vidhya Sagar

0 votes

0 answers

PL/SQL block which will populate the RESULTS table

posted Jun 27, 2014 by anonymous

+1 vote

1 answer

what are Functions and its type in Oracle apps?

posted Nov 4, 2015 by Archana

+1 vote

1 answer

Oracle: Can a trigger written for a view?

posted Sep 17, 2015 by Viswas Kumar

+1 vote

1 answer

what is Modularity in Oracle?

posted Apr 28, 2015 by Vidhya Sagar

+1 vote

2 answers

Oracle: which of the following is better to find the number of rows in a table?

posted Mar 9, 2015 by Suchithra

+1 vote

1 answer

How does one Loop through tables in Oracle PL/SQL

posted Sep 15, 2014 by Suchithra

+1 vote

1 answer

What are constraining triggers in Oracle?

posted Dec 12, 2014 by Archana

0 votes

1 answer

What is the difference Rename and Alias in context of SQL/Oracle?

posted Jul 29, 2015 by Archana

0 votes

1 answer

what is the Anonymous Block in PL/SQL?

posted Oct 8, 2015 by Viswas Kumar

+3 votes

1 answer

can we register the table with Application Interface (API) in Oracle Apps?

posted Nov 10, 2015 by Vidhya Sagar

+1 vote

1 answer

Importing a stored procedure from oracle to Informatica

posted Mar 5, 2014 by Rohini Agarwal

+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

How does one select the TOP N rows from a table in Oracle?

posted May 28, 2015 by Viswas Kumar

+1 vote

1 answer

how to escape the ampersand character in Oracle PLSQL

posted Sep 12, 2014 by Vidhya Sagar

+1 vote

1 answer

How to display name and salary for all employees?

posted Jun 5, 2015 by Kunal Kapoor

+2 votes

1 answer

Oracle: Which date function returns number value?

posted Mar 17, 2015 by Archana

0 votes

1 answer

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

posted Oct 7, 2015 by Archana

+1 vote

2 answers

how to Alter database archievelog in Oracle?

posted May 5, 2015 by Vidhya Sagar

+1 vote

2 answers

Oracle: What are the various types of RollBack Segments?

posted Dec 29, 2014 by Archana

+1 vote

1 answer

What is meant by Proactive, Retroactive and Simultaneous Update?

posted Jan 30, 2014 by anonymous

+1 vote

1 answer

Explain materialized views and how they are used in Oracle?

posted Mar 26, 2015 by Archana

+3 votes

1 answer

What is the difference between Rollup ad cube?

posted Apr 3, 2015 by Santosh Kumar Panigrahi

+1 vote

1 answer

Oracle: Can you pass parameters in packages? If yes then how?

posted Dec 5, 2014 by Archana

+1 vote

2 answers

what is Value Set in Oracle Apps?

posted Nov 16, 2015 by Suchithra

0 votes

1 answer

Oracle:Can database trigger written on synonym of a table?

posted Jan 12, 2015 by Suchithra

+1 vote

1 answer

When we set the Profile Options at all the 4 level in Oracle Apps?

posted Dec 1, 2015 by Suchithra

+2 votes

1 answer

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

posted Aug 27, 2015 by Viswas Kumar

+3 votes

1 answer

How long will a variable remain defined in Sql Plus?

posted Sep 17, 2014 by Archana

+2 votes

1 answer

How to list the tables from Schema with more than X rows in Oracle PLSQL

posted Sep 15, 2014 by Vidhya Sagar

+1 vote

2 answers

how to get number of rows updated by an UPDATE statement in Oracle PL/SQL

posted Sep 12, 2014 by Archana

0 votes

1 answer

Can Check constraint be used for self referential integrity? if Yes, How? In Oracle

posted Dec 19, 2014 by Suchithra