electronic data sharding [message #657693] |
Fri, 18 November 2016 13:31 |
|
sudeepto chattaraj
Messages: 9 Registered: November 2016
|
Junior Member |
|
|
how to swap the rows using plsql..
i have made 3 tables..bt i want to swap the values of the rows..how could i swap it???
create table department (dept_id varchar2(50) primary key,dept_name varchar2(50),bank_id varchar2(50) REFERENCES bank1(bank_id) ,doj date);
create table bank1(bank_id varchar2(50) primary key,bankname varchar2(50),sal varchar2(50),customername varchar2(50),phno number(10),email varchar2(50));
create table employee(emp_id varchar2(50) primary key,dept_id varchar2(50) REFERENCES department(dept_id),empfirstname varchar2(50),emplastname varchar2(50),sal number(12),phno number(10),email varchar2(50),bank_id varchar2(50)REFERENCES bank1(bank_id));
insert into bank1 values(:bank_id,:dept_name,:bankname,:customername,:phno,:email);
insert into department values(:dept_id,:dept_name,:bank_id,:doj);
insert into employee values(:emp_id,:dept_id,:empfirstname,:emplastname,:sal,:phno,:email,:bank_id);
but how could i swap the values..?????
-
Attachment: project.txt
(Size: 0.82KB, Downloaded 1128 times)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: electronic data sharding [message #657775 is a reply to message #657706] |
Tue, 22 November 2016 07:26 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
sudeepto chattaraj wrote on Fri, 18 November 2016 14:26i hve post the attchmnt..it contns the code.. u make the table send me the code..
i cant .. please help me
You STILL have not stated the rule by which you transform the data from what you have to what you want. You've given an example of "I start with <this> and want to get it to <that>" but you have yet to provide a rule or specification of how the end result relates to the beginning.
|
|
|