what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

0 Answers  

---

Explain what is table in a database?

0 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

Can we rollback truncate?

0 Answers  

---

what is foreign key? : Sql dba

0 Answers  

---

What can I use instead of union in sql?

0 Answers  

---

use of IN/ANY/ALL

5 Answers   Ramco,

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

What is the best sql course?

0 Answers  

---

What is a primary key, and how is it different from a unique key?

3 Answers  

---

How to fetch alternate records from a table?

0 Answers  

---

how instead of triger is helpful for mutating tables errors handlling ?

2 Answers   Oracle,

---