Recent posts under tag sql

+1 vote

Associate Analyst at Master Card

posted Oct 16, 2014 by anonymous

+2 votes

1 answer

What are Codd Rules in Oracle?

posted Oct 16, 2014 by Vidhya Sagar

+1 vote

1 answer

What are mutating tables in Oracle?

posted Oct 16, 2014 by Archana

+1 vote

1 answer

What is the difference between deleting and truncating of tables in Oracle?

posted Oct 15, 2014 by Suchithra

+1 vote

1 answer

What is a 2 Phase Commit in Oracle?

posted Oct 15, 2014 by Suchithra

+2 votes

1 answer

What is Row Chaining in Oracle?

posted Oct 14, 2014 by Suchithra

+3 votes

1 answer

what is Physical Storage of the Data in Oracle?

posted Oct 14, 2014 by Archana

+2 votes

1 answer

Table Space, Data Files, Parameter File, Control Files in Oracle?

posted Oct 13, 2014 by Suchithra

+4 votes

1 answer

What are the Pct Free and Pct Used in Oracle?

posted Oct 13, 2014 by Vidhya Sagar

+1 vote

Retrieve values from one database server and store them in other database server using PHP

posted Oct 11, 2014 by Vrije Mani Upadhyay

+5 votes

1 answer

what are Privileges and Grants in Oracle ??

posted Oct 10, 2014 by Archana

+3 votes

1 answer

What is concurrency in oracle?

posted Oct 9, 2014 by Vidhya Sagar

+2 votes

2 answers

What is the difference between candidate key, unique key and primary key in Oracle?

posted Oct 9, 2014 by Suchithra

+2 votes

1 answer

What are the OOPS concepts in Oracle?

posted Oct 8, 2014 by Vidhya Sagar

+1 vote

1 answer

What are snap shots and views?

posted Oct 8, 2014 by Suchithra

+1 vote

2 answers

In SQL how to INSERT, UPDATE or DELETE record in one statement

posted Oct 7, 2014 by Amit Kumar Pandey

+2 votes

2 answers

How to insert more than one record using a single insert statement?

posted Oct 7, 2014 by Amit Kumar Pandey

+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 many minimum groups are required for a matrix report ?

posted Oct 7, 2014 by Suchithra

+3 votes

1 answer

Search Informatica for text in SQL override

posted Oct 7, 2014 by Amit Sharma

+1 vote

Database Normalization: Database Normalization in PHP/MySQL/SQL

posted Oct 6, 2014 by Vrije Mani Upadhyay

+1 vote

1 answer

How we can create folders in SQLReport server dynamically?

posted Oct 3, 2014 by Amit Kumar Pandey

+1 vote

1 answer

How we can use double quotes in dynamic SQL statements?

posted Oct 3, 2014 by Amit Kumar Pandey

+1 vote

1 answer

What are the various types of Indexes in SQL/MySQL?

posted Sep 28, 2014 by anonymous

+1 vote

1 answer

What are the types of Locks in Oracle SQL?

posted Sep 26, 2014 by Vidhya Sagar

+1 vote

1 answer

What is database link in Oracle SQL?

posted Sep 26, 2014 by Vidhya Sagar

+1 vote

1 answer

How to change Line Size and Page Size and SQL Prompt?

posted Sep 24, 2014 by Archana

+1 vote

1 answer

What is the difference between SQL and SQL*PLUS?

posted Sep 24, 2014 by Archana

0 votes

1 answer

How to create a complex view?

posted Sep 23, 2014 by Archana

+2 votes

1 answer

How to update or insert row using single condition?

posted Sep 23, 2014 by Archana

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

2 answers

how to write a query to select Nth row from a table in Oracle SQL?

posted Sep 22, 2014 by Archana

+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

2 answers

query to get calender in Oracle SQL

posted Sep 19, 2014 by Archana

+3 votes

1 answer

How long will a variable remain defined in Sql Plus?

posted Sep 17, 2014 by Archana

+2 votes

2 answers

how to write a query that results an pyramid structure in Oracle SQL

posted Sep 16, 2014 by Archana

+3 votes

1 answer

How to send data into file.txt from the database using W mode Oracle PLSQL

posted Sep 15, 2014 by Suchithra

+1 vote

2 answers

How to call DDL statements in Oracle PL/SQL

posted Sep 15, 2014 by Suchithra

+1 vote

1 answer

How does one Loop through tables in Oracle PL/SQL

posted Sep 15, 2014 by Suchithra

+1 vote

2 answers

How to check the Leap Year using Function in Oracle SQL

posted Sep 15, 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

Sr. Java Developers at L & T Infotech

posted Sep 15, 2014 by anonymous

+2 votes

1 answer

How to import data from file into database?

posted Sep 15, 2014 by Arun Gowda

+3 votes

1 answer

what are the SQL REPORTING COMMANDS in Oracle sql

posted Sep 15, 2014 by Arun Gowda

+2 votes

2 answers

What are the different types of JOINS in SQL and MYSQL?

posted Sep 14, 2014 by Nimish

0 votes

1 answer

What are the types of SQL GROUP BY Clause?

posted Sep 14, 2014 by Nimish

+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 update table using values of multiple columns from other tables in Oracle SQL

posted Sep 12, 2014 by Archana

+2 votes

1 answer

can we update the ROWID in the oracle table

posted Sep 11, 2014 by Arun Gowda

+1 vote

2 answers

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

posted Sep 11, 2014 by Arun Gowda