HOw to get /select the nth row from the table ?how to select first n rows ,last n rows from a table
Latest Answer: in cases where a very small table is being joind to large table ,the oracle hash join will often dramatically speedup the querry hash join are for faster than nested loops join same cashes.regards pratyush singh ...
Latest Answer: Hi guys I am new to Oracle. Thank you for sharing your knowledge. ...
Latest Answer: The scope of cursor is limited to a block/ programme. here block/ programme means upto a end of procedure/function and only one fixed query can be attached to that cursor.where as the scope of ref cursor is global. Generally ref cursor is used with ...
Latest Answer: materialized view is physical duplicate data in a table view is logical representation of table ...
Latest Answer: View is a subset of data derived from tableupdate of data in table we can see in in viewbut update in view can not see in table. ...
How to decrypt the password on oracle 8/8i in system/scott user?what is the query fired to see the password?
Latest Answer: In sqlserver 2005 we can use as follows to retreive the date part of the given date or sys dateselect datepart(dd,getdate()) ...
Latest Answer: It implicitly construct the join condition on the 2 tables taking all the column with same name into consideration.Natural join is also called blind join.select employee_id,last_name,department_name from employees natural join departments; ...
Latest Answer: Inner jon Or equi join is The query that retrives the rows that exact match using (=) sign in where clause ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
