ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL PLSQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
write a qurey for finding the length of the sting.
 Question Submitted By :: Revva
I also faced this Question!!     Rank Answer Posted By  
 
  Re: write a qurey for finding the length of the sting.
Answer
# 1		 
select length('abc') from dual;

out put:
 3
          
           (or)
select length(<columname>) from <table>;
 
Is This Answer Correct ?    4 Yes 1 No
Srinivas
 
  Re: write a qurey for finding the length of the sting.
Answer
# 2		 
SELECT LEN ('string')

output :
6
 
Is This Answer Correct ?    0 Yes 3 No
Manjula
 
 
 
  Re: write a qurey for finding the length of the sting.
Answer
# 3		 
Select length('&string') from dual;
 
Is This Answer Correct ?    1 Yes 1 No
Rinson
 

 
 
 
Other SQL PLSQL Interview Questions
 
  Question Asked @ Answers
 
How to execute OS(operating system) command from pl/sql?  3
What are different types of joins ? BirlaSoft3
What is differance unique key and primary key. EDS5
How to maintain the history of code changes of pl/sql?  2
Name the tables where characteristics of Package, procedure and functions are stored ?  3
i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#  1
What is Data Concarency and Consistency?  1
how to get second highest salary in SQL(as/4000 iGate14
What is normalization and types of normalization? Microsoft3
How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')  2
how to create a database in oracle?  2
Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...  1
Can we relate two different tables from two different users in ORACLE,PL/SQL?  4
what is the purpose of update command in oracle? MBT6
can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)  5
Explain how procedures and functions are called in a PL/SQL block ?  1
What are the advantages of VIEW?  3
What is correlated sub-query?  3
How to call DDL statements from pl/sql?  3
wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure Apollo1
 
For more SQL PLSQL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com