• Help using oracle Analytical function.

    I am trying to create a query that will do two parallel select from the data available. I want to write one select statement using analytical functions, What I want to do is as follows: I one single query I want to find out the count of the transactions in the last 7 days from sysdate and last 6...

    Prativa0 pointsBadges:
  • Receiving SQL error message: ORA-01722

    In Oracle / SQL, I keep getting an error message when I'm trying to an insert. Here's the message: ORA-01722: Invalid number error. What does that mean? What can I do about it? INSERT INTO CUSTOMER VALUES (1,'Michael','Claire','27 Smith St Caulfield','0419 853 694'); INSERT INTO CUSTOMER VALUES...

    ITKE827,890 pointsBadges:
  • How to get unique values from column without using Distinct keyword in Oracle?

    I have a table in which the column has duplicate values in it. If i need to get unique value from that column without using distinct keyword then what will be the query?

    Sheeldk5 pointsBadges:
  • How can I write my name with this condition (First name can only contain alphanumeric characters, hyphens and apostrophes)

    How can I write my name with this condition (First name can only contain alphanumeric characters, hyphens and apostrophes)? Can anyone help me?

    Nurwarsame5 pointsBadges:
  • File size more than 180 GB for the data extracted from an internal table

    If I'm getting a file size more than 180 GB for the data extracted from an internal table. How do I resolve this issue?

    prateekdevnani5 pointsBadges:
  • How to find 10 sequencing date for today in SQL query

    It's like date 1 2 3 4 5 6 7 8 9 10 with month and year. How can I do this using a SQL query?

    sundramkharya5 pointsBadges:
  • Display only the duplicate records in SQL

    I need a query to display only the duplicate records alone. For an example, distinct filtr the duplicate records and displays the actual record. Here I need only duplicate records.

    NARMATA50 pointsBadges:
  • SQL: How to display the last name alone from the emp name where first name n lastname is in a single colum

    Is there a way to display the last name alone from the emp name where first name n lastname is in a single column?

    NARMATA50 pointsBadges:
  • SQL query replacing not in

    I wrote this query with not in replace the not in with not exist. SELECT LASTNAME , TITLE FROM NOR_EMPLOYEES WHERE EMPLOYEE_ID not in (SELECT E1.EMPLOYEE_ID FROM NOR_EMPLOYEES E1,NOR_EMPLOYEES E2 WHERE E1.EMPLOYEE_ID=E2.REPORTS_TO);

    vscbobbadi5 pointsBadges:
  • How to change SQL editor coloring in Eclipse

    In SQL, I was able to change my syntax coloring in Eclipse preferences but my normal text still remains in black. Is there a way I can change the setting?

    ITKE827,890 pointsBadges:
  • ORA-00936 error with SQL NVL statement

    I'm using Oracle and I have this SQL NVL statement: select a.*, case when NVL (SELECT max(b.field1) FROM b where b.field2 = a.tbl_a_PK , 'TRUE') = 'TRUE' then 'has no data in b' else 'has data in b' end as b_status from a My SELECT is returning one value (as it should) but I'm also getting...

    ITKE827,890 pointsBadges:
  • How to execute a message in PL/SQL from SQL command prompt

    Sir, I have written a small message using PL/SQL. When I execute that query in SQL CMD prompt, I'm unable to see my output. How can I execute my output in SQL?

    kothias5 pointsBadges:
  • Execute SQL command to send .XLS file to certain email ID

    I am using EXECUTE SQL command to send a .XLS file to certain email ID. Now when I use TOSTMF in the statement, the XLS file is getting copied in the root directory also, which is not needed. Requirement is that only email should be sent. But if I remove the TOSTMF from the statement, the XLS file...

    Supriyoas400250 pointsBadges:
  • SQL Server: Getting the identity from an inserted row

    For SQL Server, how can I get the identity of an inserted row? Do I have to use @@IDENTITY or IDENT_CURRENT? Thanks so much for your help.

    ITKE827,890 pointsBadges:
  • SQL INSERT into a table using input from second table

    For the past week, I've been looking to INSERT into a table using input from my second table. Is there a way to do this in SQL? Maybe using a syntax? Thanks so much.

    ITKE827,890 pointsBadges:
  • How to use Oracle from a user connection to the end

    Please, I would like to know how to use Oracle from a user connection to the end. Or you can just explain a SQL execution to me to answer this question. Thanks!

    collines20125 pointsBadges:
  • Oracle: Find value for each UserID that has latest date

    In my Oracle table, I have three different columns: UserID, Value and Date. I'm trying to get the value for each UserID (that has the latest date). How can I do that? Can I use SQL?

    ITKE827,890 pointsBadges:
  • SQL problem: Order results in descending order

    I'm trying to create an SQL statement that produces a listing that shows how many students are coming from each city. How can I order the results set based on the number of students from city in descending order?

    nepal1234565 pointsBadges:
  • SQLState=01534 [SQL0181] when running DML instruction in System i Navigator

    Hello, I'd like to avoid the message SQLState=01534 [SQL0181]. This appears whenever I run a DML instruction in System i navigator or RDI or ... Thanks for helping! Mathy Paesen

    mathypaesen10 pointsBadges:
  • SQL error message when creating procedure containing three cursors

    I have created a procedure containing 3 cursor. It gives me the below error and when I add @delimiter ++; at start and end it gives message that "command processed" but doesn't show output. Any suggestions? [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,...

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

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

Following