Oracle string functions interview questions

          

Oracle string functions

<<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


 

 
Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring