Database Errors Interview Questions
Questions Answers Views Company eMail

How to view the error log for any specific instance?

1959

When do you get "getwmicomexception"?

2277

Why we can't perform DML operations on Materialized views???

CGI,

1 8356

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1245

I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1097

I want query to find the students name who have second highest marks in a table

1 753


Un-Answered Questions { Database Errors }

ORA-26094: stream format error: input column overflow

2266


I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.

1097


ORA-16627: No standby databases support the overall protection mode.

3570


Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2149


IMP-00064: Definition of LOB was truncated by export

5904






how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

1877


RMAN-05017: no copy of datafile number found to recover

1906


What is live lock, deadlock and what is Lock escalation?

1966


write a database figure to implement the master detained relationship.

2452


what is the instrument that used in Mechanical Energy??

2274


NZE-28890: Entrust Login Failed

1418


what is new g/l functionality

2224


What severity level errors are managed in TRY-CATCH block?

1804


What is the use of NOLOCK locking hint?

1383


NZE-28868: Peer certificate chain check failed.

2280