How to create table emp1 based on emp, except comm column?
Latest Answer: CREATE TABLE emp1 AS (SELECT empno, ename, hiredate, sal ...
How do we view the query used while creating a View table? i.e How to find the dependencies of a view table.
Latest Answer: If you have toad, you can see everything. Just navigate to view throgh schema browser and check under the tabs "view". select your view and check all the properties from it. ...
How to display & in Oracle SQL output
Latest Answer: Use concatenate operator ...SQL> select 'a'||'&'||'b' from dual;'A'---a&b ...
these are the columns in the exam_report tableEXAM_CODE,STUDENT_ID,USER_ID,FIRST_NAME,STUDY_CENTER,COURSE,PAPER,APPEARENCEnow i want to know how many student have passed at the end of the yr for each paper?
How to rename a column in a SQL table?
Latest Answer: we can not change the name of the column in oracle once defined. if the column contains null only datatype,widtth we can changepls recognise this ...
How to lock a particular row of a table using SQL?
Latest Answer: INSERT , UPDATE, DELETE operations implicity lock rows of a table that satisfies the condition.Explicitly you may lock a table using for update of as followsSELECT * FROM EMPWHERE EMPNO = 7369FOR UPDATE OF SAL NOWAITIt will lock single row of emp table ...
How to change rows to columns and columns into rows?
Latest Answer: Use decode function. ...
Display deptno wise first three lowest salaries in ascending order of deptno and desc order of salary
display the 5th lowest sal from emp table using Correlated subquery
Latest Answer: display the 5th lowest sal from emp table using Correlated subquerytable have data:----------------SQL> select last_name,salary from employee order by salary asc;LAST_NAME SALARY---------- ----------Cat ...
How to arrange date in week wise like from Monday to Sunday?
Latest Answer: SELECT TO_CHAR(hiredate,'DAY') FROM emp ORDER BY to_char(hiredate-1,'D'); ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
