Write a query to retrive partial string.
- 2 Answers
- 5171 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 |
Explain what are the various isolation levels possible?
when does the SQL statement gets executed when you use cursor in the application programming ?
Write a query to retrive partial string.
What is the latest version of ibm db2?
How to retrieve rows from a db2 table in embedded sql?
What is the use of reorg in db2?
Is db2 a mainframe?
Explain in brief how does db2 determine what lock-size to use?
What is database alias db2?
What is the role of data manager in the db2 database?
Is db2 a programming language?
What is precompiler in db2?
COBOL 
