🔹 Join the OracleApps88 Telegram Group - Stay up to date with the latest on Oracle EBS R12 and Oracle Cloud/Fusion Applications. 📌 Telegram Group : https://t.me/OracleApps88

💡 Facing issues copying code/scripts or viewing posts? We're here to help!
📬 Contact on Telegram : https://t.me/apps88
📱 Telegram/WhatsApp: +91 905 957 4321
📧 Email Support: OracleApp88@Yahoo.com

Sunday, October 30, 2011

Using Clustures in Oracle

create cluster c1(deptno number(2));

create cluster c2( empno number(4));

create table dept(deptno number(2) primary key,
dname varchar2(20), loc varchar2(20))
cluster c1(deptno);

create table emp
(empno number(4) primary key,
 ename varchar2(20),job varchar2(20),
sal number(12,2),comm number(12,2),
deptno number(2) references dept)
cluster c1(deptno),c2(empno);

create table incr (empno number(4) references emp,
amt number(10,2)) cluster c2(empno);

create index c1_idx on cluster c1;

create index c2_idx on cluster c2;

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect