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...
1526Hi 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...
1557Post New IBM Oracle Errors Interview Questions
What is the difference between Keyword Driven test and Data Driven test?
i want last 5 yrs Q papers of rrb(any) send me at puneetchauhan_8782@yahoo.co.in
What is the feature’s in Group Policy? What is DNS? what is the use of DNS?
how can you size an automatic voltage regulator?
at what rate the micro controller increment its timer....is it 1micro seconds or 1/(12*10^6) seconds
What is TDS entry for a Firm? as previous years TDS is shown as opening balance in the books of the firm in current year and i don,t want in C.Y as its claimed in the Computation of Previous Years???? So what is the A/C ing entry
Can any one explain the basic things about RLU and Printer Files and their Definitions for both and why are they used,i'm a newbee so please help me out
What are the steps to write p-to-p model application?
Is this job good for future? can do this job post grduate student?
which is the most advanced form of SF6 BREAKER?Can we use other gases to quench the arc?
Hai,i had completed my M.pharmacy.i want the coaching centres for drug inspector exam at hyderabad,pls help me nd wen wil b the DI exam conducted in 2012 mostly,pls also forward the model papers.. pls reply me at vislawath.jyothi@gmail.com
How many cylonders are there in 2stroke diesel engine?
what is Resolution?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
what is the command to copy windows files (i386) without formatting OS?
- Software (1)
- C (84)
- OOPS (37)
- C++ General (9)
- MFC (2)
- COM DCOM (1)
- VC++ AllOther (1)
- Delphi (11)
- PHP (16)
- Programming Languages AllOther (31)
- ASP (5)
- CGI Perl (7)
- JavaScript (6)
- VB Script (15)
- JSP (6)
- Shell Script (6)
- AJAX (1)
- Ruby on Rails (1)
- Scripts AllOther (2)
- SNMP (1)
- TCP IP (10)
- UDP (1)
- Protocols AllOther (3)
- Networking Administration (28)
- Networking Security (3)
- Networking AllOther (9)
- Visual Basic (5)
- C Sharp (35)
- ASP.NET (37)
- VB.NET (3)
- ADO.NET (11)
- IIS (9)
- Crystal Reports (3)
- BizTalk (3)
- Dot Net Framework (14)
- Dot Net WindowsForms (2)
- Dot Net General (3)
- Dot Net AllOther (4)
- Exchange Server (12)
- Microsoft Related AllOther (2)
- Oracle General (39)
- Architecture (1)
- Database Management (11)
- Forms Reports (7)
- Oracle AllOther (9)
- SQL Server (61)
- MySQL (3)
- DB Architecture (1)
- DB Administration (11)
- DB Development (9)
- SQL PLSQL (41)
- Databases AllOther (7)
- Windows Threads (2)
- Windows General (6)
- Windows AllOther (26)
- Linux Commands (18)
- Linux Threads (2)
- Linux IPC (2)
- Linux Socket Programming (1)
- Linux System Calls (5)
- Linux General (3)
- Linux AllOther (20)
- Unix Commands (33)
- Unix IPC (2)
- Unix Socket Programming (1)
- Unix General (5)
- Unix AllOther (11)
- Solaris Commands (30)
- Solaris Threads (3)
- Solaris System Calls (2)
- Solaris General (10)
- Solaris AllOther (82)
- Operating Systems General Concepts (17)
- Data Structures (1)
- Operating Systems AllOther (2)
- WinRunner (10)
- Load Runner (28)
- QTP (176)
- Test Director (3)
- Rational TestSuite (4)
- Silk Test (9)
- Selenium (1)
- Automation Testing AllOther (10)
- Manual Testing (277)
- QA Concepts (23)
- Mobile Testing (3)
- Test Cases (21)
- Test Documents Reporting (2)
- Testing AllOther (12)
- Apache (1)
- Servers AllOther (6)
- COBOL (138)
- JCL (132)
- CICS (31)
- DB2 (78)
- IMS (11)
- IDMS (1)
- Natural (6)
- Assembler (1)
- QMF (2)
- MVS (2)
- OS390 (2)
- VSAM (11)
- Sysplex (1)
- IBM MainFrame AllOther (39)
- RPG400 (59)
- DB400 (3)
- COOLPLEX (1)
- IBM AS400 AllOther (31)
- IBM PL/1 (1)
- Core Java (77)
- Advanced Java (7)
- Swing (2)
- EJB (4)
- Servlets (17)
- Struts (16)
- JDBC (11)
- JMS (2)
- SunOne (1)
- J2EE (3)
- Weblogic (30)
- Websphere (7)
- Java J2EE AllOther (6)
- J2ME (1)
- Java Related AllOther (4)
- MQSeries (16)
- Middleware AllOther (10)
- HTML DHTML (3)
- XML XSLT RSS (6)
- Flash Action Scripting (1)
- SOAP (1)
- Web Related AllOther (2)
- Teradata (41)
- Business Objects (66)
- Cognos (171)
- Informatica (179)
- Actuate (3)
- Ab Initio (56)
- Data Stage (147)
- SAS (5)
- Micro Strategy (3)
- ETL (12)
- Data Warehouse General (25)
- HR Questions (24)
- Design Patterns (6)
- Requirements Management (1)
- Project Planning (2)
- Project Management (2)
- Software Design AllOther (2)
- CTC (1)
- Debugging AllOther (3)
- Clear Case (10)
- Version Control AllOther (1)
- Vi Editor (1)
- Telecom Protocols (1)
- ISDN (2)
- Telecom General (2)
- SAP Basis (145)
- SAP ABAP (300)
- SAPScript (13)
- SAP SD (310)
- SAP MM (56)
- SAP QM (4)
- SAP PP (34)
- SAP PM (6)
- SAP PS (1)
- SAP FI CO (262)
- SAP HR (32)
- SAP CRM (37)
- SAP SRM (2)
- SAP APO (2)
- SAP Business Warehouse (29)
- SAP Security (159)
- SAP Interfaces (2)
- SAP Netweaver (22)
- SAP ALE IDocs (8)
- SAP B1 (16)
- SAP GTS (1)
- SAP AllOther (11)
- CRM General (7)
- Siebel (55)
- ERP General (3)
- Oracle Apps Technical (53)
- Oracle Apps Financial (74)
- Oracle Apps HRMS (6)
- Oracle Apps CRM (1)
- Oracle Apps SCM (10)
- Oracle Apps AllOther (1)
- ERP CRM AllOther (1)
- VLSI (4)
- Client Server General (4)
- AI Algorithms (1)
- AI AllOther (1)
- Cryptography Algorithms (1)
- WebMethods (16)
- TIBCO (18)
- BPM (1)
- EAI AllOther (1)
- Visual Effects (1)
- Requirement Management (5)
- Risk Analysis (6)
- Estimation Analysis (4)
- Planning & Integration (4)
- Software Quality Analysis (3)
- Software Integration & Release (1)
- Program Management (4)
- Apache Hadoop (1)
- Micro Biology (1)
- Bio Informatics (1)
- Nuclear Physics (1)
- Organic Chemistry (1)
- Health Pharma AllOther (1)
- Civil Engineering (3)
- Mechanical Engineering (8)
- Electrical Engineering (40)
- Electronics Communications (26)
- Chemical Engineering (2)
- Instrumentation (4)
- Engineering AllOther (17)
- Business Administration (11)
- Marketing Sales (14)
- Banking Finance (16)
- Human Resources (17)
- Personnel Management (1)
- IT Management (5)
- Non Technical (3)
- Business Management AllOther (12)
- Audit (5)
- CompanyAffairs CS (3)
- Taxation (21)
- Accounting General (58)
- Accounting AllOther (93)
- Call Centre AllOther (289)
- Government (1)
- UPSC General Studies (3)
- UPSC AllOther (3)
- SSC General Science (1)
- SSC General Studies (6)
- RRB (4)
- POs (2)
- BSRB Clerical (2)
- Group I (4)
- Group II History (3)
- Group II AllOther (2)
- Group II Political Science (1)
- General Studies (2)
- APPSC AllOther (10)
- General Knowledge_Current Affairs (19)
- Government AllOther (2)
- Teaching (1)
- Funny Interview Questions (5)
- Everything Else AllOther (13)
- English (12)
- General Aptitude (67)
- Puzzles (6)
- Placement Papers (22)
- CCNA (42)
- CCDA (1)
- Microsoft Certifications (6)
- Sun Certifications (6)
- CISA Certification (2)
- Oracle Certifications (5)
- ISTQB Certification (5)
- Certifications AllOther (6)
- H1B Visa (3)
- USA Student Visa F1 Visa (5)
- L1 Visa (4)
- USA Immigration Visa (1)
- USA Business Visa B1 Visa (2)
- USA Dependent Visa H4 Visa (2)
- USA AllOther Visa (2)
- UK Visa (1)
- Australia Visa (1)
- Canada Visa (3)
- C Code (8)
- C++ Code (7)
- J2SE Code (2)
- J2EE Code (2)
- C Sharp Code (1)
- ADO.NET Code (1)
- JSP Code (1)
- GATE (3)
- IIT JEE (1)
- CAT (1)
- OPENMAT (1)
- ICET (2) Oracle Errors (14)
- SQLServer Errors (1)
- Scripts Errors (2)
