create database link linkname connect to 'username' identified by 'password' using 'hostname';
using this u can connect to a db and use the tables
Type: Posts; User: suneelgopavaram; Keyword(s):
create database link linkname connect to 'username' identified by 'password' using 'hostname';
using this u can connect to a db and use the tables
There r so many advanced topics in 9i over 8i. They r nvl2(),nullif(),cube(),
rollup(),grouping(),dense_Rank(),rank(),tan2(),Outerjoins like this many .This is important question for any interview.U...
The replies u got r correct. u can't change the physical position of a column.
There is no min requirement like that.If u want the output as a matrix then by using decode inside an inline view u can get the result
collections are called as composite datatypes like varray,record,nested tables.
examples u can write on ur own by using all the above.
syntax :
type typename is record(.....)
type typename is...
If u want to do manipulations to more than one row its compulsory to use cursors. without cursors we can't perform manipulations for more than one row.If u don't want to use a cursor then u have to...
U can use cursors more effectively for this purpose.U can use %notfound attribute of cursor to break the loop like
loop
update...
exit when cursorname%notfound
end loop;
services of sql server are called as instances.all the services posted to the server cannot be known only information regarding to the particular owner of database will be shown I think so.If this is...