how to get a particular column alone in select statement?

[Vinarashi]

Hi,

I have given a "select *" statement for a view. It gives all the values for the "where" condition mentioned. But when I give "select column_name " for the same "where" condition, I am getting an error.
e.g.
if I give "select * from SERVC_MGR_REPT_V_CELL where EMPLOYEES_NAME='Ma, Stephen';", I am getting all the values.

But if I give "select MANAGERS_NAME from SERVC_MGR_REPT_V_CELL where EMPLOYEES_NAME='Ma, Stephen';", it gives an error. The error message is "ORA-00600: internal error code, arguments: []......"

Just for information "SERVC_MGR_REPT_V_CELL" is a view.

can anyone please help me out in this issue?

Thanks,
Flora

[rski]

Can you show a view definition and column types wich are in that view.

[Vinarashi]

Hi,

Thanks for your reply..

This is the view definition.

CREATE OR REPLACE FORCE VIEW "LOS_AT"."SERVC_MGR_REPT_V_CELL" ("MANAGERS_CID", "MANAGERS_NAME", "SERVICE", "EMPLOYEES_CID", "EMPLOYEES_NAME", "EMPLOYEES_HR_STATUS", "EMP_LOCATION", "COUNTRY", "DEPT", "CHARGED_ITEM", "YTD", "AVG", "CURR_MNTH", "DELTA2MONTHLY_AVG") AS
select level_1, mgr_name, 'Cellphone Charges', up0_cid, up0_name, up0_hr_stat,
up0_location, up0_country, cel_emp_dept, cel_phone_number,sum_ytd,
avrg, curr_mnth,
NULLIF ((NVL (curr_mnth, 0) - NVL (avrg, 0)), 0) delta2monthly_avg
from (SELECT level_1, mgr_name, 'Cellphone Charges', up0_cid, up0_name,
up0_hr_stat, up0_location, up0_country, cel_emp_dept,
cel_phone_number,
get_sum_ytd_charges (up0_cid,
cel_phone_number,
cel_emp_dept,
'los_cellphone_charges'
) sum_ytd,
round(sum(cel_ebi_amount_in_dollars)/(max(REPLACE(CEL_BILLING_MONTH_YR,'/') )-min(REPLACE(CEL_BILLING_MONTH_YR,'/') )+1),2) avrg,
get_sm_month_charges
(up0_cid,
1,
cel_phone_number,
cel_emp_dept,
'los_cellphone_charges'
) curr_mnth


from los_cellphone_charges chrg,los_coredir_expld_v emp
WHERE chrg.cel_commerceid = emp.up0_cid
GROUP BY level_1,
mgr_name,
up0_cid,
up0_name,
up0_hr_stat,
up0_location,
up0_country,
cel_emp_dept,
cel_phone_number) ;

Thanks,
Flora

[amitpatel66]

Try this:

select "MANAGERS_NAME" from SERVC_MGR_REPT_V_CELL where EMPLOYEES_NAME='Ma Stephen';
 
 

[Vinarashi]

Hi Amit,

Thanks for you reply..
I have tried the above statement. If i give the value of EMPLOYEES_NAME as something which is not available in the table, it gives 0 rows.

Whereas if I give the value of EMPLOYEES_NAME as any of the data which is available in the table under EMPLOYEES_NAME column, its gives an error. The error message is "ORA-00600: internal error code, arguments: []......"

Dont know where the actual mistake in the view.

can you please guide me??

Thanks,
Flora

[amitpatel66]

Can you Drop and recreate a view and also if possible dont give double quotes to the column names while creating a view.

And remove the FORCE option from the CREATE VIEW statement and then create a view.

[Vinarashi]

Hi Amit,

I have tried in that way also. Still its not working.
For "select * ", I am getting all the values. But "select <column_name> " getting error as ORA-0600 - Internal error code.

Thanks a ton Amit.

Regards,
Flora

[amitpatel66]

I think you will need to raise an SR with oracle support on this error ORA - 00600.

[Sandeep M]

Its an internal error happened in ORACLE. we cudnt do nothing in this regard.

anyway we cud bypass this by tricks :).

select MANAGERS_NAME FORM (select * from SERVC_MGR_REPT_V_CELL where EMPLOYEES_NAME='Ma, Stephen')

will it solve?