Question is been asked in the interview., I have table Department with details likeDeptId Dname Dlocation10 Finance Del20 Sales Mum30 Marketing BloreThe output should be in this format 10 20 30 Finance Sales Marketing Del Mum BloreThe query I need in SQL not using any transformation.Can anyone help me out in this ?
Explain the internal process and steps how SQL statement is executed in Database ?
Latest Answer: In Order to execute any SQL statement first we need to start an oracle instance. for that we need to connect to any tool(SQL* Plus) and that will start a user process. This user Process will contact the server on which oracle is installed and stats system ...
Latest Answer: The column numbers are used so that you can do the order by without keying in all the column names in the order by clause. For eg.select empno, ename from emp order by empno; -- qry 1could be replaced byselect empno, ename from emp order ...
We have two type of constraints - Table Level and Column Level. Which is better and why..?
Latest Answer: >>We have two type of constraints - Table Level and Column Level. Which is better and why..? Performance wise there will not be any difference between table level and column level constraints. Generally we use table level constraint to define composit ...
Can you use a reference cursor as an input parameter in a procedure with out declaring it explicitly?
Latest Answer: A table is said to be redundant (that is data is repeated) if it is in a denormalized format. For ex, we have a table, which displays item, item no, item cost etc. which is denormalized. To avoid redundancy, we normalize it and add some more fields like ...
Latest Answer: Centralize dbms is who share the dabtbase thoroug network at clients machines which is centrized at one location(pc)distribuited dbms which is client sites systems. ...
Latest Answer: The hierarchy of SQL is: Parse à Execute à Bind à Fetch ...
Latest Answer: This means that the employee does not have any manager.Select e.empno,e.ename From emp e,emp m where m.empno(+)=e.mgrid;orSelect e.empno,e.ename From emp e left outer join on emp m where m.empno=e.mgrid; ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
