What is the difference between in, out, inout parameters. Can we pass value or reference or both to the in out parameter.
Here is the answer in 1 lineIN-- value is used in a program. It cannot be a variable .COuld be literal,expression,value .OUT-- value is returned back from the progr...
hi friends,To make it simple, keep in mind,IN : It is a CONSTANT in the sub-program and u can not modify its value in sub- program. if its value is modified in the s...
SQL queries- say for eg.Two tables - emp and deptemp tables consist of empno, deptno, mgrid, empname, locationdept table consist of deptno, deptname.1. Write a query to select department name for which...
SELECT COUNT(e.ename), d.dname FROM emp e, dept d WHERE d.deptno=e.deptnoGROUP BY d.dname HAVING COUNT(e.ename) > 20It is the same...only diff is...use "dname" in group by clause , not "deptno"Thanks
select e.empno "Subordinate",e.ename "Emp Name",e.mgrID "ManagerID",m.ename "Manager Name",m.empno "Employee Number" from emp e JOIN emp m where (e.mgrid=m.empno);
What is the difference between data conversion and data migration?
Informatics Outsourcing is an Offshore Data Management service company. Data Management Service includes all types of Data Conversion, File Conversion, XML Conversion, HTML Conversion,SGML Conversion,...
Data Migration is a process of moving required (and most often very large) volumes of data from our clients' existing systems to new systems. Existing systems can be anything from custom-built IT infr...
What is PL/SQL tables?Is cursor variable store in PL/SQL table?
DECLARE TYPE EmpCurTyp IS REF CURSOR; // Reference Cursor - weak TYPE NumList IS TABLE OF NUMBER; // Table of Number TYPE NameList IS TABLE OF VA...
Pl/Sql Table is like C Array .
Cursor variable doesn't store with pl/sql Table .
IT is a pointer to cursor & it is not item, It is dynamic.
Is there any chance to remove a column of a table
Sure why not?First of all you need to know and be sure of the table name and column you want to delete. There you are: DELETE FROM [TABLE_NAME]WHERE [ROW_NAME] = ['COLUMN_NAME']; EXA...
first mark the column as unuse then drop the cloumn.
Can a view be updated/inserted/deleted? If yes under what conditions ?
A view can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.
Take an example Table : Employee(id number primary key,name varchar2(20),departmentid number)If created view in such a fashion, it includes all Not Null attribues & it does not contains group by a...
hi friendsAs ur discussions we can perform dml operations on simple view ,But ,we cannot do any dmls on complex views at that time we can use instead of triggers then we can do the dmls on any views.okkkkkkkkkkkkk
How do you approach a problem?
How do you handle workplace problems?
What is the role of a mechanical engineer in the Software Industry?
What do you do when things do not go as planned? Cite an example.
How do you handle pressure and stress?
Tell me about a skill you recently acquired or improved.
How to handle academic gap while applying for a job?
Provide an example of a goal that you successfully attained.
Do you seek advice from others when you have a question?
What are my options when I do not get a job after graduation?
Ask Interview Question?
Have Career Question?
Ask Only Career questions.