Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Blog Directory  >  Arts & Entertainment Blogs  >  oracle sql tutorials,oracle 10g tutorial arts-and-entertainment Blog  > 

2011-10-18 19:08
SEQUENCESYou create a sequence to generate a unique numbers.Create sequencesYou can create a sequence by using CREATE SEQUENCE statementFor exampleCreate sequence for the EMPNO column of the… Read More
2011-10-17 15:55
To complete your DML statements you need to control in it by1-      CMMIT: make all pending changes in a transaction permanent.2-      ROLLB… Read More
2011-10-16 13:02
Manipulating Data Language (DML)Before execute DML statements, you must have INSERT,UPDATE, and DELETE privilege. INSERT EXAMPLES1-   INSERT INTO NEWEMP(EMPNO,ENAME,DEPT… Read More
2011-10-14 15:46
Before create a tables please follow the below rules not for table only but for all database objects.1-     All names begin with letters and contain no more than 30 chara… Read More
2011-10-13 18:28
Oracle uses constraints to prevent invalid data entry into a table.You can add and remove constraint after creating a table.Constraints ensure that data in a table adhere to the recognized b… Read More
2011-10-12 18:11
Common Database structure1- Table: Common structure in database is a table .table consist of columns and rows in which data is stored .the intersection of a column and  a row is ca… Read More
2011-10-03 19:44
DATE FUNCTION IN SQL1- MONTHS_BETWEEN Function : finds the number of months between two datesFor example  assume that you want find number of months between an employee hire date And sy… Read More
2011-10-03 19:31
By using arithmetic operators you can perform calculations on dates.For exampleSELECT EMPNO,ENAME,SAL,HIREDATE,HIREDATE+100 “NEW DATE”FROM EMP; EMPNO ENAME   … Read More
2011-10-03 19:27
Is a date function returns the current date The default format is DD-MON-YYIf you want to select current date Type Select sysdate From dual;SYSDATE---------03-OCT-11… Read More
2011-10-02 19:34
Case conversion function used to display character values in a different case,without changing the case of the data in the tableTypes of case conversion function 1-  UPPER: that di… Read More

Share the post

oracle sql tutorials,oracle 10g tutorial


Subscribe to Oracle Sql Tutorials,oracle 10g Tutorial

Get updates delivered right to your inbox!

Thank you for your subscription