Tue Mar 19 05:55:05 2024
EVENTS
 FREE
SOFTWARE
INSTITUTE

POLITICS
JOBS
MEMBERS'
CORNER

MAILING
LIST

NYLXS Mailing Lists and Archives
NYLXS Members have a lot to say and share but we don't keep many secrets. Join the Hangout Mailing List and say your peice.

DATE 2014-12-01

LEARN

2024-03-19 | 2024-02-19 | 2024-01-19 | 2023-12-19 | 2023-11-19 | 2023-10-19 | 2023-09-19 | 2023-08-19 | 2023-07-19 | 2023-06-19 | 2023-05-19 | 2023-04-19 | 2023-03-19 | 2023-02-19 | 2023-01-19 | 2022-12-19 | 2022-11-19 | 2022-10-19 | 2022-09-19 | 2022-08-19 | 2022-07-19 | 2022-06-19 | 2022-05-19 | 2022-04-19 | 2022-03-19 | 2022-02-19 | 2022-01-19 | 2021-12-19 | 2021-11-19 | 2021-10-19 | 2021-09-19 | 2021-08-19 | 2021-07-19 | 2021-06-19 | 2021-05-19 | 2021-04-19 | 2021-03-19 | 2021-02-19 | 2021-01-19 | 2020-12-19 | 2020-11-19 | 2020-10-19 | 2020-09-19 | 2020-08-19 | 2020-07-19 | 2020-06-19 | 2020-05-19 | 2020-04-19 | 2020-03-19 | 2020-02-19 | 2020-01-19 | 2019-12-19 | 2019-11-19 | 2019-10-19 | 2019-09-19 | 2019-08-19 | 2019-07-19 | 2019-06-19 | 2019-05-19 | 2019-04-19 | 2019-03-19 | 2019-02-19 | 2019-01-19 | 2018-12-19 | 2018-11-19 | 2018-10-19 | 2018-09-19 | 2018-08-19 | 2018-07-19 | 2018-06-19 | 2018-05-19 | 2018-04-19 | 2018-03-19 | 2018-02-19 | 2018-01-19 | 2017-12-19 | 2017-11-19 | 2017-10-19 | 2017-09-19 | 2017-08-19 | 2017-07-19 | 2017-06-19 | 2017-05-19 | 2017-04-19 | 2017-03-19 | 2017-02-19 | 2017-01-19 | 2016-12-19 | 2016-11-19 | 2016-10-19 | 2016-09-19 | 2016-08-19 | 2016-07-19 | 2016-06-19 | 2016-05-19 | 2016-04-19 | 2016-03-19 | 2016-02-19 | 2016-01-19 | 2015-12-19 | 2015-11-19 | 2015-10-19 | 2015-09-19 | 2015-08-19 | 2015-07-19 | 2015-06-19 | 2015-05-19 | 2015-04-19 | 2015-03-19 | 2015-02-19 | 2015-01-19 | 2014-12-19 | 2014-11-19 | 2014-10-19

Key: Value:

Key: Value:

