Answer / pavan_1981

only one

Answer / pravin

only 1 Long columns allowed in table

Answer / fahad sami

1

Answer / solomon information technologi

only one

Answer / anchit aneja

only 1...,forsure...!!!

Answer / harshit varshney

Only one column can have LONG data type. And that column cannot be used in WHERE clause or in ORDER BY clause. Also we cannot add primary key constraint to that column only not to the whole table, that means we will give primary key to any column in the table except the column having the long data type. If we give, we get the error ORA-02269: key column cannot be of LONG datatype.

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

What is an Integrity Constraint?

4 Answers  

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

What is the difference between sql and mysql?

0 Answers  

Can cursors be part of a trigger body?

0 Answers  

How do I clear the screen in sql plus?

0 Answers  

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

What does partition by mean in sql?

0 Answers  

What is a temp table?

0 Answers  

I have a CURSOR then why we need BULK COLLECT again?

1 Answers  

what are the different types of joins?

4 Answers   Choice Solutions,

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,