How to migrate from Oracle to Teradata?

zelani

 Profile Answers by zelani Questions by zelani

• Jan 12th, 2009

null in c is some garbage value which cannot be predicted . If you are not intialising any value to the variable then null value is present in auto variables.null in oracle is used in sql queries for ...

symhdl

 Profile Answers by symhdl Questions by symhdl

• Jan 3rd, 2009

This is not truely the right answer.When you store data in oracle its terminated with a zero byte. For example when you store HELLO its stored as 5HELLO where is the zero byte. When you don...

Answer Question  Select Best Answer

justgeek

 Profile Answers by justgeek Questions by justgeek

• Jan 10th, 2009

select e.deptno, e.ename, e1.enamefrom scott.emp e, scott.emp e1where e.deptno=e1.deptnoand e.enamee1.enameorder by e.deptno,e.ename

kenito

 Profile Answers by kenito Questions by kenito

• Dec 14th, 2008

select     e.department_id department,     e.last_name employee,     c.last_name colleaguefrom     employees e,     employees...

Answer Question  Select Best Answer

gautthamm

 Profile Answers by gautthamm Questions by gautthamm

• Dec 31st, 2008

After update of the table, the view automatically gets synchronized where as the Materialised view needs an explicit refresh (either Manual or by Oracle) for synchronisation.Another diff is that the r...

Jirange

 Profile Answers by Jirange Questions by Jirange

• Oct 15th, 2008

View is a replica of table.Materialized? view is remote table on local database.

Answer Question  Select Best Answer

What is Data Adapter in Oracle?

What is Cluster Index in Oracle?

How to register forms in oracle application 11i?

What are the SQL formatting commands?

How to use oracle JVM in Oracle 10g, installation and it's functionalities.How to run a java program on the SQL prompt?

In D2K How to change the label text of a boilerplate object dynamically, using conditional triggers?

ashishpandey52

 Profile Answers by ashishpandey52 Questions by ashishpandey52

• Nov 12th, 2008

select e_name,e_salary from emp where e_salary=(select min(e_salary)  from (select e_salary from emp order by sal desc )where rownum<4; 

myhotinterview

 Profile Answers by myhotinterview Questions by myhotinterview

• Jun 3rd, 2008

I think we can also use this:select emp_name from from where rownum=3 order by salary desc

Answer Question  Select Best Answer

Where is the configuration file is stored in Oracle 9i and 10g

What do you mean by objects in Oracle and how do they differ from Java objects?

How to create New DATABASE in TOAD (Oracle Application Development TOOL)

How to identify the special character's in the table?

How many exception in Oracle?

ravula sudheer

 Profile Answers by ravula sudheer Questions by ravula sudheer

• Oct 18th, 2008

In Oracle there are two types?of exceptions.USER DEFINED EXCEPTIONS.DEFINED EXCEPTIONS..(NO_DATA_FOUND,VARIRABLE LENGHT TOO LONG .. etc.)

Answer Question  Select Best Answer

SELECT * FROM (SELECT ROWNUM,ENAME,JOB,SAL FROM EMP WHERE ROWNUM

sureshkumar.mtech

 Profile Answers by sureshkumar.mtech Questions by sureshkumar.mtech

• Oct 11th, 2008

Here compulsory to give the alias name for rownum because the column name is not exist in the table so it's show error for invalid columns specification.The query should be below;select * from (select rownum as num, last_name, salary, id from employeewhere rownum

Answer Question  Select Best Answer

How to configure Oracle 10g on Sun Solaris 10 platform?

How to clasify the constraints in a table? Which columns are associated to primary, composite primary, unique, and not null constraints while the inserting rows into a table?

How do we can see savepoint names list?