Answer / dharmendra

select to_char(sysdate,'DD/MON/YYYY') from dual;

Answer / uday shankar chejerla

select to_char(to_date(sysdate,'dd-mon-rr'),'dd/mon/yyyy')
from dual;

Answer / panchi

dd/mm/yyyy

Answer / bhanu

select to_char(sysdate,'DD/MON/YYYY') from dual;

Answer / nazim

select convert(char(12),getdate(),106)

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

2 Answers   HCL,

i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings

2 Answers  

How many data types are supported?

0 Answers  

SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.

2 Answers   Cognizant,

How to count groups returned with the group by clause in oracle?

0 Answers  

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

0 Answers   TCS,

what is host string in sql plus? how does it related to database?

1 Answers  

Explain the use of control file?

0 Answers  

Explain the use of rows option in exp command.

0 Answers  

What is a lookup table in oracle?

0 Answers  

Explain what are synonyms used for?

0 Answers  

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 Answers