what is query and types of query
Answers were Sorted based on User's Feedback
Answer / manohar
to retrieve data from the database tables is called query
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / gangadhar mahabubabad
query is a language
by using query, we can write SQL statements
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bhupali
Query is a sql statement which helps to retrieve data from
multiple table
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / vaibhav tiwari
The SQL statement returns a result set of records from one
or more tables.Query is not only used for data retrieval
but it can also be used for updation of data.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / vipin kumar ( m.c.a)
Query is a PL/SQL statement using to perform an action.
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / reddibasha
A Query is a SELECT statement, which is always successful.
| Is This Answer Correct ? | 1 Yes | 9 No |
In Oracle 10g, "g" Stands for what?
I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.
Explain a private synonyms?
Explain can a view based on another view?
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
What are the components of physical database structure in the Oracle database?
Can we call procedure inside function in oracle?
Explain overloading. Can functions be overloaded?
How to turn on or off recycle bin for the session?
What are the major difference between truncate and delete?
How to connect to a remote server?
How to write an inner join with the where clause in oracle?