• Can you force a user input in a SQL statement, then have the statement continue running

    Hi, can one in an SQL statement, when running in SQL, force a user input to be entered and when entered? The SQL continues to complete.

    Bugsy5 pointsBadges:
  • Get all the numbers between two numbers in Oracle SQL

    Does anyone know of a way to select the numbers (or integers) that are included between two numbers with SQL in Oracle? I can't create a PL/SQL procedure for this. Here's an example: I need to get the numbers that are between 3 and 10. Obviously, the results would be 3,4,5,6,7,8,9,10. How can I do...

    ITKE371,730 pointsBadges:
  • DDS or SQL

    We have an existing COBOL application using files defined in DDS format. We are considering to move from DDS to DDL for future development. What is the best strategy to take this approach?

    Uiiuo50 pointsBadges:
  • insert date only into SQL table

    The getdate() function returns the date and time. How can I just get the date?

    Gina35 pointsBadges:
  • Automate TSQL Query Output

    I want to have a stored procedure run on a schedule that automatically creates a database output file as a result and saves it to a specific location on my network. Can someone please tell me how to do this?

    Eabouzeid175 pointsBadges:
  • Sum using SQL

    What I want to do is the following: Name_Patient......... amount........ xxxx aaa................................500.................500 bbb...............................500...................500 aaa................................500..................1000 I want to make the field named xxx to...

    mohammedwagihe5 pointsBadges:
  • Convert Oracle code to Microsoft SQL code

    I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?

    VelameLaCosa110 pointsBadges:
  • Error in running SQL Plus

    When running SQL plus of Oracle 9i, after giving user id and password protocol adapter error is there. I used both id an pw i.e. system and manager or scott/tiger

    Krshah5 pointsBadges:
  • Error in SQL coding

    I am having a specific problem with coding in SQL, and I was curious if you could give me any advice. I have entered this code: CREATE TRIGGER UpdateAfterPayment On SupplierTransactionDetails For Insert, Update, Delete As Update S If i.DebitValue>0 S.Balance = S.Balance + i.DebitValue else...

    SQL Server Ask the Experts2,585 pointsBadges:
  • JUN invalid identifier error message in Oracle SQL

    I'm currently working on a project that I need to display the number of employees that were hired for the past 20 years (1994). But I keep getting this error in Oracle SQL: "JUN' invalid identifier. What should I do? Here's my code: Select employee_id, count(*) From Employee Where...

    ITKE371,730 pointsBadges:
  • 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...

    ITKE371,730 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?

    ITKE371,730 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:
  • 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') -...

    ITKE371,730 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:
  • SQL query

    I have a table like this... emplid   qualification 101           b.tech 101            java 101            cpp 102            java 102            sql I want the output as: emplid      qualification1       qualification2          qualification3 101      ...

    raghib5 pointsBadges:
  • Inserting multiple rows in Oracle 10g

    I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific...

    Ora mer20 pointsBadges:
  • How do I check the maximum number of connections in an Oracle database?

    Would be the best way, using SQL, to actually check the maximum number of connections that are allowed in an Oracle database. I need it to show the current number of sessions and the total number allowed. Appreciate any help.

    ITKE371,730 pointsBadges:
  • about oracle with Java

    What is future of Oracle with Java regarding jobs for freshers and distance learners. Why I am asking this because I am learning oracle from SQL star tutorial in delhi and doing MCA from Sikkim Manipal University in distance learning.

    Qqqq10 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.