Basic SQL Posted by MOHAMMED ABDUL HAMEED on 11:46 PM

Basic SQL : 

create table hyd.info
(
id varchar(255),
name varchar(255),
city varchar(255)
);


insert into hyd.info
(id,name,city)
values('1','hameed','hyd');


update hyd.info
set id='123',name='abdulhameed'
where name=hameed;


delete from hyd.info
where id='123' and name='abdulhameed';

VMware Tools Installation Posted by MOHAMMED ABDUL HAMEED on 10:43 PM

Database Links Posted by MOHAMMED ABDUL HAMEED on 6:52 AM

Database Link  :

A Database Link is a pointer that defines one way communication path from an oracle database server to another database server.

It simply means if we created a database link  'Hyd' from Database X to Database Y then database x can access information from database Y but not Vice versa.

Type of Database Link :

Private Database Link : It can only be access by the user that created the database link.

Public Database Link : All the database users can access that link.

Create a Database Link:

CREATE DATABASE LINK Hyd CONNECT TO scott IDENTIFIED BY tiger USING 'stage';

Drop a Database Link:

DROP DATABASE LINK Hyd;