Question:
I do not understand the following even I read the explanation in the textbook, anyone can help?
SELECT department_id, job_id, manager_id, SUM(salary)
FROM employees
GROUP BY department_id
ROLLUP(job_id)
CUBE(manager_id)
Solution:
Check whether the below link helps
http://psoug.org/reference/rollup.html
Question:
If you have a table and add columns such as:
employeeName, CompanyName, Departname, CityName…
which normal form or rule is being violated? The above is basically creating one mammoth table to hold values, even if the column doesn’t apply to the record.
Solution:
>> employeeName, CompanyName, Departname, CityName
* Several employees can be from a single Company and hence Company [...]
Question:
I have designed a report in crystal report 8.5. report is in 3 pages. there is a amount field. I want to have a total of that at the end of the page. how do I do that
Solution:
You need to total for that page
In the page header add a formula
WhilePrintingRecords;
Global NumberVar pageTotal;
pageTotal := 0;
”
In the [...]
Question:
Hi, Experts
I would like to share some information located at main report with sub report. For example, in main report have quantity, so in my sub report the quantity will be used for some calculation.
How can it be share in sub report or any other ways for me to get the quantity data?
Thank you in [...]
Question:
Hi guys,
I have a serious problem with Apex LDAP Authentication.
I have surfed the internet to know sth about LDAP and now i think my dn string should be like this:
cn=adminapex,cn=users,dc=apc,dc=info
But when i want to run the attached query to check if it’s connect successfully to LDAP or not,I faced this error massage.
<b>
Error report:
ORA-31202: DBMS_LDAP: LDAP [...]
Question:
Name
Jason
Jason
karl
karl
karl
greg
could someone give me help with the query for finding this
Name AutoInc
Jason 1
Jason 2
Jason 3
karl 1
karl 2
greg 1
Thanks
My code so far is as follows,
I need to concat surname+firstname as ‘CAT’
And then give a count to all the duplicate ‘CAT’ feilds (so i can eventually only choose the one with the most info attatched to it.)
Then [...]
Question:
The code gives me a total of calls for each month. All I want to do is create a column called “Order” that will auto increment for every result returned.
e.g.
Order | Month | Open_Calls
—————————————-
0 | Aug 2009 | 2000
1 | Sep 2009 | 1700
2 | Oct 2009 | 1800
etc.
Code Snippet:
SELECT
SUBSTRING(CONVERT(varchar(12),CAST(CONVERT(varchar(6),MY.MonthYear,112) + ‘01′ AS datetime)-1, 113),4,8) [...]
Question:
i put our code on our windows server 2003 , IIS6
the crystal report works couple of times and the we have the error load report failed
olease see attached image
here is the code
private void LoadLibrary()
{
try
{
CrystalDecisions.Shared.ConnectionInfo connectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
connectionInfo.DatabaseName = “x”;
connectionInfo.ServerName = “y”;
connectionInfo.UserID = “z”;
connectionInfo.Password = “a”;
CrystalDecisions.CrystalReports.Engine.ReportDocument crdProgressTarget = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
string FileName;
FileName = Server.MapPath(“Reports/rAsset.rpt”);//””
Random MyRandomNumber = [...]
Question:
I’m running mysql on a windows 7 virtual machine and I’m trying to connect with the mysql client from an ubuntu 8.0.4 instance. I just installed the mysql client on ubuntu. When I try to run mysql from the command line, I get the message:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket [...]
Question:
Hi,
I know we can use oracle obfuscation kit to encrypt pl/sql code or actual data stored in database table but I would like to know if we can obfuscate oracle database schema, table structure.
I would like to know how we can obfuscate table name, column name in Oracle database. Please help me understand how this [...]