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

    ITKE409,090 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?

    ITKE409,090 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...

    ITKE409,090 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.

    ITKE409,090 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.

    ITKE409,090 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?

    ITKE409,090 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.

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