oracleinfonet.blogspot.com
Oracle FaQs: FREQUENTLY ASKED QUESTIONS
http://oracleinfonet.blogspot.com/2008/04/frequently-asked-questions_06.html
Realtime question on oracle,interview question on oracle,sql,plsql,faqs on so on, ,. Enter your search terms. All about Real time requirements in Orale Stay Tune! View my complete profile. Sunday, April 6, 2008. 161) Display employee name and department name for each employee. SQL select empno,dname from emp,dept where emp.deptno=dept.deptno. 162)Display employee number,name and location of the department in which he is working. SQL select empno,ename,loc,dname from emp,dept. SQL select ename from emp.
oracledbs.blogspot.com
ORACLE: ORACLE INTERVIEW QUESTIONS
http://oracledbs.blogspot.com/2008/04/oracle-interview-questions.html
Enter your search terms. Aggregate Functions with Groupby n Having clause. Backup n Recovery Tips. Best way to compare two Databases. Can we Change a Column Name. Change the Port number. Changing Prompt in SQL Plus. Creating Dimensions in 8i. Datafiles Efficiency: More Files vs Increase the Size. Deleting all objects from a tablespace. Deleting duplicate rows in the table. Distinct n order by. Droping Logfile Group Failed. Dynamic Table Names and Moving Table. Error in PL/SQL block of trigger. Tuning a W...