SQL_PLSQL_TUTORIAL

Sunday, February 7, 2016

Installation of Oracle 11g and 12c

*Kindly see the You Tube video to get installed the database.

at February 07, 2016

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Post a Comment

Older Post Home

Subscribe to: Post Comments (Atom)

Installation of Oracle 11g and 12c *Kindly see the You Tube video to get installed the database.

Oracle - What is Pseudocolumns.

A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you cannot i...
Cursor, ref cursor and SYS_Ref cursor.

CREATE OR REPLACE PROCEDURE get_emp_rs (p_deptno IN emp.DEPARTMENT_ID%TYPE, p_recordset OUT SYS_REFCURSOR) AS BEGIN OPEN p_records...
Find the Number in var char column .

Find the Number in var char column . select * from (select * from table@pwrdev where rtrim(column, '0123456789') is null); select...

Search This Blog

Home

About Me

SACHIN SINGH

View my complete profile

Report Abuse

Blog Archive

▼ 2016 (4)
- ▼ February (4)

► 2015 (6)
- ► August (4)
- ► July (2)

► 2014 (1)
- ► May (1)

Simple theme. Theme images by mammamaart. Powered by Blogger.