|
Question |
Rating |
View Answer |
|
What are the disadvantages of the client/server model ? |
|
View Answer |
|
What is CHECK Constraint? |
|
View Answer |
|
Table1
Date Inv No. Sr.No.
01/04/2009 1 1 01/04/2009 2 2 0304/2009 3 1 04/04/2009 4 1 04/4/2009 5 2
table2 01/04/2009 1 1 01/04/2009 1 1 01/04/2009 1 1 01/04/2009 2 2 01/04/2009 2 2 01/04/2009 2 2 0304/2009 3 1 04/04/2009 4 1 04/04/2009 4 1 04/4/2009 5 2
I want sql query or PL/SQL Block to update the Sr.No. field automatically as shown in the above tables. Sr.No is not entered Manually. This sr.No. should be updated by selecting the date range i.e. from date and two date. |
|
View Answer |
|
What is a transaction ? |
|
View Answer |
|
What are the different index configurations a table can have? |
|
View Answer |
|
How to find second maximum value from a table?
|
|
View Answer |
|
What is the default format of date in Oracle? How can I change my default date format?
|
|
View Answer |
|
What is difference between DBMS and RDBMS?
|
|
View Answer |
|
What is the value of comm and sal after executing the following query if the initial value of ‘sal’ is 10000 UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1; |
|
View Answer |
|
What is the difference between file server and a database server ? |
|
View Answer |
|
What are the advantages of using Stored Procedures? |
|
View Answer |
|
What is diffrence between Co-related sub query and nested sub query??
|
|
View Answer |
|
Whats the back end processes when we type "Select * from Table"?
|
|
View Answer |
|
What is the advantage to use trigger in your PL?
|
|
View Answer |
|
How write a SQL statement to query the result set and display row as columns and columns as row?
|
|
View Answer |
|
Difference between Stored Procedure and Trigger
|
|
View Answer |
|
Which command displays the SQL command in the SQL buffer, and then executes it |
|
View Answer |
|
What is the difference between varchar & varchar2? |
|
View Answer |
|
Explain about data retrieval? |
|
View Answer |
|
What are the different index configurations a table can have? |
|
View Answer |