Sql questions and answer with solution

commonly asked question in sql with solution for p... good questions of sql with solutions questions on natural,inner & outer joins in sql wi... BE MASTER IN SQL IN THREE HOUR DATA DEFINATION LANGUAGE IN SQL NAMING CONVENTIONS IN SQL CONSTRAINTS IN SQL DATA TYPES IN SQL DEFINING A CONSTRAINT IN SQL FOREIGN KEY CONSTARINT IN SQL NOT NULL CONSTRAINT IN SQL UNIQUE KEY Constraint IN SQL CHECK CONSTRAINT IN SQL DEFAULT VALUE IN SQL CREATING AN ORACLE TABLE DISPLAYING TABLE INFORMATION IN SQL ALTERING AN EXISTING TABLE IN SQL Adding a New Column to an Existing Table IN SQL Dropping a Column (Oracle 8i Onward) Dropping a Table IN SQL RENAMING A TABLE IN SQL TRUNCATING TABLES IN SQL SPOOLING IN SQL EXAMPLES OF SQL CODES BUILT-IN FUNCTIONS IN SQL CHARACTER FUNCTION IN SQL NUMBER FUNCTIONS IN SQL DATE FUNCTION IN SQL OTHER FUNCTIONS IN SQL CONVERSION FUNCTIONS IN SQL ADDING A NEW ROW TO A TABLE IN SQL SUBSTITUTION VARIABLES IN SQL CUSTOMIZED PROMPT IN SQL DELETING EXISTING ROWS IN SQL DROPING A CONSTRAINT IN SQL DISABLING/ENABLING CONSTRAINTS IN SQL Column Alias IN SQL Concatenation IN SQL RETRIEVING DATA FROM A TABLE IN SQL ARITHMETIC OPERATIONS IN SQL RESTRICTING DATA WITH A WHERE CLAUSE IN SQL