How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?
11 17343How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).
2 5903suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.
7 7894Post New IBM SQL PLSQL Interview Questions
Tell some standard order types and what configure done for current project
which backup strategy you are following at ur company
how many types of survey and what are levelling instrument?
Does anyone have best practices for daily backup &restore process for qc 11 ?
Can any one help me with Appian Interview Questions?
How to get different checks and different amount in APP run?
The syntax of command statement in UNIX
Do you have any relocation problem?
what is accuracy ? in any meters , coils accuracy . how can u defined that ?
who will able to deduct the tds
i need test cases for defect maganement tools
What mean by MLTP
Where is the resultset of a sqlquery (which is fired by rsobj.open sqlquery,xxxx,xxxx) stored ?
What happens if we give the supply to the rotor of induction motor and make its terminal shorted?
can any one tell in easy method for circulating current ??
- 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 (36)
- 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 (68)
- MySQL (3)
- DB Architecture (1)
- DB Administration (11)
- DB Development (9) SQL PLSQL (41)
- Databases AllOther (7)
- Windows (3)
- 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 (3)
- 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 (13)
- WinRunner (10)
- Load Runner (28)
- QTP (176)
- Test Director (3)
- Rational TestSuite (4)
- Silk Test (9)
- Selenium (1)
- Automation Testing AllOther (10)
- Manual Testing (279)
- QA Concepts (23)
- Mobile Testing (3)
- Test Cases (21)
- Test Documents Reporting (2)
- Testing AllOther (12)
- Apache (1)
- Servers AllOther (6)
- COBOL (139)
- JCL (134)
- CICS (34)
- DB2 (84)
- IMS (11)
- IDMS (1)
- Natural (6)
- Assembler (1)
- QMF (2)
- MVS (2)
- OS390 (2)
- VSAM (11)
- Sysplex (1)
- IBM MainFrame AllOther (40)
- RPG400 (59)
- DB400 (3)
- COOLPLEX (1)
- IBM AS400 AllOther (49)
- 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 (168)
- 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)
- Pega (10)
- 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 (27)
- Chemical Engineering (2)
- Instrumentation (4)
- Engineering AllOther (17)
- Business Administration (11)
- Marketing Sales (14)
- Banking Finance (41)
- 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 (98)
- 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)
