Answer / manohar

to retrieve data from the database tables is called query

Answer / gangadhar mahabubabad

query is a language
by using query, we can write SQL statements

Answer / bhupali

Query is a sql statement which helps to retrieve data from
multiple table

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.

Answer / vipin kumar ( m.c.a)

Query is a PL/SQL statement using to perform an action.

Answer / reddibasha

A Query is a SELECT statement, which is always successful.

How can we delete duplicate rows in a table?

0 Answers  

What is program global area (pga) in oracle?

0 Answers  

Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 Answers  

Explain the relationship among Database, Tablespace and Data file?

4 Answers  

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.

3 Answers   Wipro,

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

1 Answers  

What are the oracle differences between nvl and coalesce

0 Answers  

select trunc(round(156.00,-1),-1) from dual;

2 Answers  

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>>>>

1 Answers   Infosys,

how to retrive xml data for using sql query?

3 Answers   IBM, TCS,

In Oracle 10g, "g" Stands for what?

5 Answers   Mphasis,

What is a materialised view?

5 Answers