VivekPrabhu
Last Activity: Feb 2 '07, 02:05 AM
Joined: Jan 10 '07
Location:
-
All databases are supposed to follow the standard SQL syntax. However , certain DBs like the ones from MicroSoft have built in commands which are specific to their particular brand of Databases which renders it vendor specific. -
Okay . This one is straight. A Primary key is that ----- Primary i.e. ONLY one. I think what you want is to know if mulitple columns can combine to form one Primary key . The answer is yes, and that is a composite key. A unique key is unique but maybe a foreign key as well. A foreign key is a key that refers to a primary key in some other table. Hope this is useful to youLeave a comment:
-
There are various uses of the spool command. You can spool out to a file , then use normal SQL to get small reports with some formatting. For example
SQL> Spool /ora/spool.txt
SQL> select "List of employees drawing more than Rs 10000" from dual;
SQL> select EmpNo,Name from Emp where Salary > 10000;
SQL> spool off;
vi the spool.txt file and delete the "select" lines and...Leave a comment:
No activity results to display
Leave a comment: