• Why can’t I use aliases in GROUP BY clauses in Oracle SQL?

    I'm facing a situation with writing my SQL queries. I've noticed that when writing out the whole column (long case expressions, sum functions with long parameters) instead of creating aliases in GROUP BY expressions just makes the query even longer than it should be. But I don't think Oracle SQL...

    ITKE351,965 pointsBadges:
  • How to use variables in Oracle with SQL Developer

    Here's my situation: I'm able to use variables in SQL Server. Here's an example: DECLARE @EmpIDVar INT SET @EmpIDVar = 1234 SELECT * FROM Employees WHERE EmployeeID = @EmpIDVar But I can't seem to figure out how to do it in Oracle using SQL Developer. How can I do it?

    ITKE351,965 pointsBadges:
  • Conversion of function VB into VB.NET

    How can I convert below VB function into VB.NET? Public Function FChkUserLoggedIn(LoginId As Long) As Boolean Dim rs As ADODB.RecordSet, strsql As String Set rs = New ADODB.RecordSet 'strSql = "select msession from log where msession in (select msession from log where loginid = " & LoginId...

    93223191245 pointsBadges:
  • Finding an extension -VBSCRIPT

    I need help with a script I am working on. I am looking to find a file by extension, put that script in the All Users profile and have it run on startup. The problem is I need the script to go out search the C: drive and find the file by the file extension not the file name. I have written a...

    Saianng5 pointsBadges:
  • Device Discovery in network

    Hi, I am trying to discover Devices in network. I have a Rang of IPs. I need to know what are the possible steps to Discover Devices with this IPs I am using Perl Script. Most of the Devices has SNMP Enabled. I have UserName and password. I need to find in Device: SNMP Name Device Layer Location...

    ManishRoy5 pointsBadges:
  • Converting from HTML to PDF

    I need to convert 503 files from HTML to PDF what is my best bet? Easy and simple over free. Small budget but want to hear suggestions any platform.

    ITKE351,965 pointsBadges:
  • Is there a GodMode for Windows XP?

    I was wondering does anyone know if there is a GodMode for Windows XP? I read an article that the new "Windows 7" has a GodMode. It said it has GodMode functionality, all you need to do is create a new folder and then name it to the following: GodMode.{ED7BA470-8E54-465E-825C-99712043E01C}....

    Jreifenstein001185 pointsBadges:
  • Getting ORA-011033 error message: Oracle initialization or shutdown in progress

    I've been trying to connect to an Oracle user through TOAD or Oracle Enterprise Manager but I keep getting this error: ORA-011033: ORACLE initialization or shutdown in progress What should I do here?

    ITKE351,965 pointsBadges:
  • Domino Lotus Web Development

    Hi, I have two forms with some text fields. on click of a button in form1, i am opening form2. I want some of the values of form1 needs to be populated to text field in form2. Please advise.

    Jacksaro40 pointsBadges:
  • Integration of Domino web applications with Microsoft sharepoint

    Now domino and microsoft have some common ground of web services, we are interested in integrating Domino web apps with Microsoft exchange/communicator and sharepoint infrastructure, anyone know of any good articles or guidance on where to find good development data on this?

    Smiley215 pointsBadges:
  • Is it better to develop Web or Java based applications for the BlackBerry? Why would I choose one over the other?

    Is it better to develop Web or Java based applications for the BlackBerry? Why would I choose one over the other? This question is sponsored by RIM.

    RIM30 pointsBadges:
  • Duplicate object (PF) using SQL with same attributes

    I want to create a duplicate object using SQL. I don't want to use CRTDUPOBJ and also do not want to compile my rpg's pgm because of new file level identifier. Please advice

    Anwer5 pointsBadges:
  • Bundling MySQL Community Edition

    Is it free to Bundle the MySQL Community Edition within our Product or along with our Product CD/DVD? Do we need expose the source of whole application software or product to the community? Our product is our main bread/butter of the company. Let me know what options are avaliable and how to do it.

    Rajeshbs45 pointsBadges:
  • How can I build cacading Dropdown Lists with Parent-Child Relationship in SharePoint

    Hi, We run 2007 Server, and we have several lists, and there is a parent child relationship. When user selects first column (parent) second column (child) values should be filtered based on parent column selection (basically getting Country and state functionality; when user selects country in...

    Javacrazy25 pointsBadges:
  • How to store Form values in Oracle 10g with VB.NET

    How do I store form values in Oracle 10g database storage in VB.NET 2005?

    Shaz255 pointsBadges:
  • Catching an uncaptured error in SQL

    This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' ) end END TRY BEGIN CATCH SELECT 'Error Caught' SELECT...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to calculate two business days in Oracle

    I've been trying to calculate business days between two different dates in Oracle select. I've reached the point that my calculation is giving me the correct results (mostly) for the dates but sometimes it varies from 2 days to -2 days. Here's what I have: SELECT ((to_char(CompleteDate,'J') -...

    ITKE351,965 pointsBadges:
  • Implementing access from a remote site to a SQL Server 2000 database

    I have been tasked to set up access from a remote site to a SQL Server 2000 database. The user interface was programmed in .NET. This database will sit outside our firewall and will be protected by its own firewall. The application currently uses an ODBC connection to the database. Do you have any...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to use bulk insert from Java to Oracle

    I'm looking to insert several small rows quickly into Oracle. Using MySQL, I broke the inserts into groups of 100, then use one insert statement for every group of 100 inserts. But with Oracle, the mass inserts are way too slow. Is there a way I can speed it up?

    ITKE351,965 pointsBadges:
  • How to get the user profile using SQL stored procedure

    Does anyone know how to get the user profile using SQL stored procedure?

    florydel115 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following