MESSAGE
DATE 2014-12-19
FROM Ruben
SUBJECT Subject: [LIU Comp Sci] Oracle Files for the Homework and Oracle Resources
From owner-learn-outgoing-at-mrbrklyn.com Fri Dec 19 16:43:09 2014
Return-Path:
X-Original-To: archive-at-mrbrklyn.com
Delivered-To: archive-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix)
id A508C161169; Fri, 19 Dec 2014 16:43:09 -0500 (EST)
Delivered-To: learn-outgoing-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix, from userid 28)
id 86A7016117A; Fri, 19 Dec 2014 16:43:09 -0500 (EST)
Delivered-To: learn-at-nylxs.com
Received: from mail-qg0-f49.google.com (mail-qg0-f49.google.com [209.85.192.49])
by mrbrklyn.com (Postfix) with ESMTP id 22AD3161169
for ; Fri, 19 Dec 2014 16:43:07 -0500 (EST)
Received: by mail-qg0-f49.google.com with SMTP id a108so1234743qge.8
for ; Fri, 19 Dec 2014 13:43:05 -0800 (PST)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=1e100.net; s=20130820;
h=x-gm-message-state:message-id:date:from:user-agent:mime-version:to
:subject:content-type;
bh=SjfSU/plXY+7BVd4cP4NclgpM0XU6gv8/r3ysa85L84=;
b=BUtvbxvuuEKeot4Pjt3l4umEdwl3KE3mIJjYkrHyCGgqzQ+nGSNalIxsYLn6ucz/Im
uSrUxuiUMuc7u2atWjPgLDNKbiQuOmLvCzySfShklJnyyxBzptD0/SfIO11v9jbMKajU
xAZV2tYOvHc9m5PAjMOUYJucF+jK9MqmZs9FWjdXH81QvgsS7GT1xq65Ga6aewBMPPT8
9laJo0bzze2z/eGsPdjWgaSyBZgFoLRlnvDc1GAjjA7fHXr52bWRvBm/HgA+P3rf535A
DCGeciflKFqI8AYgr0FUcnFfsF78+EJk9tPSVkPz90y6/5/8594zqxO30gWoqIvccyBD
7kmw==
X-Gm-Message-State: ALoCoQmw02PMq0docnmQ1I4JclDqKr/wKSJGJK6QLIdz2ZiXHM/QpqkdEkKLNPDb7LlquTgicJzZ
X-Received: by 10.224.64.131 with SMTP id e3mr17569703qai.103.1419025385331;
Fri, 19 Dec 2014 13:43:05 -0800 (PST)
Received: from [10.0.0.42] ([96.57.23.82])
by mx.google.com with ESMTPSA id a103sm10484369qge.29.2014.12.19.13.43.03
(version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
Fri, 19 Dec 2014 13:43:04 -0800 (PST)
Message-ID: <54949BFC.8040509-at-my.liu.edu>
Date: Fri, 19 Dec 2014 16:43:24 -0500
From: Ruben
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.2.0
MIME-Version: 1.0
To: learn-at-nylxs.com, Ping-Tsai Chung
Subject: [LIU Comp Sci] Oracle Files for the Homework and Oracle Resources
Content-Type: multipart/mixed;
boundary="------------040400020104020402050804"
Sender: owner-learn-at-mrbrklyn.com
Precedence: bulk
Reply-To: learn-at-mrbrklyn.com

This is a multi-part message in MIME format.
--------------040400020104020402050804
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

How do you see in Oracle the primary and foreign constraints? I am
attaching the Oracle files i used to create the fundmental databases as
they exist on this hangout titled Company Schema.

Everything was done in SQLPLUS because the APEX thingie is fundamentally
broken.

***Some notes on the Oracle Installation and creations on Linux***

Note - Oracle STUPID, REALLY STUPID. The httpd part of oracle and the
server will not work is your hostname and ipaddress is not CORRECT.
Fix that first. Some OS's ignore /etc/hostname (or even /etc/hosts -
thank you system fucking D)

First, the current rpm from oracle is at
http://www.nylxs.com/docs/grad_school/database/oracle-xe-11.2.0-1.0.x86_64.rpm.zip

In order to install on any pacman.arch based system one needs to rebuild
this and create a pacman package file

drop the rpm into the same directory as the pacman file

***make the oracle user with a home directory

This the pacman build file. It is missing the RPM so you need BOTH

http://www.nylxs.com/docs/grad_school/database/oracle-xe.tar.gz

untar it
tar -xzvf oracle-xe.tar.gz
move the the directory it creates

[ruben-at-laptop ~]$ cd oracle-xe

mv the rpm there

mv ../oracle-xe-11.2.0-1.0.x86_64.rpm.zip ./

[ruben-at-laptop oracle-xe]$ ls -al
total 847860
drwxr-xr-x 4 ruben users 4096 20.11.2014 13:50 ./
drwx------ 27 ruben users 4096 22.11.2014 21:00 ../
drwxr-xr-x 3 ruben users 4096 20.11.2014 13:50 pkg/
drwxr-xr-x 6 ruben users 4096 20.11.2014 13:49 src/
-rw-r--r-- 1 ruben users 438 14.04.2013 10:34 listener.ora
-rw-r--r-- 1 ruben users 156 14.04.2013 10:34 oracle_env.csh
-rw-r--r-- 1 ruben users 156 14.04.2013 10:34 oracle_env.sh
-rw-r--r-- 1 ruben users 2608 14.04.2013 11:44 oracle.install
-rw-r--r-- 1 ruben users 19759 14.04.2013 10:34 oracle-xe
-r--r--r-- 1 ruben users 315891481 20.11.2014 09:07
oracle-xe-11.2.0-1.0.x86_64.rpm.zip
-rw-r--r-- 1 ruben users 37 14.04.2013 10:34 oracle-xe.conf
-rw-r--r-- 1 ruben users 144 14.04.2013 10:38 oracle-xe.service
-rw-r--r-- 1 ruben users 2994 17.05.2014 05:19 PKGBUILD


