Home » SQL & PL/SQL » SQL & PL/SQL » How to use REF OF.. (Windows, toad)
icon5.gif  How to use REF OF.. [message #378894] Fri, 02 January 2009 05:39 Go to next message
Messages: 1
Registered: January 2009
Junior Member
i have the following table structure to create, 'm attaching the query file i have written,

TABLE Name: oo_emp_Table_refcol

Name Null Type

ID number(7)
last_name varchar2(25)
first_name varchar2(25) user_id varchar2(Cool
start_date date
manager_id number(7)
title varchar2(25)
dept_id ref of dept_type -- making problem
salary number(11,2)
commission_pct number(4,2)

i'm attching the details in an sql file, please feel free to ask for ny details, i want to get this resolved.. draining my energy for the last 3 dys behind this..

[Mod-Edit: Frank removed (unused) poll]

[Updated on: Fri, 02 January 2009 07:46] by Moderator

Report message to a moderator

Re: How to use REF OF.. [message #378898 is a reply to message #378894] Fri, 02 January 2009 06:01 Go to previous message
Michel Cadot
Messages: 65088
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Post a Test case: create table and insert statements along with the result you want with these data.

Use SQL*Plus and copy and paste what you already tried.

Previous Topic: How to get the value
Next Topic: updating the table and putting the salary in desc order
Goto Forum:

Current Time: Wed Jul 26 10:06:44 CDT 2017

Total time taken to generate the page: 0.15622 seconds