Apache Derby – Alter Table Statement The ALTER TABLE statement, allows you to alter an existing table. Using this you can do the following − Add a column, add a constraint Drop a column, drop a constraint Change the row level locking of a table Let us assume we have created a table named Employees […]
Category Archives: apache Derby
Apache Derby – Having Clause The HAVING Clause enables you to specify conditions that filter which group results appear in the results. The WHERE clause places conditions on the selected columns, whereas the HAVING clause places conditions on groups created by the GROUP BY clause. Syntax Following is the syntax of the HAVING clause − […]
Apache Derby – Procedures This chapter teaches you how to create and drop procedures in Derby. Creating a procedure You can create a procedure using the CREATE PROCEDURE statement. Syntax Following is the syntax of the CREATE PROCEDURE statement. CREATE PROCEDURE procedure_name (parameter_type parameter_name1, parameter_type parameter_name2 . . . .) parameter_style; Example Suppose, we have […]