[ruben-at-laptop oracle-xe] makepkg -s

Now you have the .xz file that pacman needs to make oracle and configure it
[ruben-at-laptop oracle-xe]$ ls -al
total 847860
drwxr-xr-x 4 ruben users 4096 20.11.2014 13:50 ./
drwx------ 27 ruben users 4096 22.11.2014 21:00 ../
drwxr-xr-x 3 ruben users 4096 20.11.2014 13:50 pkg/
drwxr-xr-x 6 ruben users 4096 20.11.2014 13:49 src/
-rw-r--r-- 1 ruben users 438 14.04.2013 10:34 listener.ora
-rw-r--r-- 1 ruben users 156 14.04.2013 10:34 oracle_env.csh
-rw-r--r-- 1 ruben users 156 14.04.2013 10:34 oracle_env.sh
-rw-r--r-- 1 ruben users 2608 14.04.2013 11:44 oracle.install
-rw-r--r-- 1 ruben users 19759 14.04.2013 10:34 oracle-xe
-rw-r--r-- 1 ruben users 276123404 20.11.2014 13:59
oracle-xe-11.2.0_1.0-2-x86_64.pkg.tar.xz <====LOOOOK
-r--r--r-- 1 ruben users 315891481 20.11.2014 09:07
oracle-xe-11.2.0-1.0.x86_64.rpm.zip
-rw-r--r-- 1 ruben users 37 14.04.2013 10:34 oracle-xe.conf
-rw-r--r-- 1 ruben users 144 14.04.2013 10:38 oracle-xe.service
-rw-r--r-- 1 ruben users 2994 17.05.2014 05:19 PKGBUILD

[ruben-at-laptop oracle-xe]$ sudo pacman -U
oracle-xe-11.2.0_1.0-2-x86_64.pkg.tar.xz

Run the '/etc/rc.d/oracle-xe configure' as root, REMEMBER TO CHOOSE THE
PASSWORD FOR SYS AND SYSTEM CONTAINS

change you groups and password files. make sure you and oracle is in
the /etc/groups


[ruben-at-laptop oracle-xe]$ cat /etc/group
...
colord:x:124:
docker:x:142:
oinstall:x:1002:
dba:x:1003:oracle,ruben

[ruben-at-laptop oracle-xe]$
Important Oracle SQL Cheat Sheet:

* define_editor='vi'
Better Add it to a oracle start script
* make vi your permanent editor you have to write "define _editor='vi'"
into the file $ORACLE_HOME/sqlplus/admin/glogin.sql.

Fixing a NOT NULL Constraint:
___________________________________________________________________________________________________________
Select table_name,constraint_name,search_condition from user_constraints
where table_name = 'EMPLOYEE'
SQL> /

TABLE_NAME CONSTRAINT_NAME
------------------------------ ------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
EMPLOYEE SYS_C007007
"FNAME" IS NOT NULL

EMPLOYEE SYS_C007008
"LNAME" IS NOT NULL

EMPLOYEE SYS_C007009
"SSN" IS NOT NULL

etc etc
SQL> alter table EMPLOYEE drop constraint SYS_C007007;
__________________________________________________________________________________________________________


or

Alter table modify null

*TABLESSPACES CREATING:

SQL> CREATE TABLESPACE ts4 DATAFILE '/oradata/ts4_01.dbf' SIZE 50M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

*Tables in a tablespace

select tablespace_name, table_name from all_tables where TABLESPACE_NAME
= 'CHUNG'
Adding Default tablespace to a user:

* Change users default tablespace:
SQL> SELECT USERNAME,DEFAULT_TABLESPACE FROM DBA_USERS WHERE
USERNAME='SCOTT';

SQL> alter user scott default tablespace CHUNG;




