In one table there is 10 records without id num,without primary key and it is not sorted then how to extract last 6 record from table?
4 7422Trying to transfer data from Prod region to Test region.So,exporting data from Prod table(e.g xyz in prod) into a temporary table(e.g abc) and then inserting into Test table(e.g xyz in prod),but not able to insert data from one db2 table to another,the error coming out is 'foreign key vaue is not valid'
1 3975I've got a database (Oracle Database 10g Enterprise Edition Release 10.2.0.2.0) installed on a server. Via the network I try to connect to the database via a frontend DEVELOPER 2000 R 2.1 (SQL*Plus: Release 3.3.4.0.0 ) while connecting to database I've got the following error- message: ORA-12637: Packet receive failed
2 4931i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.
2367java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page
HCL,
6239imp-00038: could not convert to environment character set's handle error occurs while importing oracle 10g data into oracle 9i database.
1 19159I am experiencing an error failed to retrieve data from data base. it is an oracle table. Is there a limit on the number of fields that can be a report. My table has 321 fields and I do not have all of them in the report yet.
1 4472
When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............
ORA-16516: The current state is invalid for the attempted operation.
IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created
When do you get "getwmicomexception"?
ORA-26032: index string.string loading aborted after string keys
NZE-28868: Peer certificate chain check failed.
In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.
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...
How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table
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.
What severity level errors are managed in TRY-CATCH block?
how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board
ORA-26095: unprocessed stream data exists
ORA-26094: stream format error: input column overflow
ORA-16627: No standby databases support the overall protection mode.