- How to Display the Manager, Having Maximum Number of Employee?
Answered
Hello Experts, May I know that how can I display the manager who is having maximum number of employees working under him? Kindly share your valu ...
- SQL error 1555 occurred when accessing table
I am getting below ORA-01555 in DB13 warnings in CHECKDB logs very often.   ...
- Difference between Standalone Procedure and Stored Procedure
Answered
Hello,May I know that difference between Standalone Procedure and Stored Procedure?Standalone Procedure vs Stored Procedure ...
- SQL Query to find highest salary of employee in each department
How to Get the Highest Salary of Each Department? Hi All, Could you please help me to get the highest salary for each department. If multiple em ...
- How to Resolve Lag in Goldengate Process?
Hello SAP Experts,If any lag in goldengate process (Extract and Replicate both process) then how to reslove it? I want to solve it as soon as possible ...
- Can We Use DML Operations in Functions?
Answered
Hello Experts,I have this query that can we use DML operations in Functions?Kindly share your valuable views here.Thanks in advance. ...
- Use and purpose of Autonomous Transaction
Answered
What is use of autonomous transaction and kindly tell me the purpose of autonomous transaction with one real time scenario? ...
- How Can the use of the SQL editor in DBACOCKPIT be controlled?
Answered
Hello Experts,May I know that how can the use of the SQL editor in DBACOCKPIT be controlled?Kindly share your valuable views here.Thanks in advance. ...
- How to Find a SQL_ID and Top SQL query Using Temp Tablespace Which Causing Temp Tablespace to be Full?
Hi everyone,Need quick answer for this please help me.My question is that how to find a SQL_ID and top SQL query using temp tablespace which causing t ...
- Uninstall SAP MaxDB Software
How Uninstall SAP MaxDB/SAP DB Software using SDBUNINST? Solution The first thing you need to do is to stop and delete all databases that were i ...
- Do You have Any Script to Find Out Who Stopped and Restarted SQL Server?
Answered
Hello Experts,Do you have any script to find out who stopped and restarted sql server ?Please let me know if you have.Thanks in advance. ...
- Can I Insert Null values in Foreign Key Constraint?
Answered
Hello Experts,Can I insert null values in Foreign Key constraint.?Kindly suggest here, Thanks in advance. ...