Most viewed questions under tag oracle

0 votes

1 answer

Oracle: What is the difference between a view and a synonym?

posted Jan 13, 2015 by Archana

+2 votes

1 answer

How many minimum groups are required for a matrix report ?

posted Oct 7, 2014 by Suchithra

0 votes

3 answers

How to convert Oracle rows to columns?

posted Aug 21, 2014 by Selvimohana

+3 votes

3 answers

How many columns can table have in Oracle?

posted Oct 21, 2014 by Vidhya Sagar

+2 votes

1 answer

How to display employee number and names for employees who earn commission in Oracle?

posted Jun 11, 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

2 answers

Oracle: What is the significance of the &, and && operators in PL SQL?

posted Dec 24, 2014 by Archana

+1 vote

1 answer

What are the states of a rollback segment? What is the difference between partly available and needs recovery in Oracle?

posted Dec 22, 2014 by Archana

+2 votes

2 answers

How the function security works in Oracle Apps?

posted Nov 24, 2015 by Suchithra

0 votes

1 answer

how to write a query to get the matrix report in Oracle SQL?

posted Sep 22, 2014 by Vidhya Sagar

0 votes

1 answer

What is the difference between PRIVATE AND PUBLIC SYNONYM?

posted Oct 5, 2015 by Suchithra

0 votes

1 answer

Oracle: What is a forward declaration? What is its use?

posted Jan 21, 2015 by Vidhya Sagar

+1 vote

1 answer

what are the Steps required to defining the Calendar in Oracle Apps?

posted Nov 20, 2015 by Kunal Kapoor

+2 votes

1 answer

what is APPCORE.PLL and CUSTOM.PLL in oracle Apps?

posted Nov 18, 2015 by Archana

+3 votes

1 answer

Difference between TRUNCATE, DELETE and DROP commands?

posted Oct 27, 2014 by anonymous

+1 vote

1 answer

How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY?

posted Jul 14, 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

2 answers

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

posted Sep 15, 2015 by Suchithra

+2 votes

1 answer

What is the maximum number of triggers, can apply to a single table in Oracle?

posted Mar 20, 2015 by Archana

+4 votes

1 answer

Name the three major set of files on disk that compose a database in Oracle ?

posted Feb 1, 2014 by Anuj Yadav

+3 votes

1 answer

Oracle: how to display Odd/ Even number of records?

posted Mar 16, 2015 by Archana

+1 vote

1 answer

Oracle: What is the difference between view and table?

posted Sep 15, 2015 by Suchithra

+4 votes

2 answers

Oracle: What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

posted Apr 1, 2015 by Suchithra

+4 votes

2 answers

What is Commit, Rollback and Savepoint in context of SQL/Oracle?

posted Nov 11, 2014 by Archana

+1 vote

2 answers

How to add column in existing oracle table with not null constraint

posted Sep 11, 2014 by Arun Gowda

+2 votes

1 answer

Oracle: Name three advisory statistics you can collect.

posted Mar 25, 2015 by Suchithra

+1 vote

2 answers

What are the disadvantages of clusters in Oracle?

posted Dec 17, 2014 by Vidhya Sagar

+3 votes

1 answer

Explain three different rules that apply to NULLs when doing comparisons?

posted Nov 11, 2014 by Archana

+2 votes

1 answer

What is the difference between static and dynamic LOV?

posted Oct 7, 2014 by Vidhya Sagar

+2 votes

1 answer

How to display the names of all employees working as clerks and drawing a salary more than 3000?

posted Jun 9, 2015 by Vidhya Sagar

+2 votes

1 answer

What are the various types of parameter modes in a procedure in PLSQL ?

posted Dec 1, 2014 by Archana

+1 vote

1 answer

Oracle: A table has the following data : [5, Null, 10]. What will the average function return?

posted Jan 2, 2015 by Suchithra

+2 votes

2 answers

Oracle: How can I retrieve a specified number of highest- or lowest-value columns with a single query?

posted Feb 10, 2015 by Archana

0 votes

1 answer

ORACLE: What is ibot?

posted Aug 9, 2016 by Harsh Mayar

+1 vote

1 answer

Converting the time column SQL server to timestamp column in oracle using Informatica

posted Jun 18, 2014 by anonymous

+1 vote

3 answers

What is the main difference between the IN and EXISTS clause in subqueries?

posted Aug 19, 2014 by Joshva

+2 votes

2 answers

Want to authenticate oracle login using encrypted password…how to?

posted Jul 23, 2013 by Raghvendra Sharma

+1 vote

1 answer

How to display data Page Wise in SQL?

posted Jul 3, 2015 by Kunal Kapoor

+1 vote

1 answer

Is there a limit on the size of a PL/SQL block?

posted Feb 3, 2015 by Suchithra

+1 vote

1 answer

How to display the name and job for all employees?

posted Jun 5, 2015 by Kunal Kapoor

+2 votes

1 answer

Oracle: What is the difference between the SQL*Loader and IMPORT utilities?

posted Apr 13, 2015 by Viswas Kumar

+1 vote

1 answer

What is the difference between oracle fusion and oracle ADF?

posted Apr 15, 2014 by Prasad

+1 vote

1 answer

Display employee number and total salary for each employee in Oracle?

posted Jun 9, 2015 by Suchithra

+3 votes

1 answer

Oracle: You have just compiled a PL/SQL package but got errors, how would you view the errors?

posted Apr 8, 2015 by Kunal Kapoor

+1 vote

1 answer

What is the difference between object-oriented and service-oriented programming?

posted Apr 18, 2015 by Amit Kumar Pandey

0 votes

2 answers

How can I convert the columns into Rows in Oracle?

posted Aug 17, 2014 by Ela

+1 vote

1 answer

Oracle: How would you determine who has added a row to a table?

posted Apr 7, 2015 by Viswas Kumar

0 votes

1 answer

Oracle: What is the difference between alias and synonym?

posted Jan 14, 2015 by Vidhya Sagar

+2 votes

1 answer

what are the Oracle database's physical and logical structure?

posted Jul 7, 2015 by Vidhya Sagar

+2 votes

1 answer

Oracle: What background process refreshes materialized views?

posted Mar 27, 2015 by Suchithra