Oracle string functions interview questions

<<Previous  Next>>

 The answers to following questions will be made available soon. Keep visiting.

Describe the use of following oracle string functions with an example.

Concatenation(||)
RPAD and LPAD
Ltrim, Rtrim and Trim
LOWER, UPPER, and INITCAP
LENGTH
SUBSTR
INSTR
ASCII AND CHR
SOUNDEX 

Also read

Oracle functions

What are conversion functions?, What is nested function?, What is NVL function?, What are SQL functions in oracle?............

Oracle Functions, Procedures, packages

Explain IN, OUT and INOUT in procedures, What are the rules of writing package?, Explain the rules for writing a package..............

Oracle - use of Translate Function

The translate function performs a character wise replacement of a string. The syntax............

Write a PL/SQL program for a function returning total tax collected from a particular place.

What are the types PL/SQL code blocks?

Anonymous Block, Stored Program Unit, Trigger............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience