When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?
2 11291Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;
7 5867SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
1 6637wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010
5 8768Post New Accenture SQL PLSQL Interview Questions
Why Stabilising Resistor used in REF circuit ?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
input vat, wht use in wct
What is CaseComplete Files?
An automated bank teller system?
all question of related to window 2003 server
How to determine SGA site?
i am attending to US consulate i kept my projects on vb.net ,please help me what questions will be ask on vb.net in us consulate
How do you keep customizations during a migration?
Quote the best Indian Examples for Consolidation.
Hi,when we pass a clearing entry of paid and unpaid tax how do we show the business area the way the business area can be seen.is there any change that i have to do in the configuration of this GL.my client wants that the business area also reflects when we post the gl.please help.
What should be the height of basement according to NBCC code?
What is cri pumps & mechanical sael
what is the implemention project in sap?
When we pass the parameters in CRM_order_read function module there are number of GUID are there, how particular GUID only fetch, for example 100 GUIDs are there in database when we pass data in function module how to fecth particular guid?
- C (57)
- OOPS (10)
- C++ General (4)
- COM DCOM (1)
- Delphi (1)
- PHP (1)
- Programming Languages AllOther (13)
- JavaScript (1)
- VB Script (7)
- JSP (1)
- Awk (1)
- Scripts AllOther (1)
- SNMP (2)
- TCP IP (1)
- Protocols AllOther (6)
- Networking Administration (5)
- Networking Security (1)
- Networking AllOther (1)
- Visual Basic (1)
- C Sharp (10)
- ASP.NET (74)
- ADO.NET (5)
- Crystal Reports (1)
- BizTalk (5)
- Dot Net Framework (13)
- Dot Net WindowsForms (1)
- Dot Net General (2)
- Dot Net AllOther (2)
- Exchange Server (5)
- Microsoft Related AllOther (2)
- Oracle General (5)
- Forms Reports (1)
- Oracle AllOther (3)
- SQL Server (21)
- MySQL (1)
- DB Administration (2) SQL PLSQL (15)
- Databases AllOther (2)
- SDK (1)
- Windows Threads (1)
- Windows General (4)
- Windows AllOther (4)
- Linux System Calls (2)
- Linux AllOther (3)
- Unix Commands (2)
- Unix General (8)
- Unix AllOther (2)
- Solaris Commands (4)
- Solaris System Calls (1)
- Solaris AllOther (2)
- Operating Systems General Concepts (3)
- Data Structures (1)
- WinRunner (24)
- Load Runner (12)
- QTP (64)
- Test Director (1)
- Rational TestSuite (3)
- Selenium (1)
- Automation Testing AllOther (5)
- Manual Testing (120)
- QA Concepts (7)
- Test Cases (9)
- Test Documents Reporting (1)
- Testing AllOther (17)
- COBOL (13)
- JCL (12)
- CICS (10)
- DB2 (13)
- IMS (2)
- IBM MainFrame AllOther (14)
- RPG400 (1)
- COBOL400 (1)
- DB400 (2)
- IBM AS400 AllOther (3)
- Core Java (36)
- Advanced Java (2)
- Swing (1)
- EJB (1)
- Servlets (6)
- Struts (5)
- JDBC (1)
- J2EE (1)
- Weblogic (2)
- Java Networking (2)
- Java J2EE AllOther (1)
- Middleware AllOther (2)
- HTML DHTML (1)
- XML XSLT RSS (1)
- Teradata (4)
- Business Objects (29)
- Cognos (8)
- Informatica (60)
- Ab Initio (4)
- Data Stage (12)
- SAS (97)
- ETL (6)
- Data Warehouse General (6)
- HR Questions (34)
- Design Patterns (3)
- Project Planning (1)
- VSS (1)
- SAP Basis (25)
- SAP ABAP (155)
- SAPScript (4)
- SAP SD (104)
- SAP MM (32)
- SAP QM (1)
- SAP PP (7)
- SAP PM (1)
- SAP PS (1)
- SAP FI CO (111)
- SAP HR (20)
- SAP CRM (17)
- SAP APO (2)
- SAP Business Warehouse (20)
- SAP Security (28)
- SAP Interfaces (1)
- SAP Netweaver (4)
- SAP ALE IDocs (2)
- SAP B1 (3)
- SAP AllOther (3)
- PeopleSoft Administration (1)
- PeopleSoft Tools (2)
- Siebel (4)
- Oracle Apps Technical (37)
- Oracle Apps Financial (21)
- Oracle Apps Manufacturing (2)
- Oracle Apps HRMS (1)
- Oracle Apps SCM (5)
- Oracle Install Base (1)
- Oracle Service Contracts (2)
- ERP CRM AllOther (1)
- Client Server Architecture (3)
- AI Tools (3)
- WebMethods (7)
- TIBCO (11)
- EAI AllOther (12)
- Change Request Management (1)
- Bio Informatics (1)
- Sciences AllOther (1)
- Electrical Engineering (12)
- Electronics Communications (5)
- Engineering AllOther (4)
- Business Administration (1)
- Marketing Sales (3)
- Banking Finance (7)
- Human Resources (4)
- IT Management (2)
- Non Technical (1)
- Business Management AllOther (1)
- Audit (4)
- CompanyAffairs CS (1)
- Taxation (8)
- Accounting General (90)
- Accounting AllOther (59)
- Call Centre AllOther (32)
- APPSC AllOther (1)
- General Knowledge_Current Affairs (4)
- Government AllOther (2)
- Everything Else AllOther (6)
- English (3)
- General Aptitude (47)
- Puzzles (6)
- Placement Papers (25)
- CCNA (2)
- Microsoft Certifications (2)
- Oracle Certifications (1)
- Certifications AllOther (2)
- L1 Visa (2)
- USA AllOther Visa (4)
- Australia Visa (1)
- C Code (4)
- GATE (1)
- GMAT (3)
- Scripts Errors (1)