* FIND THE PRIMARY KEYS
SELECT cols.table_name, cols.column_name, cols.position, cons.status,
cons.owner
FROM all_constraints cons, all_cons_columns cols
WHERE cons.constraint_type = 'P'
AND cons.constraint_name = cols.constraint_name
AND cons.owner = cols.owner
ORDER BY cols.table_name, cols.position;

This sucks and is part of why oracle sucks







--------------040400020104020402050804
Content-Type: text/x-sql;
name="works_on_pk.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="works_on_pk.sql"

alter TABLE WORKS_ON add CONSTRAINT pk_works_on PRIMARY KEY(essn,pno)
/



--------------040400020104020402050804
Content-Type: text/x-sql;
name="works_on_insert.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="works_on_insert.sql"

INSERT INTO WORKS_ON VALUES(123456789 ,1 ,32.5 );
INSERT INTO WORKS_ON VALUES(123456789 ,2 ,7.5 );
INSERT INTO WORKS_ON VALUES(666884444 ,3 ,40.0 );
INSERT INTO WORKS_ON VALUES(453453453 ,1 ,20.0 );
INSERT INTO WORKS_ON VALUES(453453453 ,2 ,20.0 );
INSERT INTO WORKS_ON VALUES(333445555 ,2 ,10.0 );
INSERT INTO WORKS_ON VALUES(333445555 ,3 ,10.0 );
INSERT INTO WORKS_ON VALUES(333445555 ,10 ,10.0 );
INSERT INTO WORKS_ON VALUES(333445555 ,20 ,10.0 );
INSERT INTO WORKS_ON VALUES(999887777 ,30 ,30.0 );
INSERT INTO WORKS_ON VALUES(999887777 ,10 ,10 );
INSERT INTO WORKS_ON VALUES(987987987 ,10 ,35.0 );
INSERT INTO WORKS_ON VALUES(987987987 ,30,5.0 );
INSERT INTO WORKS_ON VALUES(987654321 ,30 ,20 );
INSERT INTO WORKS_ON VALUES(987654321 ,20 ,15 );
INSERT INTO WORKS_ON VALUES(888665555 ,20 ,NULL );



--------------040400020104020402050804
Content-Type: text/x-sql;
name="show_keys.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="show_keys.sql"

SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner
FROM all_constraints cons, all_cons_columns cols
WHERE cons.constraint_type = 'P'
AND cols.table_name = 'EMPLOYEE'
AND cons.constraint_name = cols.constraint_name
AND cons.owner = cols.owner
ORDER BY cols.table_name, cols.position
/



--------------040400020104020402050804
Content-Type: text/x-sql;
name="show_keys_ruben.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="show_keys_ruben.sql"

SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner
FROM all_constraints cons, all_cons_columns cols
WHERE cons.constraint_type = 'P'
AND cons.constraint_name = cols.constraint_name
AND cons.owner = 'RUBEN'
ORDER BY cols.table_name, cols.position
/



--------------040400020104020402050804
Content-Type: text/x-sql;
name="project_pk.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="project_pk.sql"

alter TABLE PROJECT add CONSTRAINT pk_project PRIMARY KEY(pnumber)



--------------040400020104020402050804
Content-Type: text/x-sql;
name="project_insert.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="project_insert.sql"

INSERT INTO PROJECT VALUES('ProductX' ,1 ,'Bellaire',5 );
INSERT INTO PROJECT VALUES('ProductY' ,2 ,'Sugarland',5 );
INSERT INTO PROJECT VALUES('Productz' ,3 ,'Houston',5 );
INSERT INTO PROJECT VALUES('Computerization' ,10 ,'Stafford',4 );
INSERT INTO PROJECT VALUES('Reorganization' ,20 ,'Houston', 1 );
INSERT INTO PROJECT VALUES('Newbenifits' ,30 ,'Stafford',4 );



--------------040400020104020402050804
Content-Type: text/x-sql;
name="empy.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="empy.sql"

create table employee(
fname varchar2(20) NOT NULL,
minit char(1),
lname varchar2(20) NOT NULL,
ssn number(9) NOT NULL,
bdate date NOT NULL,
address varchar2(50) NOT NULL,
sex char(1) NOT NULL,
salary float(12) NOT NULL,
superssn number(9),
dno number(2)
);

