Go4Oracle

1. Handy PHP
(Joomla! & PHP Resources)

Handy PHP offers scripts, discussions, tutorials, answers, and other resources for PHP. This includes a growing number of resources for the Joomla! - Content Management System. Your ideas and question

2. prcedure and function
(Forum/Forms)

1)Function returns only one value whereas procedure can return 0, 1 or more values. 2) DDL statement can be executed using execute immediate in procedure whereas it cannot be used in functions. 3) F

3. rownum are very usefula feature
(Comments)

...tion too_many_rows. Eg. Select col into variable from tablename where colname = 'Some Values' this can return multiple records and we can come across exception too_many_rows.... If we modify the ...

4. SQL-ST-01
(Workshop/SQL)

...racter Function Character Functions are studies if two different categories (a) Character function which returns character value to be covered practically with examples Chr, Concat, Initcap, Lower, L...

5. My Training on oracle
(MyBlog/MyBlog)

...e from emp_mast, dept_mast; Outer join -: An outer join is similar to the equi join, but Oracle will also return non matched rows from the table with the outer join operator (+). Missing values are fi...

6. rownum a pseudocolumn
(Articles/Oracle)

...y stored in the table. You cannot insert or delete values of the pseudocolumns.    For each row returned by a query, the ROWNUM pseudocolumn returns a number indicating the order in which Or...

7. ROWID OF A RECORD (PSUEDO COLUMN)
(Articles/Oracle)

Rowid Is a Psuedo Column in oracle tables : For each row in the database the row id psuedocolomn returns a row address .oracle 8 rowid value contain information nessasary to locate a row. 1. which

8. IN AND OUT PARAMETER IN PLSQL PROGRAMMING
(Articles/PL/SQL)

...d when the procedure terminates. INOUT, for example, means that the parameter will receive a value and return another INOUT Mode A variable passed in INOUT mode has characteristics of both t...

9. SQL-ST-01
(Workshop/SQL)

...racter Function Character Functions are studies if two different categories (a) Character function which returns character value to be covered practically with examples Chr, Concat, Initcap, Lower, L...

10. My Training on oracle
(MyBlog/MyBlog)

...e from emp_mast, dept_mast; Outer join -: An outer join is similar to the equi join, but Oracle will also return non matched rows from the table with the outer join operator (+). Missing values are fi...

11. rownum a pseudocolumn
(Articles/Oracle)

...y stored in the table. You cannot insert or delete values of the pseudocolumns.    For each row returned by a query, the ROWNUM pseudocolumn returns a number indicating the order in which Or...

12. ROWID OF A RECORD (PSUEDO COLUMN)
(Articles/Oracle)

Rowid Is a Psuedo Column in oracle tables : For each row in the database the row id psuedocolomn returns a row address .oracle 8 rowid value contain information nessasary to locate a row. 1. which

13. IN AND OUT PARAMETER IN PLSQL PROGRAMMING
(Articles/PL/SQL)

...d when the procedure terminates. INOUT, for example, means that the parameter will receive a value and return another INOUT Mode A variable passed in INOUT mode has characteristics of both t...