-
-
-
How to drop a column level constraint?
I cant drop the whole column because that is interlinked with my process? I have declared not null on a column, I have to change it
-
How to find the Foreign keys of all child tables when pass the Parent Table name.
I developed like below.Any experts query ....please send.selecttable_name,constraint_namefrom user_cons_columns where column_name=(select a.COLUMN_NAME from user_cons_columns a,user_constraints bwhere a.TABLE_NAME=b.TABLE_NAME and b.constraint_type in ('P')and a.TABLE_NAME='DEPT')and constraint_name like '%FK%'
-
-
-
-
In which format data will be stored in Database(Oracle) ?
find it imm...
-
-
-
What are the commands that come in the category of DML in SQL?
DML refers to Data Manipulation Statements. That is used for accessing and modifying values or data present in the database. The commands that come in the category of DML in SQL INSERT SELECT DELETE UPDATE INSERT: This command is used to insert rows into the table. SYNTAX: INSERT INTO tablename VALUES (value,value,….); SELECT: This is used to select...