Answer / praveen

select to_date('Column_Name','dd-mon-yyyy') from table_name;

Answer / pulakesh

select * from testdate
where to_date(column1,'dd-mon-yyyy')=to_date(column1,'dd-
mon-yyyy') and length(column1)>8

Answer / dipti

select * from TABLE1
where VSIZE(column_name) > (select VSIZE('DD-MON-YYYY') from dual)

Answer / kumar

select * from employees
where
length(hire_date)=length(sysdate)

Answer / john bershan

select to_char(column_name,'dd-mon-yyyy') from <table_name>;

Answer / sowmya

Select date from table where date:=to_date(‘date’,’DD-MM-
YYYY’);

can we update a view which is created from two tables

11 Answers  

What are the different types of joins in sql?

3 Answers  

How do you determine the current isolation level? : Transact sql

0 Answers  

What is a stored procedure in sql with example?

0 Answers  

What is the use of sql trace?

0 Answers  

What is rank () in sql?

0 Answers  

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

what is foreign key? : Sql dba

0 Answers  

What is the difference between python and sql?

0 Answers  

How do I quit sql?

0 Answers  

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

Name the operator which is used in the query for pattern matching?

0 Answers