Recent posts under tag oracle

+1 vote

1 answer

What is Schema and Schema Objects in Oracle?

posted Jul 1, 2015 by Vidhya Sagar

+1 vote

1 answer

What is the difference between SQL and SQL*PLUS commands?

posted Jun 30, 2015 by Vidhya Sagar

0 votes

1 answer

Oracle: workaround for snapshots on tables with LONG columns?

posted Jun 26, 2015 by Kunal Kapoor

0 votes

1 answer

How does one find the next value of a sequence in Oracle?

posted Jun 26, 2015 by Kunal Kapoor

0 votes

1 answer

How can I change my Oracle password in Oracle8i?

posted Jun 26, 2015 by Kunal Kapoor

+1 vote

1 answer

How can one rename a column in a table in Oracle 8i?

posted Jun 24, 2015 by Archana

+2 votes

1 answer

How can one drop a column from a table in Oracle 8i?

posted Jun 24, 2015 by Archana

0 votes

1 answer

How can one dump/ examine the exact content of a database column?

posted Jun 23, 2015 by Vidhya Sagar

+2 votes

1 answer

How does one implement IF-THEN-ELSE in a select statement?

posted Jun 23, 2015 by Vidhya Sagar

0 votes

1 answer

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

posted Jun 22, 2015 by Suchithra

0 votes

1 answer

Oracle: How does one code a tree-structured query?

posted Jun 22, 2015 by Suchithra

+1 vote

1 answer

Oracle: How does one count/sum RANGES of data values in a column?

posted Jun 19, 2015 by Kunal Kapoor

+2 votes

1 answer

How does one count different data values in a column In Oracle?

posted Jun 19, 2015 by Kunal Kapoor

+1 vote

1 answer

Oracle: How does one add a day/hour/minute/second to a date value?

posted Jun 17, 2015 by Archana

0 votes

1 answer

Oracle: How can I get the time difference between two date columns?

posted Jun 17, 2015 by Archana

0 votes

1 answer

Oracle: How can I generate primary key values for my table?

posted Jun 17, 2015 by Vidhya Sagar

0 votes

1 answer

Oracle: How does one eliminate duplicates rows from a table with different methods?

posted Jun 17, 2015 by Vidhya Sagar

+1 vote

1 answer

How to escape special characters when building SQL queries?

posted Jun 15, 2015 by Suchithra

+1 vote

2 answers

What is SQL and where does it come from?

posted Jun 15, 2015 by Suchithra

0 votes

1 answer

Oracle: How display the names of employees who are working in the company for the past 5 years?

posted Jun 12, 2015 by Kunal Kapoor

+1 vote

1 answer

sql query of EMP table?

posted Jun 12, 2015 by Kunal Kapoor

+3 votes

1 answer

How to display the names of employees in Sql Query?

posted Jun 11, 2015 by Archana

+2 votes

1 answer

How to display names of employees who do not earn any commission in Oracle?

posted Jun 11, 2015 by Viswas Kumar

+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

+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

0 votes

2 answers

How to display the names of all employees who are working in department number 10 in Oracle?

posted Jun 9, 2015 by Vidhya Sagar

+1 vote

1 answer

How to display employee name and annual salary for all employees?

posted Jun 9, 2015 by Suchithra

+1 vote

1 answer

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

posted Jun 9, 2015 by Suchithra

+1 vote

1 answer

How to display name and salary for all employees?

posted Jun 5, 2015 by Kunal Kapoor

+1 vote

1 answer

How to display the name and job for all employees?

posted Jun 5, 2015 by Kunal Kapoor

+1 vote

1 answer

How to display the details of all employees in Oracle?

posted Jun 3, 2015 by Archana

+1 vote

1 answer

How to display the dept information from department table in Oracle?

posted Jun 3, 2015 by Archana

+1 vote

1 answer

How you will avoid your query from using indexes in Oracle?

posted Jun 2, 2015 by Vidhya Sagar

+1 vote

1 answer

Which is more faster - IN or EXISTS In Oracle?

posted Jun 2, 2015 by Vidhya Sagar

+1 vote

2 answers

What is a CO-RELATED SUBQUERY?

posted Jun 1, 2015 by Suchithra

+1 vote

0 answers

Is it possible to write a PL/SQL procedure that takes a table name as input and does something with that table?

posted Jun 1, 2015 by Suchithra

+1 vote

1 answer

How to debug a procedure in oracle?

posted May 31, 2015 by Santosh Kumar Panigrahi

+1 vote

1 answer

Find out nth highest salary from emp table in Oracle?

posted May 29, 2015 by Kunal Kapoor

+1 vote

1 answer

How does one code a matrix report in SQL using SUM & DECODE function?

posted May 29, 2015 by Kunal Kapoor

+1 vote

1 answer

How does one select EVERY Nth row from a table In Oracle?

posted May 28, 2015 by Viswas Kumar

+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

why Oracle’s procedural language is used for?

posted May 26, 2015 by Vidhya Sagar

+1 vote

1 answer

what is distributed database network?

posted May 26, 2015 by Vidhya Sagar

+2 votes

1 answer

Will non-procedural language specify what to do? or not how to do?

posted May 25, 2015 by Suchithra

+3 votes

1 answer

what is relations operator in Oracle?

posted May 25, 2015 by Suchithra

+1 vote

1 answer

which are the tools that allows direct and interactive use of the SQL language to access the Oracle server ?

posted May 22, 2015 by Kunal Kapoor

+1 vote

1 answer

SQL & Pl/SQL are used in which of the following products SQL*plus, Oracle Forms and Oracle reports?

posted May 22, 2015 by Kunal Kapoor

+2 votes

1 answer

Is SQL is Procedural language?

posted May 21, 2015 by Viswas Kumar

0 votes

1 answer

what do you mean by Personal Oracle?

posted May 21, 2015 by Viswas Kumar

+2 votes

1 answer

what is the advantages of partitioning in Oracle?

posted May 20, 2015 by Archana