FAQ

Oracle SQL and PL/SQL FAQ and their Answers


1.) SQL Statement to get the 2nd highest salaried/paid Employee.
2.) SQL Statement to get the n'th highest salaried/paid Employee.
3.) Check constraints on SYSDATE in Oracle
4.) Restrictions on Check constraints in Oracle
5.) How to print Mathematical table using SQL in oracle.
6.) How to split and print all the characters of a word in rows using SQL in Oracle.
7.) How to print all the dates between two given dates using SQL in Oracle.
8.) How to Extract Merge/Insert of a table.
8.) Split String with some delimiter and return and table type in Oracle.

C Programs and Necessary Details.

1.error: ‘for’ loop initial declarations are only allowed in C99 mode,note: use option -std=c99 or -std=gnu99 to compile your code

2.Calculate the number of days between two dates using C

3.How to find number of days and difference between to dates using C

4.How to implement List Data Structure in C Using Array.

5.How to compile C/C++ program using Digital Mars Compiler (DMC).

6.Armstrong number also called Narcissistic numbers.

add to del.icio.us saved by 0 users