Share this
HR SCHEMA
Learn Oracle
Wednesday, 11 March 2015
Subscribe to:
Post Comments (Atom)
Recent
Weekly
-
1. Get the last day of the month. sql> SELECT TRUNC (LAST_DAY (SYSDATE)) "Last day of current month" FROM DUAL; ...
-
SQL RENAME Command The SQL RENAME command is used to change the name of the table or a database object. If you change the object's ...
-
Add a Comments on a Table in Oracle Use the comment statement to add to te data dictinary a comment about a table or table column,vie...
-
An In_condition is a membership condition. it tests a value for membership in a list of values or subquery. The Condition defined using ...
-
Spool Of/On Sends standard output, informational messages, error messages, and/or warning messages generated by the execution to the...
-
1. How to find third highest or second maximum salary of an Employee Rownum is defined for ORACLE, while Top is defined for MS SQL Both ...
-
The USING clause specifies which columns to test for equality when two tables are joined. it can be used insted of an ON clause in the Joi...
-
How to Create SQL View Introduce to SQL View SQL View is a virtual table which is used to encapsulate a complex queries. After creat...
-
#include<stdio.h> #include<conio.h> int sqrt(int num); int cuberoot(int num); void main() { clrscr(); int num ,s,c; printf(...
0 Comment to "HR SCHEMA"
Post a Comment