One Table having two rows with one colomn having values
Like"Male" and "Female". how to upadte these values
Like "Female" and "Male" in single update statement.

Answer Posted / manikanta

'DECODE' is not a recognized built-in function name in sql
server

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an index associated with a constraint?

550


What are the common oracle dba tasks?

619


How do I escape a reserved word in oracle?

624


Can we use bind variables in oracle stored procedure?

488


Explain the use of inctype option in exp command.

592






Is there any function in oracle similar like group_concat of mysql?

537


What is the exact use of Collections?

1677


What is partitioned table in Oracle?

629


Calculate difference between 2 date / times in oracle sql?

568


How to create tables for odbc connection testing?

485


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1565


1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

1603


What is a sub query? Describe its types?

540


What language does oracle use?

591


how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

1823