How to insert more then one record from one table to another table in oracle,in some specific colums
hii i have a emp table .empno stores all the numeric valuesand accidentally i have added some values with combination of alphabets and special charactersnow i need a query which will return all the records
Latest Answer: Hello ,First of all if you can tell me what version you are using that will be great Cause Oracle10 has reqular expresion property.Mean while i would sugest to write a page where you can get all the Emplids,Iterate them and check if they are ...
i want to create a database containing info about the student, i,e their resume with photo, how can i store these details directly to oracle database?
Latest Answer: use LOB data types ...
Latest Answer: delete from empwhere empno in ( select empno from emp where rownum
Latest Answer: alter session set nls_date_format ='new_date_ format';or use to_date functions ...
What are list of components for a DML trigger that directly or indirectly depends on the database objects(5)
Can any one tell me how to configure orcale(8i or 9i) database to work with jdbc means after installing the oracle 8i/9i software i am unable to connect database using jdbc program
(i)a table is classfied as a parent table and you want to drop and recreat it .how would you do this without affecting the children tables?(II)you want to group the following set of selected returns ,what can you grioup on?max(sum_of_cost),min(sum_of_cost),count(item_no),item_no(iii)"to delete duplicate records from table leaving on set of records"
View page << Previous 9 10 11 12 [13] 14 15 16 17 18 Next >>
Go Top
