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

    ITKE355,620 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...

    ITKE355,620 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?

    ITKE355,620 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') -...

    ITKE355,620 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.

    ITKE355,620 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:
  • Haversine formula in RPG or SQL

    I need to put the haversine formula in an sql or rpg function on the as400 to calc the distance between to zip codes. I do not have much experience with sql. can anyone give me some help?

    Brenger170 pointsBadges:
  • IT Scripts compilation

    This is just a small compilation of questions in which a script was provided as part of the answer. Having them under the IT Scripts tag could help others find them when needed. A small Windows' bat script to dinamically construct a SQL Talk backup script according to the current system date: Embed...

    thongtarget21485 pointsBadges:
  • Oracle: How to handle a single quote

    Would I be able to insert a record in a column that has VARCHAR data type with a single quote in it? Or should I use two single-quotes?

    ITKE355,620 pointsBadges:
  • Oracle SQL Query

    I have created two tables. One is Item_Master table with the fields Itemno having Primary key and must begin with letter ‘I’, Item_Name(HDD, MONITOR, CDROM, KEYBOARD, UPS), Stock defined as Not Null and Price which is greater than 10000 and less than 30000.Another table is Item_Trans with the...

    RaviMangalore5 pointsBadges:
  • Copy a SQL Binary Large Object (BLOB) from one database to another

    Is there  a way to find out the name of a Blob stored in a database. I am trying the code below and apparently the name is not correct. SQL> Declare   2   tpsr Blob;   3   spsr blob;   4  Begin   5   Select '8502' into tpsr from ca90joetmp.spec_form_psr where spec_form_id = '90710';...

    Bobf15 pointsBadges:
  • Export Oracle data to Excel

    Is there sql code to export data from oracle to excel? I can right click on the data set to export but need to include it as part of the code. Any help would be much appreciated! Thanks

    ITKE355,620 pointsBadges:
  • Inserting 50000 rows using FORALL statement

    How can we insert 50000 rows by using FORALL,please give me entire code?

    Ramesh5530 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