create table dep_locations(
dnumber number(2) NOT NULL,
dlocation varchar2(20) NOT NULL
);

create table department(
dname varchar2(15) NOT NULL,
dnumber number(2) NOT NULL,
mgrssn number(9),
mgrstartdate date
);

create table works_on(
essn number(9),
pno number(2),
hours float(5)
);

create table project(
pname varchar2(20) NOT NULL,
pnumber number(2) NOT NULL,
plocation varchar2(15) NOT NULL,
dnum number(2)
);

create table dependent(
essn number(9) NOT NULL,
dependent_name varchar2(10) NOT NULL,
sex char(1) NOT NULL,
bdate date NOT NULL,
relationship varchar2(15) NOT NULL
);


commit

/





--------------040400020104020402050804
Content-Type: text/x-sql;
name="empy_insert.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="empy_insert.sql"

insert into employee values ('John', 'B', 'Smith', 123456789, TO_DATE('1965-01-09', 'YYYY-MM-DD'), '731 Fondenm Houston, Tx', 'M', 3000, 333445555, 5);
insert into employee values ('Frankin', 'T', 'Wrong', 333445555 , TO_DATE('1955-12-08', 'YYYY-MM-DD'), '638 Voss, Houston, Tx', 'M', 4000, 888685555 , 5 );
insert into employee values ('Alica', 'J', 'Zelaya',999887777 , TO_DATE('1968-07-19', 'YYYY-MM-DD'), '3321 Castle Springs, Tx', 'F', 2500 ,987654321 ,4 );
insert into employee values ('Jenifer', 'S', 'Wallace', 987654321, TO_DATE('1961-05-20', 'YYYY-MM-DD'), '291 Barry St, Bellaire, Tx', 'F', '4300', 888685555 ,4 );
insert into employee values ('Ramesh', 'K', 'Narayan',556884444 , TO_DATE('1962-09-15', 'YYYY-MM-DD'), '975 Fire Oak, Humble, Tx', 'M', 3800,333445555 ,5 );
insert into employee values ('Joyce', 'A', 'English', 453453453, TO_DATE('1972-07-31', 'YYYY-MM-DD'), '5631 Rice St, Houston, Tx', 'F',2500 ,333445555 ,5 );
insert into employee values ('Ahmad', 'V', 'Jabbar', 987987987, TO_DATE('1969-03-29', 'YYYY-MM-DD'), '980 Dallas Street, Houston, Tx', 'M',2500, 987654321 , 5 );
insert into employee values ('James', 'E', 'Borg', 888665555, TO_DATE('1937-11-10', 'YYYY-MM-DD'), '450 Stone Street, Houston, Tx', 'M',55000 ,NULL , 1 );
insert into employee values ('Ruben', 'I', 'Safir', 264642882, TO_DATE('1963-04-01', 'YYYY-MM-DD'), '1580 East 19th Street, Brooklyn, NY', 'M',200000 ,NULL , 1 );



--------------040400020104020402050804
Content-Type: text/x-sql;
name="employee_pk.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="employee_pk.sql"

alter table employee add constraint pk_employee primary key (ssn)
/



--------------040400020104020402050804
Content-Type: text/x-sql;
name="dept_locations_insert.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="dept_locations_insert.sql"

INSERT into DEP_LOCATIONS VALUES( 1, 'HOUSTON');
INSERT into DEP_LOCATIONS VALUES( 4, 'STADFORD');
INSERT into DEP_LOCATIONS VALUES( 5, 'BELLAIRE');
INSERT into DEP_LOCATIONS VALUES( 5, 'SUGARLAND');
INSERT into DEP_LOCATIONS VALUES( 5, 'HOUSTON');



--------------040400020104020402050804
Content-Type: text/x-sql;
name="dept_insert.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="dept_insert.sql"

INSERT INTO DEPARTMENT VALUES( 'Research', 5, 333445555, TO_DATE('1988-05-22', 'YYYY-MM-DD'));
INSERT INTO DEPARTMENT VALUES( 'Administration', 4, 987654321, TO_DATE('1995-01-01', 'YYYY-MM-DD'));
INSERT INTO DEPARTMENT VALUES( 'Headquaters', 4, 888665555, TO_DATE('1988-05-22', 'YYYY-MM-DD'));





