Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to retrive partial string.
- 2 Answers
- 5713 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajesh_m13
substr('string',1,3) which gives str. correct me if i am wrong
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / ignatius pradeep
A Sample Query:
SELECT SUBSTR(DESC_T,1,4)
FROM PRODUCT
WHERE PROD_I = 123456;
DESC_T is a column in the table PRODUCT
The first four characters of the DESC_T will be displayed.
| Is This Answer Correct ? | 4 Yes | 0 No |
why we create view.
How would one remove old reorg information from the DB2 catalog?
Why db2 is called db2?
What is the difference between oracle and db2?
where can we use index and subscript ? with example ?
what needs to be done if a table is in copy pending / check pending status?
What is the latest version of ibm db2?
What information is used as input to the bind process?
How do you define a correlated name?
What is a recovery log?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
What is innodb buffer pool?
COBOL 
