In this post, we will learn how to modify the size of an column in an Oracle table. It’s easy to alter the column size using the ALTER TABLE MODIFY statement. Sometimes the column value will exceed from which we defined while creating the table. So in that case we need to update the size of the … Read more
In this quick tutorial we will see how to get the primary key column in the table. Here we can use the below table to list the columns Syntax The constraint type ‘P’ refer for primary key, as like this the oracle has the key for every constraint type some are belows, Type Definition C … Read more
In this post, we will see how to insert a data into a table with the result of select statement. Sometimes we want to move the data from one table to another, in that case we use insert into select statement. Syntax Let’s use the below STUDENT_MARKS table to understand the topic. Example 1 The above query will insert all the records from … Read more