logo for asktheoracle.net
Home
What's new?
Oracle Tutorials
PL/SQL
SQL
Oracle Tips & Tricks
Advanced Tutorials
Certification
Oracle 10g
Oracle 11g
Oracle and .Net
Oracle Tools
Disclaimer
Privacy Policy
Search This Site
Oracle Questions?
leftimage for asktheoracle.net

Questions about Oracle databases? SQL?  PL/SQL?

This is the place to ask.

Are you stuck with an Oracle problem? Do you have a question about how the database works?  Need some advice on writing SQL or PL/SQL? Then ask your questions here and we'll answer as quickly as we can.


There are 4 ways you can get help on this page:

  • You can use the search box to help you to find the  information you're looking for quickly
  • You can use the form to ask us a question
  • You can read the questions other developers have asked along with the answers
  • And you can subscribe to our ezine - if you're not already a subscriber to Oracle Tips & Tricks you're missing out on a myriad of valuable tips and techniques. Subscribe now and ignite your career.
Search AskTheOracle.net for an answer to your question.


Have A Question About Oracle?

Have a question about Oracle databases? Need help with SQL or PL/SQL? Looking for some advice on the best way to resolve an issue? Just AskTheOracle!

We give our best answers but maybe you know of a better way to solve a problem or can improve an answer, or maybe you can recommend a book/web page/article which will help. In which case, feel free to add your comments and share your expertise.

Enter a one line summary of your problem/question here
(eg. What's the difference between a trigger and a constraint?)

Fill in the details here [ ? ]

Upload 1-4 Screenshots (optional) [ ? ]

Add a Picture/Graphic Caption (optional) 

Click here to upload more images (optional)

Author Information (optional)

To receive credit as the author, enter your information below.

Your Name

(first or full name)

Your Location

(ex. City, State, Country)

Submit Your Contribution

Check box to agree to these submission guidelines.


(You can preview and edit on the next page)

What Other Developers Have Asked

Questions other Oracle developers have asked ...

How to run an executable from an Oracle Trigger 
From: Sean - Hi, is it possible to run an executable file from an Oracle trigger? I haven't been able to find any documentation on how to do this - please ...

Oracle SQL query on use of SUM and ROLLUP  QUESTION:
I am using the emp table as an example and I want the data to display in this format

Deptno Job Sal Sumsal
10 CLERK 1300 ...

What is Oracle metadata?  From Neelima - what is metadata?

The short answer is that metadata is data about data. In other words Oracle needs to store data to keep track of ...

Problem connecting to Oracle "as sysdba" from Oracle SQL Developer 
I have an Oracle 10g XE database running on Windows Vista and I want to connect "as sysdba" from Oracle SQL Developer. When I test the connection I ...

How will we know that all the records have been inserted into our Oracle database table?  Question: We will be inserting 10 million records into a table in our Oracle database. How will we know that all the records have been inserted into our ...

Oracle performance tuning  From Jamuna, Hyderbad - what are the performance tuning steps in Oracle?

Oracle performance tuning is a big subject - there have been whole books ...

What is view in Oracle?  Question: what is a view and how many types of views are there in Oracle?

We'll answer the 2nd part first to make it easier to answer the 1st part....

How can I change the defult date format in oracle10g enterprise?  Question: I use alter session & NLS_DATE_FORMAT, but it's not working.

The ALTER SESSION in Oracle SQL only affects the current session (as the ...

What is the pragma autonomous_transaction in PL/SQL?  From Jamuna, Hyderbad - What is the AUTONOMOUS_TRANSACTION pragma in Oracle PL/SQL?

PRAGMA's are directives for the Oracle PL/SQL compiler. The AUTONOMOUS_TRANSACTION ...

What will happen if we do not close a cursor in PL/SQL  From Jamuna, Hyderbad - With Oracle pl/sql if an explicit cursor is opened and we do not close the cursor what will happen? Will the programme run?

The ...

Iin Oracle how can I display the LENGTH of the last_name for all employees whose names start with the letter "A" "J" "M"   From Ayah, Port Harcourt
I am working with Oracle 11G and want to display the last name of an employee from the employees table,with the first letter ...

Question about using foreign key constraints in Oracle  From Apoorva - I am doing SQL / PLSQL course for Oracle. Right now, I am doing SQL and have came across a problem. Following is the SQL statement :

CREATE ...

Problem with Oracle SQL performance  From: Paramesh in Singapore - We are using Oracle and I have a problem with SQL. We are retrieving data from 6 tables using joins (returning approximately ...

How can I get the 2nd or the 3rd highest value from a table in an Oracle database?  Question: For example, using the emp table in the sample schema in Oracle, how would I retrieve just the 2nd or 3rd highest salary?

Answer:
There ...

Do you have any tips on Oracle performance tuning?  Question:
I have been doing large inserts on a couple of tables in my Oracle database and the performance has been degrading by the minute.

Answer:...

Please tell me about constraints in oracle  QUESTION:

What are the various types of constraints in oracle (table level and column level) and what is the difference?

ANSWER:
There are 6 ...

Oracle export problem   QUESTION:

We have a table (Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production) with following data:


2 137 ebpreiss
3 8634 ...

I require assistance with an SQL query  Question:

Record name is TREE. The two fields are PARENT & CHILD.

It's a tree structure i.e.
PARENT = 0001
CHILD = 2000
CHILD = 3000
PARENT ...


Return to home page