Interested to Buy Any Domain ? << Click Here >> for more details...
select 10 from dual; y its showing all the rows with 10?
- 1 Answers
- 5653 Views
- I also Faced
- E-Mail Answers
Answer Posted / honey
1.
As we know that Implicitly Cursor 'SQL' is opened.
when it is pin pointing the 1st row in the dual, cursor
found that one record exists.
2.
since there are no conditions (i.e., where,group by,..),
directly 'select' clause will be executed.
3.
Internally Oracle identifies numbers, so 10 number will be
displayed.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
what is the syntax for using sql_variant_property? : Transact sql
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Where do we use pl sql?
what are the different type of normalization? : Sql dba
How to handle bulk data?
How do I run a sql query in pgadmin 4?
What is record in pl sql?
What is asqueryable?
What is a dirty read sql?
Does truncate free space?
what are the advantages and disadvantages of views in a database? : Sql dba
how to add a new column to an existing table in mysql? : Sql dba
What are the subsets of sql?
What are the parts of a sql statement?
