Can we insert in sql function?
How do you drop a trigger?
Which operator is used in query for pattern matching?
SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;
There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?
What problem one might face while writing log information to a data-base table in pl/sql?
Can a foreign key be a duplicate?
How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id
How do you declare a user-defined exception?
Can you create a table with Primary Key not as the clustered index.
what is the different between unique+not null & primary key,
How will you delete a particular row from a Table?
How can i insert data inro a table with 3 columns using FORALL?