1.

write a query to display 4characters extracted from 5th left character onwards from string CONGRATULATION?​

Answer»

the characters extracted from a string BASED on the specified character position for a specified NUMBER of characters.The character position and number of characters are based on the number of characters, not bytes, so that multi-byte characters are COUNTED as single characters. You cannot SPECIFY a negative length, but you can specify a negative STARTING position.



Discussion

No Comment Found

Related InterviewSolutions