Answer Posted / nazeer

pseudo column act as database table column, but not actually the exact column in the table....we can fetch values from the pseudo column....

The Columns are..
user,
userid,
rownum,
rowid,
level,
nextval,
curval,
sysdate.......

What are the constraints available in sql?

575

---

Why use truncate instead of delete?

546

---

What is the use of function "module procedure" in pl/sql?

666

---

explain commit and rollback in mysql : sql dba

545

---

What is package in pl sql?

577

---

---

What is the sql*loader? : aql loader

585

---

How to execute a stored procedure?

559

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1525

---

Enlist some predefined exceptions?

580

---

How can we implement rollback or commit statement in a trigger?

577

---

what are wild cards used in database for pattern matching ? : Sql dba

546

---

Which nosql database is best?

511

---

what are the nonstandard string types? : Sql dba

601

---

What is use of package in pl sql?

531

---

Can we create table inside stored procedure?

532

---