Answer / intelligent

select * from emp where rownum>101 and rownum<121

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

0 Answers  

---

What does (*) mean in sql?

0 Answers  

---

explain access control lists. : Sql dba

0 Answers  

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

---

What is a unique key and primary key and foreign key?

0 Answers  

---

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 Answers   Tech Mahindra,

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

What is a temporal data type?

0 Answers  

---

How do you respond to dementia behavior?

0 Answers  

---

how to write date and time literals? : Sql dba

0 Answers  

---

difference between oracle 8i and oracle 9i

8 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---