Answer / srinivas

select length('abc') from dual;

out put:
3

(or)
select length(<columname>) from <table>;

Answer / nagendra

select length('sting') from dual;

Answer / rinson

Select length('&string') from dual;

Answer / ajmal khan

select length('string') from dual;
or
select length(column_name) from table_name;

Answer / abhiraj

select LEN('welcome')

Answer / manjula

SELECT LEN ('string')

output :
6

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

How do I run a sql query?

0 Answers  

Why trigger is used in sql?

0 Answers  

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,

what are set operators in sql? : Sql dba

0 Answers  

Advantages and disadvantages of stored procedure?

0 Answers  

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

Can you join a table to itself?

0 Answers  

How many sql statements are used? Define them.

0 Answers  

What is numeric function sql?

0 Answers  

What is trigger explain it?

0 Answers  

How to call DDL statements from pl/sql?

5 Answers