Help on query replacing the date

Posted on 16th Feb 2014 07:03 pm by admin

Hi Pals,

i want to replace the current date in a column to some value say C or D or any numeric value , likewise the NVL function which replaces the null value can i replace value selected to my assigned value
eg

select * from employee where employeedate= current dat will display the dates as 2008-10-10 to C or D

Your Answer:

Login to answer

Other forums

Problem assigning value to variable in "IF" function
Does this script makes sense? I am trying to take the value that is set to "authenticat" a

How to sum these output values
Hi

I need sum the month totals
SELECT region_name, area_name ,SUM (CASE WHEN S

How to read CSS message data
Hi,
I have a requirement here. When working as a Dev angel for multiple customers its really di

puting for loop in 1 value
hi ,

how do i put this code in 1 value:
Code: <?php
for ($i=1; $i<=5; $i

Serial number of exernal hard disk/Thumbdrive
Hi guys, I am new tio java networking concepts.Please tel me how to get Serial number of exernal

empty() error
Why does

Code: empty($USER_ID = $_SESSION["USER_ID"])
create this error...

Php script to read msword file
hi,

I need to read a msword file and i want to print the contents in that word file.

i

Parse Error
Hi Guys,

I have a function in my class which returns a string link variable. The problem is i

Material Issuing for receiving batch
Dear All experts in MM/ PP,

Material issuing from main stores to factory is currently usi

frames get header location..
i have two frames, one top, one bottom. how do i do a form on the bottom frame that gives me the ur