Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

KSDS question

This is a discussion on KSDS question within the Database Design forums, part of the Databases category; KSDS is having the emp key, empname and join date. We want to add the bonus Rs. 10000/- those who join on Jan 1st 2008. How to do this ?...

Geeks Talk > Databases > Database Design KSDS question

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   02-28-2008

pra.red Junior Member   Join Date: Feb 2008 Location: bangalore Posts: 3 Thanks: 0 Thanked 1 Time in 1 Post

KSDS question KSDS is having the emp key, empname and join date. We want to add the bonus Rs. 10000/- those who join on Jan 1st 2008. How to do this ?

Sponsored Links

#2 (permalink)   02-28-2008

krishnaindia2007 Expert Member   Join Date: Sep 2007 Posts: 754 Thanks: 22 Thanked 62 Times in 61 Posts

Re: KSDS question Use the following query UPDATE TABLENAME SET BONUS = 10000 WHERE JOINDATE = TO_DATE('01/01/2008','DD/MM/YYYY')

Geeks Talk > Databases > Database Design

« Heap and stack memory | performance »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HR question	sakshi_2801	Companies	5	3 Weeks Ago 04:19 PM
Question	Manoj.Oracle	Oracle Apps	2	03-10-2008 07:54 AM
c question..?	kamanianil	C and C++	0	08-07-2007 05:30 AM
QTP question?	hetal desai	QTP	3	07-11-2007 02:31 PM
Question	shitalpatil	Brainteasers	3	03-08-2007 06:32 AM

All times are GMT -4. The time now is 01:44 AM.