Series: Subject: Topic:

Question: 10 of 82

Dynamic Insert

What is Dynamic Insert?

Asked by: swapnabogolu | Member Since Jun-2010 | Asked on: Sep 6th, 2010

View all questions by swapnabogolu

Return back to Data Warehousing

Answer Question

Showing Answers 1 - 1 of 1 Answers

mkm187

Answered On : Oct 5th, 2010

View all answers by mkm187

INSERT FIRST

WHEN SAL > 25000 THEN

INTO special_sal VALUES(DEPTID, SAL)

WHEN HIREDATE like ('%00%') THEN

INTO hiredate_history_00 VALUES(DEPTID,HIREDATE)

WHEN HIREDATE like ('%99%') THEN

INTO hiredate_history_99 VALUES(DEPTID, HIREDATE)

ELSE

INTO hiredate_history VALUES(DEPTID, HIREDATE)

SELECT department_id DEPTID, SUM(salary) SAL,

MAX(hire_date) HIREDATE

FROM employees

GROUP BY department_id;

Answer Question

User Panel

Lost Password

Get Activation Code

Interview Coaching

Do you find yourself busy most of the time? Why?

Describe a time when you had to work under pressure.

What will you do when you are not able to get your message across to your audience?

Importance of an MBA for an entrepreneur

How do you approach a problem?

Do you seek advice from others when you have a question?

Describe a time when you had to convince a friend ?

What was the most important decision you ever had to make?

Career Options for BCA Graduates

Have you experienced being given too many tasks?

Connect

Question Categories

Business Objects FAQs

Cognos FAQ

ReportNet FAQ

Interview Question

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Dynamic Insert

Give your answer:

Related Answered Questions

Related Open Questions