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 Answers  

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  

---

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

---

Temporary table vs Table variable in sql server?

0 Answers   Wipro,

---

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

---

How do I get sql certification?

0 Answers  

---

What do you mean by rowid?

0 Answers  

---

Can you call pl/sql package functions from within a fast formula?

0 Answers  

---

How can we link a sql database to an existing android app?

0 Answers  

---

What types of commands can be executed in sql*plus?

0 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

Which is better trigger or stored procedure?

0 Answers  

---