I have been getting an erro when I try and link:
create table Faculty_Specialty (I_Name varchar2(20) not null, Specialty varchar2(40) not null);
using :
alter table faculty_specialty modify (foreign key (I_Name) references faculty);
to:
Create table Faculty (I_Name varchar2(20) primary key);
The following error occurs:
SQL> alter table faculty_specialty modify (foreign key (I_Name) references faculty (I_Name));
alter table faculty_specialty modify (foreign key (I_Name) references faculty (I_Name))
*
ERROR at line 1:
ORA-02298: cannot validate (ORDB029.SYS_C0027281) - parent keys not found
I Know it's elementry but I can figure out why this is happening.....
Selecting an "empty" date formated field
How do you select an "empty" date field? I've tried the few ways I can think.
How would I do "Users not logged in since *** delete them"
I know how I would set this up, and delete the user roughly.I'll create a table called "Users Status" with ID, Username, date registered, and last logged in collumns. Last Logged in will be
Generate PDF
Hi guys,I would like to know if there is a way to generate pdf when clicking on a link. In fact, I would like to be able to click on a link and generate a pdf file with information from my database,
function not returning the correct value
I have a program that needs to return a value from a function. I have an output statement inside the function just to see what the output is, and it sems to work. However, upon returning the function
simple php table loop
Hi all,I've the following code <?php // Create category options $query = "SELECT * FROM categories ORDER BY category ASC"; $result = mysql_query
newbie error
what is wrong with this code ? <html><body><?php$conn=odbc_connect('Towel','','');if (!$conn) {exit("Connection Failed: " . $conn);}$sql="SELECT *
explode() function problem maybe
Hi I'm having trouble searching my database. When I type two words in the search field it only searches for the second word. For example: if I typed london zoo , it will only search for zoo.Is this
How can i steam a video on my PHP site? (non YouTube)
Basically I have a PHP site and don't want to give page rank to YouTube. I just want to stream a basic video. If you know of any methods, please list file types those methods allow, the more the
Search in the PHP Files
have to search asterisk(*) in the php code of the php files .
Pass sql into pl/sql and create RMAN duplicate script.
Hi,
