Welcome to TechOraFAQ
All about SQL & PL/SQL
Latest from the Blog
Few more questions
Q1. What is sysdate? Is it a pseudo column or system variable or a function?Ans. It is a function. Q2. Which one is faster Delete or Truncate?Ans. Truncate is faster. Q3. Can we use Decode function is PL/SQL without SQL statement?Ans. No. Q4. Can a primary key column have a null value?Ans. No. Q5. Can…
Solution for Test Your Knowledge 2
Test your knowledge by answering following questions. Note: Kindly use the below mentioned tables only from HR Schema. Don’t create your own tables. Sample out will be shown on for 10 records. There are various ways to arrive at solution of the questions listed below. The solutions shared below is just to help you in…
Get new content delivered directly to your inbox.
