Delete
-----------
1. DML
2. Affects only data.
3. Data can be rolled back after this command.

Truncate
----------------
1. DDL
2. Affects both data and structure (resets the High Water...

Unique key enforces only uniqueness (no duplicate) where as a Primary key enforces both uniqueness and not null (data must be entered into the field). Once a PK is created on a column oracle creates...

Try using the following link (http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261.pdf).

This is part of oracle documentation library.

What exactly is your requirement ?

Are you using the SPOOL command to generate the flat file ?

Then you need to use the free tool Query Reporter (http://www.allroundautomations.com/plsqldev.html)

You need to read books , there are thousands of example lying abundantly across millions of web pages .

Kindly mention what exactly you are looking for and what are you getting as output from your query.

What did Google say ?

Then you need to try this (http://www.toadsoft.com/lic_agree.html).

TOAD does not come in that price range.

How much you are ready to invest for the tool ?

Find the complete list of providers here (http://www.connectionstrings.com/oracle).

if you are ready to pay use TOAD or PLSQL DEVELOPER, the best possible tools in market.

in oracle 11g credentials are case sensitive unlike any of the previous versions.

Have a look at this sample code


INSERT ALL
INTO sales (prod_id, cust_id, time_id, amount)
VALUES (product_id, customer_id, weekly_start_date, sales_sun)
INTO sales (prod_id,...

You need to use INSERT ALL.

you need to create a check constraint with the desired values on the desired column of the table.

is the entry available in TNSNAMES.ORA ?

you are trying to create a new database or trying to log in to existing database.

Try to use set operator, that should solve your Qry1 and Qry2.

for the third qry try to join both the tables.

would you mind to post here what are the different things that you have tried ?

what is a minor project .you need to decide first what you want to do.

you need to read books for all the details.

you mean to say , u want to include media files to database ?

Only the owner of the object has the permission/access on the object. Other users needs to be granted permissions by the owner/dba for access which is taken back by the REVOKE command.

If...

i don't think i understood your last question.

kindly post your table structure.

missing CONSTRAINT key word on line 8.

what the project is all about ?
Is it only a database projects ?

once you start installing 10/11 g you will get the list of pre-installed oracle homes/products. You need to uninstall the existing 9 version before installing the higher version.

you can always do that , just use sysdate that will handle your date problem.

ORACLE will not come in that list of installed software. Uninstall from oracle main menu from start button or use the oracle CD.

better install any latest version and set the passwords carefully.

try log in as

sys/ as sysdba
password----change_on_install

If you are planning to reinstall better use any advance version .
Current version for windows is 11.1

do you have the password for sys or system account ?

You don't have the user name password ?

Are you getting something like SQL WORKSHEET under application development ?

Just try adding a GROUP BY statement to your existing query.

Sorry, we do not solve home works /assignments here.

The error message is self explanatory.

I think you are trying to redefine SQL with your own bunch of syntax. What are those WHILE and WHEN in your code ?