upload sql database to the host environment

found this tool that makes it easier to upload sql database to the host environment
http://www.codeplex.com/sqlhost

oracle sqlplus

select TABLE_NAME, CONSTRAINT_NAME, STATUS
from USER_CONSTRAINTS
where TABLE_NAME like 'INVOICE';

the word after 'like' must be in capital, otherwise you won't get any result

make your DNN site home page style different to other pages

create a homepage skin with the LogoPane instead of the Logo skin token

all other pages will use a skin that has standard Logo skin token

yellow color flash when open a new page on DNN site

the background color of my site is mainly dark-red and black, the text is in white color. When i click on a link to open another page, the background always flash in yellow color and return back to normal. what happened?

answer:
there is a background color set to be yellow in the css, check it

how to remove DNN version number on the tab

update DNN site from version 3.1 to 3.3.7, now when i open the site in IE7, the version number is displayed together with the page title on the IE7 tab:

My Site > Home (DNN 3.3.7)

in order to get rid of the stuff in '()', Log in as superuser ("host"), go to host settings in host menu and uncheck "show copyright credits".

Oracle DB 10g EX SQL - case sensitivity

Only the text with quotes is case sensitive.

Oracle DB 10g EX SQL - create table - syntax to add Check

CREATE TABLE student(
student_no NUMBER(3) NOT NULL,
age NUMBER(2) CHECK(age>18),
gender CHAR(1) CHECK(gender='m' or gender='f') NOT NULL
);

Oracle DB 10g EX SQL - query the list of all columns in curent table

SELECT * FROM tab;

MS SQL - query the list of all columns in curent table

select column_name from information_schema.columns where table_name ='authors'

MS SQL - query the list of all tables in curent schema

select * from sysobjects where type = 'U' and uid=user_id('dbo')

Oracle DB 10g EX SQL - query the list of all tables in curent schema

SELECT * FROM tab;