coursors allows row by row processing of result set. disadvantage is that if select quries contain cursor then it will take more time b'se courser takes rountrip during one transation.if we fired...
Type: Posts; User: Sonawane.naresh82; Keyword(s):
coursors allows row by row processing of result set. disadvantage is that if select quries contain cursor then it will take more time b'se courser takes rountrip during one transation.if we fired...
store procedure are group of statements but it dose not returns any value.they performs only tasks while functios returns value.
hi,
table contains coloumns and rows .we denote it with the name TAB_xyz,view is temp table which uses table to retrive dta fasterly.the are started with nane VW_xyz generally.and synonym are alias...