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

×