Latest Answer: What I understood from your question is that you want to comma seperate the values of a particular column for its different rows. If this the question then query will beDECLARE @SQL AS VARCHAR(500)SELECT @SQL = ISNULL(@SQL,' ')+',' ...
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: Constrains are the key word along with create table command. Different type of table constraints are primary key not null unique etc. ...
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: A centralized database has all its data at one place so there may occur problems of data avalability, and a system crash may lead to whole dataloss. In a distributed database, database is stored on several computers and they communicates using networks. ...
Latest Answer: The hierarchy of SQL is: Parse à Execute à Bind à Fetch ...
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
