You are here:
I can answer any questions on Oracle SQL and PL/SQL. The following are the topics I am an expert in Writing SQL using SQL 92 standards Oracle Advanced Groups Analytical Functions Hierarchial Queries Partition Objects and Collections Oracle XML Oracle regular Expressions Exception Handling Bulk Binding Dynamic SQL and PL/Sql Procedures Functions Packages Triggers Advanced Queueing Implicit and Explicit Cursors Oracle sql functions(CAST, CURSOR etc) Oracle SQL Tuning Oracle Execution Plans
10 Years as Developer and DBA
Currently working with a Health Care industry
Masters in Computer Applications
| User | Date | K | C | T | P | Comments |
|---|---|---|---|---|---|---|
| sandeep | 08/06/09 | 10 | 10 | 10 | 10 | Thanks I really need this query |
| Hemalatha | 08/05/09 | 10 | 10 | 10 | 10 | Thanks Binosh, it worked exactly the way ..... |
| Gud | 07/16/09 | 10 | 10 | 10 | 10 | i am impressed with the clarity and ..... |
| Hector | 06/29/09 | 10 | 10 | 10 | 10 | |
| srinivasa | 06/29/09 | 9 | 8 | 7 | 10 | Thanks a lot |
Hey San, How are you doing? Q1: Please run the following sql and check the value of VALUE column show parameter recyclebin; If it is OFF then run the following command ALTER SYSTEM SET
Hi San, How are you doing? If you want to see all the users in your database, then run the following command, SELECT * FROM all_users; Or if you want to know the database name and its connect
Hi san, How are you doing? These are the books I am using. And these are my bible for tuning Cost-Based Oracle Fundamentals by Jonathan Lewis Expert Oracle Database Architecture:
Hi san, These are the steps. lets take the example of DEPT table in scott schema Description of this table is DEPT ---- deptno number dname varchar2(30) loc
Hi Sandeep, Good to see you again. How are you doing? I believe your requirement is to restore a table if you have dropped that table. Let me walk you thru an example. Let's say
Answers by Expert:

©2009 About.com, a part of The New York Times Company. All rights reserved.