--------------040400020104020402050804
Content-Type: text/x-sql;
name="dep_locations_keys.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="dep_locations_keys.sql"

alter TABLE WORKS_ON add CONSTRAINT pk_works_on PRIMARY KEY(essn,pno)
/



--------------040400020104020402050804
Content-Type: text/x-sql;
name="dependent_pk.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="dependent_pk.sql"

alter TABLE DEPENDENT add CONSTRAINT pk_dependent PRIMARY KEY(essn,dependent_name)



--------------040400020104020402050804
Content-Type: text/x-sql;
name="dependent_insert.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="dependent_insert.sql"

INSERT INTO DEPENDENT VALUES(333445555, 'Alice','F',TO_DATE('1986-04-05','YYYY-MM-DD' ),'DAUGHTER');
INSERT INTO DEPENDENT VALUES(333445555, 'Theodore','M',TO_DATE('1983-10-25','YYYY-MM-DD' ),'SON');
INSERT INTO DEPENDENT VALUES(333445555, 'JOY','F',TO_DATE('1958-05-03','YYYY-MM-DD' ),'SPOUSE');
INSERT INTO DEPENDENT VALUES(987654321, 'Abner','M',TO_DATE('1942-02-28','YYYY-MM-DD' ),'SPOUSE');
INSERT INTO DEPENDENT VALUES(123456789, 'Michael','M',TO_DATE('1988-01-04','YYYY-MM-DD' ),'SON');
INSERT INTO DEPENDENT VALUES(123456789, 'Alice','F',TO_DATE('1988-12-30','YYYY-MM-DD' ),'DAUGHTER');
INSERT INTO DEPENDENT VALUES(123456789, 'Elizabeth','F',TO_DATE('1967-05-05','YYYY-MM-DD' ),'SPOUSE');



--------------040400020104020402050804
Content-Type: text/x-sql;
name="department_pk.sql"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="department_pk.sql"

alter TABLE DEPARTMENT add CONSTRAINT pk_department PRIMARY KEY(dnumber)
/



