In SQL Server, there exists no 'dual' table. Instead you can query in SQL Server like 'select 2*2' will give you the required output. {PFA the image file 1.jpg} for the output in the SQL Server.
:)...
Type: Posts; User: ram bg; Keyword(s):
Re: Dual Table in Oracle
In SQL Server, there exists no 'dual' table. Instead you can query in SQL Server like 'select 2*2' will give you the required output. {PFA the image file 1.jpg} for the output in the SQL Server.
:)...
In simple words, can you explain me what does 'connect by' achieve in your query (...... CONNECT BY level < 101) ?
In your query
"SELECT level as ID
FROM DUAL
CONNECT BY level < 101"
what does 'CONNECT BY' clause do ?