Answer Posted / saty

select sequencename.currval from dual

select sequencename.nextval from dual



if we will give only table name thr will be error


Thanks & regards
satya
+919916174212

what are date and time data types? : Sql dba

976

---

What are types of joins?

959

---

Show how functions and procedures are called in a pl/sql block.

1112

---

Is inner join faster than left join?

1182

---

Where can I learn sql for free?

980

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1058

---

What is a behavioral trigger?

967

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1066

---

How many triggers can be applied on a table?

928

---

Can we use delete in merge statement?

1033

---

Can dml statements be used in pl/sql?

1071

---

How long it takes to learn pl sql?

1003

---

how to write date and time literals? : Sql dba

954

---

What is trigger price?

976

---

what does the t-sql command ident_incr does? : Transact sql

1066

---