Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 58730 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / belal ansari
The sql engine select the records from the table EMS and it store in IMPLICIT CURSOR then display these recordes.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Define commit?
What is the use of prepared statement?
what is rollback? : Sql dba
What is sp_helptext?
How to convert comma separated string to array in pl/sql?
What are the advantages of stored procedure?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
Is it mandatory for the primary key to be given a value when a new record is inserted?
What is integrity in sql?
How do I pipe the output of one isql to another?
What is the difference between pl and sql?
Which is the correct statement about truncate and delete?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What are the different types of database management systems?
Why do we use function in pl sql?
