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 |
How can we delete duplicate rows in a table?
What is program global area (pga) in oracle?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
Explain the relationship among Database, Tablespace and Data file?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
What are the oracle differences between nvl and coalesce
select trunc(round(156.00,-1),-1) from dual;
SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>
how to retrive xml data for using sql query?
In Oracle 10g, "g" Stands for what?
What is a materialised view?