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 / brahma prakash
Murali your answer is not running on postgres database
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can you use check constraints for self referential integrity?
Why do you use stored procedures and state some of its disadvantages?
Why should I use oracle database?
Where do you use decode and case statements?
What is object data modeling?
What is oracle latest version?
How to rename an index in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
List out the types of joins.
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
Is oracle an operator?
What is the difference between formal parameters and actual parameters?
How to export data to a csv file?
 What are the oracle DML commands possible through an update strategy?
What is a snapshot log?