--------------040400020104020402050804--

  1. 2014-12-02 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] Arch Study tonight
  2. 2014-12-02 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Memory Notes et al
  3. 2014-12-02 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Re: Sorry for the last reply
  4. 2014-12-06 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] All the notes through External Memory
  5. 2014-12-06 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Parity Bit Algebra
  6. 2014-12-06 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Parity Bit Algebra
  7. 2014-12-06 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Parity Bit Algebra
  8. 2014-12-06 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Parity Bit Algebra
  9. 2014-12-06 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Parity Bit Algebra
  10. 2014-12-06 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Parity Bit Algebra
  11. 2014-12-06 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Parity Bit Algebra
  12. 2014-12-06 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Parity Bit Algebra
  13. 2014-12-06 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Parity Bit Algebra
  14. 2014-12-06 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Parity Bit Algebra
  15. 2014-12-06 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Parity Bit Algebra
  16. 2014-12-06 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Parity Bit Algebra
  17. 2014-12-06 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Parity Bit Algebra
  18. 2014-12-06 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Parity Bit Algebra
  19. 2014-12-06 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Parity Bit Algebra
  20. 2014-12-06 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Parity Bit Algebra
  21. 2014-12-06 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Parity Bit Algebra
  22. 2014-12-06 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] All the notes through External Memory
  23. 2014-12-06 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Parity Bit Algebra
  24. 2014-12-07 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Computer Available
  25. 2014-12-07 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Computer Available
  26. 2014-12-07 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Computer Available
  27. 2014-12-07 mrbrklyn-at-panix.com Subject: [LIU Comp Sci] Upcoming Events for Oracle Professionals
  28. 2014-12-08 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Memorize Optcode
  29. 2014-12-08 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Memorize Optcode
  30. 2014-12-08 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Memorize Optcode
  31. 2014-12-08 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Memorize Optcode
  32. 2014-12-08 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Memorize Optcode
  33. 2014-12-08 Kamran <kamran.mirzayev-at-my.liu.edu> Re: [LIU Comp Sci] Memorize Optcode
  34. 2014-12-08 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Memorize Optcode
  35. 2014-12-08 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Memorize Optcode
  36. 2014-12-08 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Memorize Optcode
  37. 2014-12-08 Ruben <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Memorize Optcode
  38. 2014-12-08 Ruben <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Memorize Optcode
  39. 2014-12-08 Ruben <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Memorize Optcode
  40. 2014-12-08 Kamran <kamran.mirzayev-at-my.liu.edu> Re: [LIU Comp Sci] Memorize Optcode
  41. 2014-12-08 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] UPerclassmen
  42. 2014-12-08 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] UPerclassmen
  43. 2014-12-08 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] UPerclassmen
  44. 2014-12-08 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] UPerclassmen
  45. 2014-12-08 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Arch Problem Solution for the final HW question
  46. 2014-12-08 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Foundation for OPTCODE and Machine Instruction
  47. 2014-12-08 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Memorize Optcode
  48. 2014-12-08 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Notes Done on In and Out, Operating Systemsm Modules and Memoery
  49. 2014-12-08 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] UPerclassmen
  50. 2014-12-09 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Anyone in school
  51. 2014-12-09 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] CPU Instructions - Notes for Chapter 14
  52. 2014-12-09 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Machine Instructions notes
  53. 2014-12-09 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Relative - PC addressing
  54. 2014-12-09 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] wifi
  55. 2014-12-10 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Answers to the final review questions
  56. 2014-12-10 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] database Hoem Work
  57. 2014-12-10 duodujames <duodujames-at-gmail.com> RE: [LIU Comp Sci] noone in class?
  58. 2014-12-10 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] UPerclassmen
  59. 2014-12-10 Maneesh Kongara <maneeshkongara-at-gmail.com> Subject: [LIU Comp Sci] Answers to the final review questions
  60. 2014-12-10 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] database Hoem Work
  61. 2014-12-10 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] Fwd: MINIPROJECT
  62. 2014-12-10 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] HW 6
  63. 2014-12-10 mrbrklyn-at-panix.com Subject: [LIU Comp Sci] MINIPROJECT
  64. 2014-12-10 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] noone in class?
  65. 2014-12-10 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] welcome jame
  66. 2014-12-10 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] [mrbrklyn-at-panix.com: HW Last one maybe 6?]
  67. 2014-12-11 Ruben Safir <mrbrklyn-at-panix.com> Fwd: Re: [LIU Comp Sci] Database Class concepts which are still unclear
  68. 2014-12-11 Ruben Safir <mrbrklyn-at-panix.com> Re: Fwd: Re: [LIU Comp Sci] Database Class concepts which are still
  69. 2014-12-11 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] Database Class concepts which are still unclear
  70. 2014-12-11 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] Database Class concepts which are still unclear
  71. 2014-12-11 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Database Class concepts which are still unclear
  72. 2014-12-11 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Database Class concepts which are still unclear
  73. 2014-12-11 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Fwd: Invitation: Flatiron Alumni Present!
  74. 2014-12-11 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Fwd: Re: Database Class concepts which are still unclear
  75. 2014-12-11 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Fwd: turning attibute values into relations?
  76. 2014-12-11 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] jobs
  77. 2014-12-12 James Kwabena Duodu <duodujames-at-gmail.com> Re: [LIU Comp Sci] Answers to the final review questions
  78. 2014-12-12 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] .NET and C# free implimentation
  79. 2014-12-12 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Calling Upper Classman
  80. 2014-12-12 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Fwd: Re: n-ary operations
  81. 2014-12-12 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Fwd: Re: Oracle XE Web Server
  82. 2014-12-12 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Fwd: Re: relational algrabra division?
  83. 2014-12-12 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] jobs
  84. 2014-12-12 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] lerning tools
  85. 2014-12-12 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] liu mailing list
  86. 2014-12-12 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Re: turning attibute values into relations?
  87. 2014-12-12 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Sunday Arch Finals Review Study Session
  88. 2014-12-13 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Answers to the final review questions
  89. 2014-12-13 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] (fwd) Re: relational algrabra division?
  90. 2014-12-13 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Base Conversations
  91. 2014-12-13 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Gates HW problems
  92. 2014-12-13 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Logic Gates
  93. 2014-12-13 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] old homework question
  94. 2014-12-14 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Answers to the final review questions
  95. 2014-12-14 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] NOTE ERROR:****Error in the Hamming notes on the final review
  96. 2014-12-15 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] Answers to the final review questions
  97. 2014-12-15 Kamran <kamran.mirzayev-at-my.liu.edu> Re: [LIU Comp Sci] study hall today
  98. 2014-12-15 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] study hall today
  99. 2014-12-15 Kamran <kamran.mirzayev-at-my.liu.edu> Re: [LIU Comp Sci] study hall today
  100. 2014-12-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] study hall today
  101. 2014-12-15 Kamran <kamran.mirzayev-at-my.liu.edu> Re: [LIU Comp Sci] study hall today
  102. 2014-12-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] study hall today
  103. 2014-12-15 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] study hall today
  104. 2014-12-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] study hall today
  105. 2014-12-15 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] study hall today
  106. 2014-12-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] study hall today
  107. 2014-12-15 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] study hall today
  108. 2014-12-15 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] errror in the hamming notes.
  109. 2014-12-15 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] [Samir.Iabbassen-at-liu.edu: RE: NOTE ERROR:****Error in the Hamming
  110. 2014-12-16 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Study Hall
  111. 2014-12-16 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Study Hall
  112. 2014-12-16 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] [mrbrklyn-at-panix.com: HW Last one maybe 6?]
  113. 2014-12-17 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] database class
  114. 2014-12-17 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] database class
  115. 2014-12-17 James Kwabena Duodu <duodujames-at-gmail.com> Re: [LIU Comp Sci] database class
  116. 2014-12-17 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] database class
  117. 2014-12-17 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] database class
  118. 2014-12-17 duodujames <duodujames-at-gmail.com> Re: [LIU Comp Sci] database class
  119. 2014-12-17 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] database class
  120. 2014-12-17 James Kwabena Duodu <duodujames-at-gmail.com> Re: [LIU Comp Sci] database class
  121. 2014-12-17 Maneesh Kongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] database class
  122. 2014-12-17 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] database class
  123. 2014-12-17 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] database class
  124. 2014-12-17 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] database class
  125. 2014-12-17 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] study hall today
  126. 2014-12-17 Kamran <kamran.mirzayev-at-my.liu.edu> Re: [LIU Comp Sci] study hall today
  127. 2014-12-17 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] why is this textbook just off the look
  128. 2014-12-17 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] why is this textbook just off the look
  129. 2014-12-17 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] database class
  130. 2014-12-17 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Fwd: Database HW6
  131. 2014-12-17 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] the silence
  132. 2014-12-17 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Traffic Lights Diagram
  133. 2014-12-17 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] why is this textbook just off the look
  134. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] in coming
  135. 2014-12-18 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] Need tutoring on Relational Calculus
  136. 2014-12-18 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] Need tutoring on Relational Calculus
  137. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Need tutoring on Relational Calculus
  138. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Need tutoring on Relational Calculus
  139. 2014-12-18 Sergei Glikstein <serge.gl-at-gmail.com> Re: [LIU Comp Sci] Normalization review
  140. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  141. 2014-12-18 Sergei Glikstein <serge.gl-at-gmail.com> Re: [LIU Comp Sci] Normalization review
  142. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  143. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  144. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  145. 2014-12-18 maneeshkongara <maneeshkongara-at-gmail.com> Re: [LIU Comp Sci] Normalization review
  146. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  147. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  148. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  149. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  150. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  151. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  152. 2014-12-18 Sergei Glikstein <serge.gl-at-gmail.com> Re: [LIU Comp Sci] Normalization review
  153. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  154. 2014-12-18 From: <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  155. 2014-12-18 Sergei Glikstein <serge.gl-at-gmail.com> Re: [LIU Comp Sci] Normalization review
  156. 2014-12-18 From: <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Normalization review
  157. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] BCNF
  158. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] in coming
  159. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] lunch
  160. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Need tutoring on Relational Calculus
  161. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Normalization review
  162. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Re: relational calculus
  163. 2014-12-18 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] relational calculus
  164. 2014-12-19 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] Oracle Files for the Homework and Oracle Resources
  165. 2014-12-22 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] Operating Systems Class
  166. 2014-12-30 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Creating a New OS: Final Projects for MS degree

NYLXS are Do'ers and the first step of Doing is Joining! Join NYLXS and make a difference in your community today!