Amit

• Aug 28th, 2016

Adding 2 cents 1) DELETE is DML command because it does not change data dictionary (Every command which changes data dictionary tables is called DDL command ) TRUNCATE is DDL command is changes stor...

Ashakant Kendre

• May 9th, 2016

1>TRUNCATE is a DDL command whereas DELETE is a DML command. 2>TRUNCATE is much faster than DELETE. Reason: When you type DELETE. All the data get copied into the Rollback Tablespace first, then del...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

letsconverse  

 Profile Answers by letsconverse Questions by letsconverse

• Member Since Sep-2009 | Sep 21st, 2009

---

This one is better I guess:

query:

SELECT ((count(DECODE(to_char(hire_date,'YYYY'), 1995, 'c1')) )+(count(DECODE(to_char(hire_date,'YYYY'), 1996, 'c2')))+(count(DECODE(to_char(hire_date,'YYYY'), 1997, 'c3')))+(count(DECODE(to_char(hire_date,'YYYY'), 1998, 'c4')))) as TOTAL,
count(DECODE(to_char(hire_date,'YYYY'), 1995, 'c1')) "1995",
count(DECODE(to_char(hire_date,'YYYY'), 1996, 'c2')) "1996",
count(DECODE(to_char(hire_date,'YYYY'), 1997, 'c3')) "1997",
count(DECODE(to_char(hire_date,'YYYY'), 1998, 'c4')) "1998"
FROM employees;

Results for the above query is like:

     TOTAL       1995       1996       1997       1998
  ----------   ----------   ----------  ----------  ----------
          65             4            10           28           23

Revert if you have a question. I'll try.
NOTE: You may want to change the spl characters and the years based on your requiremnet.

Thanks

serine

• Aug 26th, 2016

Why did we use c1?

ashwini

• Jun 22nd, 2015

Can anybody tell me how to get the count of the test cases that was run by a person?

Improve Answer

amir ali

• Nov 23rd, 2015

Views are dependent on data tables.

PADMINI M

• Nov 16th, 2015

Correct answer is it depends.
Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table
Only we can update a view in one base table.

Answer Question  Select Best Answer

Why session is created ?
How is it related to security concern for the application?
Why session ID is created ?

Gaurav.khurana

 Profile Answers by Gaurav.khurana Questions by Gaurav.khurana

• May 9th, 2015

Its like to maintain some information during a particular conversation. Suppose you open gmail so some information has to be maintain during the whole conversation with server from browser(client) ..
So that information is stored somewhere till the time you logout.(example)

abha maurya

• Apr 18th, 2015

Session creation ?is very important for security purpose....suppose various people on the same website trying to fill form so how does server understand the request of diff. Users that's why we use s...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

opbang  

 Profile Answers by opbang Questions by opbang

• Member Since Mar-2006 | Sep 24th, 2006

---

Transaction Database Vs DataWarehouse Database-

1. Transaction Database is Relational Database with the normalised table, whereas DataWarehouse is with denormalised Table.

2. Transaction Database is highly volatile... Designed to maintain transaction of the business Where DataWarehouse is non volatile.. with periodic updates.

3. Transaction Database is OLTP...   Datawarehouse ... is for analysis... 

4. Transaction Database is functional data...  DataWarehouse database Data is subject oriented.

kalai

• Jan 29th, 2014

Transactional database means current data in database.
data warehouse means historical data.i.e old data that are flushed out.

sreenivas

• Nov 25th, 2012

A transactional database is defined for day-to-day operations like insert, delete and update and in a Datawarehouse databases (OLAP databases) are designed for Analytical purpose. So they require historical data for analysis. These databases are huge databases to store historical data.

Improve Answer

Read Best Answer

Editorial / Best Answer

Answered by: NITIN TOMER

• Sep 6th, 2011

---

sql is a structured query language........and t-sql is implementing on sql server........and t-sql having some more queries than sql .

kandriga murali

• Dec 8th, 2013

1) .SQL is non-procedural language since it deals with what data to be extracted.Whereas T-SQL is procedure language since it deals with what data to be executed and how it should be displayed.
2) . SQL can executed only single command whereas T-SQL can executed multiple statement at time.

