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...
1544Hi 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...
1587Post New IBM Oracle Errors Interview Questions
can you provide me full detail about instrumentation in ONGC??
What is the use of systime function?
What is Make to Order, and what is the difference between Make to order and Make to Cash
what is the limit of total coli forms for cuttle fish?
i had aplied Hindustan Petroleum corporation limited for the post of maintenance technician -Electrical,i want model questions,if anybody have please send it or please advice?
how can you convince me that you can do a sales job even though you don't have any sales experience.
Kindly post me previous year interview questions with answer for post of Manager (civil engg.) for NTPC, IOC , GAIL etc. I have interview on july 2013.I will be very grateful to you. Please guide me.
Somebody can explain me about >Critical Loops, calibrations, ESD critical Loop checks, Logic Diagram / Cause & Effect checks for ESD loops,
How Can I calculate for the photometrics requirements for a street lighting? Data given are: 45 units of 6 meter light pole with 150 watts metal halide lamp, 220 volts and installed in a promenade area.
How the memory management in vectors are being done. What happens when the heap memory is full, and how do you handle it ?
Who is an ideal team worker according to you?
aap ias ban ke kya kar rhe hai
What is included on the People Tools CD-ROMS?
Can any one please help in knowing the end to end Payroll process in SAP . Starting from uploading the data of a newly hired employee ,Attandace uploading to, Generating PF,ESI challana ( including the T code, )
please suggest some good universities with low cost iam in totally full confusion so please help me my profile gre 283 and ielts 5.5
- 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 (139)
- 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 (42)
- 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)
