How to convert rows in column using SQL in Oracle; for example sl_no 1 2 3 4 output is 1234; How to convert one column value into rows using SQL for example employee_name Kumar output K u m a r

Megamind

 Profile Answers by Megamind Questions by Megamind

• Apr 14th, 2014

We can do it via pivot keyword..... it will change the row into column.. its simply a pseudo column

Kandavel Durairaj

• Nov 8th, 2013

Using LISTAGG. Read the oracle documentation for more info.

Answer Question  Select Best Answer

Hi, Let us take a scenario such that I issue a delete on table emp and truncate on table emp1 which is exact replica (in terms of both structure and data) of emp table.Now , I issue a commit on both sessions. If I do a select * from emp and select * from emp1 now, which one should execute faster and why?

sumanamara2016

 Profile Answers by sumanamara2016 Questions by sumanamara2016

• Mar 18th, 2016

TRUNCATE TRUNCATE does not return number of deleted rows. TRUNCATE TABLE always locks the table and page but not each row. DELETE When we have to use DELETE Command then the data deleted can be ...

Mohammad Mansoor

• Feb 24th, 2016

Truncate and Drop commands Rollback is not possible for Table, whereas Delete Command we rollback the Data

Answer Question  Select Best Answer

How can I select column values from a table without knowing the column name ?Suppose , select employee_id from employees , now I don't know the column name and I want to select the column.Please let me know the answer

suganthi

• Jul 3rd, 2015

How to display data from table values without using select command?

kranthiswaroop

 Profile Answers by kranthiswaroop Questions by kranthiswaroop

• May 6th, 2014

Hi Sanjoy, Its a simple logic that, one should have complete idea about the Table , Table fields and data types used.. before applying any DML DCL DDL Commands, a programmer shoud know this. A progra...

Answer Question  Select Best Answer