Syed Umar Abbas

• Mar 28th, 2012

Microsoft SQL Server have some more additions to Database Standard Query Language (SQL) is called T-SQL

Improve Answer

Sheraz Baig

• Nov 22nd, 2013

GUI based

manishayadav_1

 Profile Answers by manishayadav_1 Questions by manishayadav_1

• Apr 9th, 2008

menu-driven

Answer Question  Select Best Answer

How does Export/Import feature differ from that of SQL Loader?

Sheraz Baig

• Nov 21st, 2013

Totally different Export/Import are oracle utilities to export data in the oracle format and to import the data which is been exported so the format will be the oracle one. While SQL Loader is the u...

dhiren21

 Profile Answers by dhiren21 Questions by dhiren21

• Sep 20th, 2009

Its Different.. For Export we are exporing the data from the Database to a Dump file..i.e EXP from user datafile buffer rows compress etcfor Imprting we are importing the data from a dump file to a da...

Answer Question  Select Best Answer

How to display nth lowest record in a table for example? How to display 4th lowest (salary) record from customer table?

Read Best Answer

Editorial / Best Answer

Answered by: Yadnesh

• Jun 1st, 2013

---

-- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we can obtain derived column using DENSE_RANK() in a subquery and -- obtain temporary result set and finding nth record in a temporary result set using WHERE clause -- for the given example, following is the solution.

Code
 

Yadnesh

• Jun 1st, 2013

-- First of all Customers table wont have salary attribute. we need to use employees/employeesSalary table -- where we can find salary attribute. -- for finding nth lowest salary record we can obtai...

Improve Answer

Read Best Answer

Editorial / Best Answer

daniel.doboseru  

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Member Since Feb-2013 | Feb 6th, 2013

---

An ontology refers to a model that contains a set of classes (individuals) plus a set of relations between them. Lets consider a relational database model, having three tables: Human, Man, Woman. As you can observe, there is no relation defined between them. Well, in an ontology, besides that, you might also have a set of rules like: - Object X is Man, if and only if is Human, but is not Woman. - If object X is Human, then it is either Man or Woman, but not both. For defining ontologies there are several languages developed, the most representative being OWL (Web Ontology Language. And for querying them one must also use a specialized language (eg. SPARQL).

daniel.doboseru

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Feb 6th, 2013

An ontology refers to a model that contains a set of classes (individuals) plus a set of relations between them. Lets consider a relational database model, having three tables: Human, Man, Woman. As ...

Improve Answer

Multiset table with UPI will allow duplicates or not?

Read Best Answer

Editorial / Best Answer

daniel.doboseru  

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Member Since Feb-2013 | Feb 6th, 2013

---

UPI stands for Unique Primary Key, which constrain us to have unique keys, thus unique rows. Now even if the Multiset table allows duplicate rows by definition, the UPI constraint overrules it. Answer: No.

daniel.doboseru

 Profile Answers by daniel.doboseru Questions by daniel.doboseru

• Feb 6th, 2013

UPI stands for Unique Primary Key, which constrain us to have unique keys, thus unique rows. Now even if the Multiset table allows duplicate rows by definition, the UPI constraint overrules it.

Answer: No.

Improve Answer

Read Best Answer

Editorial / Best Answer

Answered by: Karanjeet

• Nov 22nd, 2005

---

Following are the tier types in a client server application:

a. 1 tier application:All the processing is done on one machines and number of clients are attached to this machine (mainframe applications)

b. 2 tier application: Clients and data base on different machines.Clients are thick clients i.e.? processing is done at client side.Application layer is on Clients.

c. 3 tier application.Client are partially thick.Apart from that there are two more layers application layer and database layer.

d. 4 tier application: Some clients may be totally non thick clients some clients may be partially thick and further there are 3 layers web layer, application layer and database layer.

Avinash

• Nov 24th, 2012

If I am not wrong

Class variables are variables which we create inside a class.

&

Class member are the variables & function declared inside class.

Manoj Kumar Chagantipati

• Jun 12th, 2012

In Two tier there will be Presentation layer and Data base layer
Where as in Three tire there will be Presentation layer,Data access layer and Data base layer

Improve Answer