Guys, you don't need a dba privilege for this.Run the query:select * from USER_DEPENDENCIES where  type='VIEW' and name=''This will give you the dependent object information (name , type of the obje...

SELECT * FROM dba_views WHERE View_name=;

select sum(1) from emp;

Code
SELECT sum(1) FROM emp;

select max(rownum) from
(select ROW_NUMBER() over (order by col_name) as rowNum from table_name)
withRowNum

Use index in the where clause , this way you can use it other wise not ...

index will be used if the retrieval is based on an indexed column .if the where clause uses a column with index then the query will be executed based on that index.

In Teradata,

SELECT * from employee
where SUBSTR(EmployeeName, 1,1) = SUBSTR(EmployeeName, -1,1);

Code
SELECT rownum,a.*FROM(SELECT rownum,b.*FROM emp b ORDER BY rownum DESC) a WHERE rownum <&n;

For First N Rows:

We use the selfjoin on the table employees to retrieve the job before thier managers

Code
SELECT * FROM employees e , employees m
WHERE e.manager_id=m.employee_id
AND e.hire_date < m.hire_date;

select x.ename from emp x,emp y where x.mgr=y.empno and x.hiredate

Code
SELECT * FROM emp  WHERE sal >(SELECT avg(sal) FROM emp)

select * from emp a
where salary >(select avg(salary) from emp b where a.dept_no = b.dept_no);

select * from EMP where rowid in (select min(rowid) from EMP);

We can accomplish this with rowid, below is an example of the query to get the latest inserted records from the table say emp

select * from emp outer where outer.rowid in (
select max(inner.rowid) b from emp inner);

32

The maximum number of columns can be part of Primary Key in a table in Oracle 9i and 10g are 32

select * from hello h where 1=(select count(discnt amt) from hello where h.amt

Say for example below are data exist on EMP tableEMPNO  EMPNAME                DEPTNO      ...

I do not agree with this, Even a function can perform an action.

Hi Everybody, I dont see much update on why package is more faster than function or procedure. Of corse package is must faster than procedure or function The reason being whenvever package is called f...

%rowtype is associated entire table(if we want to declare all columns then we need to declare %rowtype).

%type is associated with one column .(if we want to declare entire column then we need to declare %type).

if using %type and %rowtype , no need to know the the data type of the table column . and once the development is finished , the type of column is changed it will not effect the coding.

A join is a query that results in combining rows from two or more tables, views, or materialized views. Oracle Database performs a join whenever names of multiple tables, views or materialized views a...

Join is relation between more than one table. No of minimum join conditions required is equal to n-1 (where n is number of tables joined together)

delete & truncate command will delete entries from a table.. where as we can delete a single entry using delete but incase of truncate it wont be possible..

using truncate will delete the log files,buffer storage in a table permanently but incase of delete it wont

TRUNCATE- truncate is a DDl command,it deletes the records permanently AND it cannot delete specific record.

DELETE- delete is DML command,it delete the records temporarily AND get it the record by using command called rollback,it can delete specific record.