it is same as oracle table but act as view to the data available in an external file of a physical drive,so here we can query the data and retrieve and can do anything but cannot do manupulations on the data

In 9i we does not have the facility to brign the table that is been dropped, but in 10g we have something like flashback and also in 10g they have added one extra regular expression

In oracle 10g we have new datatype called binary double and binary float. 10 g also has collection api, which allows us to use procedures and funtion with collections. In Oracle 10g external procedures can also be called.

actaully, both mean the same but try to understand what is commit?see..most of the people think that when we type commit data or changes of what you have made has been written to data files,but this i...

As such there is no difference operationally. WORK is optional and is provided just for ANSI compatibility.

Dear friend, I didn't get exactly what you want,any please tell me the context so that i can help you out................coming to the question:you want the result of multiple rows in a singl...

see spool command

well you want to see the output ina  text file............this can be done by spooling the data;for example..you want to see the output of the details of all employees:do the following steps:spoo...

If you successfully exported the data to text file , then you are very close! In the export option of Microsoft Access, you shall see an option like "Export to ODBC database". If you click that, you...

This might help someone if need to get table into Oracle from MS Access table.Option-1 - Use MS Access (2003) Export 1. Oracle Client and Oracle ODBC driver should be installed on your PC.2. In O...

Utility is something which comes along with software where it is intended to help us to solve a particular purpose but tool is something which enable us to develop more delebrately we can say as helpful for innovative development.

Utility cannot uninstall it is an inbuilt

Tool can uninstall

Cold Backup is possible only when the database is down means it is not available to users to access. Disadvantage is we effort downtime. Here we need to take backup of datafiles, control files, redo...

Cold Backup: Need to back up Database Files, Control Files, Online Redo Log files.
Hot Backup: Need to back up Database Files, ControlFiles, Offline Redo Log files (archive files).

mutation of triggers is an example of deadlock.......for flashback we can use to being tables from recyclebin

SELECT Hiredate,Count(*)
FROM emp
WHERE to_char(hiredate,yyyy) in (1995,1996,1997,1998)
GROUP BY Hiredate;

"sql select deptno,count(to_char(hiredate,yyyy),1980,empno) as yr1980, count(to_char(hiredate,yyyy),1981,empno) as yr1981, count(to_char(hir...

select job, count(job) from emp group by job;

Code
SELECT count(*), job
FROM emp 
GROUP BY job

Row num is a sequential number allocated to each returned row for query execution. It is nothing but a numeric values. It is a temporary values. But row id is a physical address of the rows. It is permanent.

ROWNUM is a pseudocolumn returning a sequential number along with the rows retrieved, whereas rowid (also a pseudocolumn) contains the actual physical address of the data block containing the row

Say you are using the seq name temp_seq

CREATE SEQUENCE temp_seq
Start with 5

Increment by 2
maxvalue 999999999999999999999999
nocache
nocycle


Above will create the sequence temp_seq
To use it
INSERT INOT xyz
VALUES (temp_seq.nextval,'oracle')

Dear friend :  oracle generate sequence numbers with the help of predefined function called nextval.so if you want insert these generated sequence no you can do using <seq_name>.nextvalfor ...

Use this simple query

delete from table1 where rowid not in (select max(rowid) from table1 group by duplicate_col_name)

Hi,   'X' refers here to the table name and 'a' and 'b' are the alias nameDelete from X a where rowid in (select min(rowid) from X  b  &...

Dual is default table in oracle .it contains single row and single column.All the Character functions and number functions and date functions execution done in this Dual table.

Dual is a dummy table which has one row and one column but can't make the DML opertions.

oracle supports two types of joins: 1.oracle joins   cartesian join   equi join   non equi join   self join   outer  join is exhibited ...

Hi all,

Actually we r talking abt the ANSI join syntax,That's available in oracle 9i.this join cannot

be run in lower version means oracle 8i(8.17),oracle 9i releases1.

The join syntax is left outer join,rigth outer join,full outer join.natural join,

Regards

Pawan Ahuja

91(9342927335)