how to produce numbers from 1 to 10 using dual table
Answers were Sorted based on User's Feedback
Answer / arunkumar t
select rownum from dual connect by rownum <=10
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / anil kumar prajapati
The DUAL is special one row, one column table present by
default in all Oracle databases. The owner of DUAL is SYS
(SYS owns the data dictionary, therefore DUAL is part of the
data dictionary.) but DUAL can be accessed by every user.
The table has a single VARCHAR2(1) column called DUMMY that
has a value of 'X'. MySQL allows DUAL to be specified as a
table in queries that do not need data from any tables. In
SQL Server DUAL table does not exist, but you could create
one.
The DUAL table was created by Charles Weiss of Oracle
corporation to provide a table for joining in internal
views.
Example
Select Row r
From dual
Connect By Row <= :100
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nihar ranjan nath
SELECT n FROM (SELECT ROWNUM n FROM DUAL CONNECT BY LEVEL<=10)
WHERE n<=1;
Is This Answer Correct ? | 0 Yes | 0 No |
How can we find out the duplicate values in an oracle table?
Explain the use of record length option in exp command.
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
What is a data segment ?
What is recovery manager in Oracle?
Whats the benefit of dbms_stats over analyze?
What are the components of Logical database structure of ORACLE database?
How to unlock the sample user account in oracle?
how to clone 9i Database on to 10g Database.
how to insert data into partitioned table partition done by Range partition
How to assign a table row to a record variable?
What are the composite date types in oracle?