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...
1567Hi 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...
1612Post New IBM Oracle Errors Interview Questions
manhole chamber having height of 2300 mm and thickness of brickwork is 230 mm and dia of opening covering is 560 mm and bottom length vertical is 1500 mm (1:4) brick masonry and plaster 12 mm on both sides..how to estimate the no bricks used with mortar cement bags and sand for total chamber including plaster.
What should be the voltage between Neutral and Ground in secondary side of the step down transformer (230 V to 110 V) with no load condition?
Where can i get IFAM Banglore details, i came to know that there they are giving Accounts & Taxation Training on Real Projects, and they are providing Job after training. I got one number that is not reachable i.e 9591777526. Please give me if any one knows this Institute details.
Can you create a Updatecascade, Deletecascade relation in Ms- Access?
hai friends can u expalin about real time process of testing at the company, like flow diagram
What is the purpose of the Trap options?
my b-tech percentage is 50%. what answer will satisfy the hr ?
ssr function?
if any otion in tallyerp9 version about doing Luxury tax work
How to find get the Response time of the Online News Feeds (News headlines getting updated in every second with out any user intervention)using Load Runner ?
How do I record a prior year property tax refund on sale of asset due to overvaluation
Hi guy.. i have to face an interview in a couple of day.. so can you please give me some good and tough question on abap.
Why memory width is not 16-bit? In stead of having 8-bit in 8085?
How is the parity flag actually set in the 8085 microprocessor?
what is e-tester?
- 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)
