Answer / abc

Select * from user_sys_privs;

How to retrieve data from an cursor to a record?

1 Answers  

---

How to handle a single quote in oracle sql?

1 Answers  

---

How to test null values?

1 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

when loggined as SYSTEM,how to display all the users of database using sql query?

2 Answers  

---

How to start instance with a minimal initialization parameter file?

1 Answers  

---

What privilege is needed for a user to insert rows to tables in another schema?

1 Answers  

---

How to assign a tablespace to a users in oracle?

1 Answers  

---

Can we create more than one constraint to column ?

6 Answers  

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1 Answers  

---

Define oracle database

1 Answers  

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1 Answers  

---