Write a query to extract first 5 characters of a name in the column Stud_Name?
Answer Posted / shubham
select substr(Stud_Name,1,5) from Table;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which components manage deadlocks in db2?
What is table space in db2?
Is db2 a database?
How to create db2 table in mainframe?
What is multi row fetch in db2?
How can the duplicate values be eliminated from db2 select?
List out the three types of page locks that can be held.
How would the varchar column remarks defined?
What does db2 mean?
What is deadlock in db2?
When the like statement is used?
Is db2 a mainframe?
What is the use of value function?
What is cursor in dbms?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?