Write a query to genarate target column.Please answer me.
Advance Thanks.
Src Tgt
Q10 Quarter to 2010
Q90 Quarter to 1990
Q80 Quarter to 1980
Q74 Quarter to 1974
Answer Posted / manohar
select 'Quarter to' ||to_char(cast('1/1/'||substr(Src) as
char),'YYYY') from table
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
what are ddl statements in mysql? : Sql dba
explain mysql aggregate functions. : Sql dba
What is your daily office routine?
What is an emotional trigger?
Can you join views in sql?
Is sqlite thread safe?
What is AUTH_ID and AUTH_USER in pl/sql ?
Can we delete column in sql?
What is cursor and why it is required?
how to get a list of all tables in a database? : Sql dba
what is data control language? : Sql dba
How to change the order of columns in Oracle SQL Plus ?
What is the purpose of normalization?
Could you please provide oca (oracle 10g) dumps for my certification ?
List the different type of joins?