 Related Questions Dear Sir,My question is thatI want to add two columns i.e one from first group and another from seconf group. for ex f15 from g_cost_code f17 from g_area_code I think I have to make a placeholder column and add it to g_area_code group but I am not sure please help.Regards,Ashutosh Trivedi Read Answers (1) | Asked by : Ashutosh Trivedi How to make migrate the database from Oracle 9i to Oracle 10g ? please list out all possible differences between these two versions. Read Answers (1) | Asked by : Ishwar B G Rownum is used to get tha top-N values. What if I want to know the value at specific position?EX: A table emp has two columns e_name and e_salary. How can I list the e_name of the employee who is getting the third highest salary? I want to use a column as blob datatype incase of long raw datatype.what is the process of data insert into and retrive from this table . View Question | Asked by : jagannath kar Table contain 2 columns like name and genderfor that i need output like this..countof female countofmale totalcountforeg 5 3 8 Read Answers (3) | Asked by : viswam Dear 1 simple qustion is how i can get out put likescott's sal is 2000becoz ' is special char i can not pipe it with enameasename||'scan we use escape sequence but i know that escape seq is only 4 % and _ plz tell me anybody Read Answers (2) | Asked by : tariq Why is that when I retrieve a date column with time format ('dd-mon-yyyy hh:mi:ss), I get the time for all the records as 12:00:00 ? How can is see the actual time in the date column? (i)a table is classfied as a parent table and you want to drop and recreat it .how would you do this (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" Read Answers (3) | Asked by : umarajeswari 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 ... Read Answers (1) | Asked by : srikanth How to write RESERVE WORD as table column?For example if you want to write Number as table column name How do you write? Read Answers (4) | Asked by : manisha
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
