Comments by Bittu14 (Top 76 by date)

in the output.

Thanks a lot.

I have used listagg tag for merging.

STUFF and FOR XML is not working in SQL Developer software..

Yes.

I have modified the question. Is this is ok for you?

ok. Thanks for your information.

Thank you so much Schatak.

suppose, I do not know what are the values has stored in the table. I need to find the duplicate values from the table, based on the ENAME column.

So, how I will find it, that is my simple question.

If i will give the name over there then also the DUPLICATE variable having some problem.

How I will put the name over there? Assume I am not able to see the table then how i will find that duplicate value?

It has shown the error - "ORA-00979: not a GROUP BY expression".

Thanks.. It is working.......

If i have set only one value in an one textbox, for others remains blank then only it has shown the success message.

Hi Manas,
It has validated only one textbox..

Thanks.
Could you please tell me how i will find out the lock session for a particular schema.

Thank you so much..

select
t2.seq_no
from test21 t1,
(select t3.name, row_number() over (order by t3.name) as seq_no
from (select distinct name
from test21) t3
) t2
where t2.name = t1.name
order by t1.id

this query has given the exact answer but when ever i have tried to update then only i have faced the problem. Please help me out..

update test21 set SEQ_NUM =(select
t2.seq_no
from test21 t1,
(select t3.name, row_number() over (order by t3.name) as seq_no
from (select distinct name
from test21) t3
) t2
where t2.name = t1.name
order by t1.id)


I've tried the above query but now I am getting the below error

"ORA-00907: missing right parenthesis" can you please suggest what I am doing wrong here?

I want the update code. When I have tried this then some error occurred.

If I have used distinct query for the column 'Name', then the result should be -

NAME | ID
-------------
Arijit | 120
Suman | 121
Priyam | 122
Suvayu | 124

Next, if I run the row_number()function based on the NAME column then the result should
be -
Arijit | 120 | 1
Suman | 121 | 2
Priyam | 122 | 3
Arijit | 123 | 1
Suvayu | 124 | 4
Priyam | 125 | 3

This is my logic. But I doesn't apply this with the update query. Please help me out.

The logic behind the number is nothing. It has come as per the data sequence.

I have tried this below query. but it has not work.
UPDATE INFO_T
SET SEQ_NO = (SELECT ROW_NUMBER() OVER(ORDER BY NAME)
FROM INFO_T)
WHERE (SELECT DISTINCT NAME FROM INFO_T);

I have used some constraints over there, so that it has stared from 120.
Yes i understand. Once again sorry.

Data has stored based on nothing. Means first I have insert arijit, suman like this. If you can insert the data like arijit, priyam, suvayu, that doesn't matter.
id is primary key. i have entered worng data. sorry for that. i have changed it. check once.

But it has not clear for me.

I know. I want it in SQL only. Search engine optimization in pl/sql.

I used that one. But it has not fulfilled the exact requirement. See the example I given above.

Thanks Sisir.

Thanks Marciej Los

Oracel developer software.

Oracel SQL Server 2008...

ok.

For create the table I used the below query:

CREATE TABLE EMP_DETAILS
( EMP_ID NUMBER(5,0) NOT NULL ENABLE,
FIRST_NAME VARCHAR2(150 BYTE) NOT NULL ENABLE,
LAST_NAME VARCHAR2(50 BYTE),
AGE NUMBER(2,0),
ADDRESS VARCHAR2(150 BYTE),
SALARY FLOAT(126) NOT NULL ENABLE,
DEPT_ID NUMBER(3,0) NOT NULL ENABLE,
DELETE_DATE DATE,
PRIMARY KEY (EMP_ID),
FOREIGN KEY (DEPT_ID)
);

And the query for created View for this table is below :

CREATE OR REPLACE VIEW EMP_DETAILS_VIEW AS
SELECT EMP_ID, LAST_NAME, ADDRESS, AGE, SALARY, DEPT_ID, DELETE_DATE FROM EMP_DETAILS
WHERE DELETE_DATE IS NULL;


Now I want to add the FIRST_NAME column into this EMP_DETAILS_VIEW, for that I used ALTER clause which is below :

ALTER VIEW EMP_DETAILS_VIEW AS
SELECT EMP_ID, FIRST_NAME, LAST_NAME, AGE, ADDRESS, SALARY, DEPT_ID, DELETE_DATE
FROM EMP_DETAILS
WHERE DELETE IS NULL;

But it has been thrown error. Which I already told you.

But I did not want to do this as like hard coded.

Ok. I did not post any think twice. Sorry for the inconvenience.

A red line has shown before the "AS" clause.

Nothing leave it.

Yes, I tried that, but it has an error.

Can you please let me know where is the actual problem.

I already tried that one.

My query which I wrote :

ALTER VIEW BISA1.EMPLOYEE_DETAILS_VIEW AS
SELECT EMP_ID, FIRST_NAME, LAST_NAME, AGE, ADDRESS, SALARY, DEPT_ID
FROM EMP_DETAILS;


And it has shown some error:

SQL Error: ORA-00922: missing or invalid option
00922. 00000 - "missing or invalid option"
*Cause:
*Action:

I already tried that alter it has shown some error which I was post.

Yes. But I did not get any proper answer.

One think KM Perumal, if I want to add any column inside a View then what I have to do. I was tried to ALTER that but it had shown some error. Can you please help me out of that.

Thanks... :) @KM Perumal

Yes it is. Just I wrote one where clause on it.

Yes I solved the problem. Really I am very thank full that he did this for me. Try
this one :

CREATE OR REPLACE VIEW EMP_DEP_VIEW AS
select t1.EMP_ID, t1.FIRST_NAME,t1.LAST_NAME, t1.AGE, t1.ADDRESS, t1.SALARY, t2.DEPT_ID, t2.DEPT_NAME from EMP_DETAILS t1, DEP_DETAILS t2
WHERE t2.DEPT_ID = t1.DEPT_ID;

It will show you the actual result without using any join query.

THANK YOU SO MUCH.

THANK YOU SO MUCH.

I know this process. But I want to change it through SQL query.

Error starting at line : 1 in command -
ALTER VIEW BISA1.EMPLOYEE_DETAILS_VIEW AS
SELECT EMP_ID, FIRST_NAME, LAST_NAME, AGE, ADDRESS, SALARY, DEPT_ID
FROM EMP_DETAILS
Error report -
SQL Error: ORA-00922: missing or invalid option
00922. 00000 - "missing or invalid option"
*Cause:
*Action:

I tried the query

[ ALTER VIEW BISA1.EMPLOYEE_DETAILS_VIEW AS
SELECT EMP_ID, FIRST_NAME, LAST_NAME, AGE, ADDRESS, SALARY, DEPT_ID
FROM EMP_DETAILS;]

but it will give some error.

I can't under stand it. Can you please give me another link to me for better understand.

I did not get you. About your second answer.

Then the error was occurred. That is:
Error starting at line : 37 in command -
ALTER TABLE EMP_DETAILS
MODIFY SALARY float (5,0)
Error report -
SQL Error: ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"
*Cause:
*Action:

Yes I know that. But I tried the bellow query:

ALTER TABLE EMP_DETAILS
MODIFY SALARY float(5,0);

Is there is any syntactical error?

Thank You Mehdi...

Ok.. Thank you...

Thank you so much Syed......

yes I understand. Actually I am a new trainee in vb.net that's why I am asking. If You provide me any article or any link for that then it will be helpful for me.

Did you understand what I am wanting too..

That is the question. Means I have to create a project in visual studio 2012.
In design part there will be a button and one OBOUT grid. After clicking on the button data will be shows in that grid and as well as it will export the grid data to an excel sheet.

yes.
but we have to use obut grid for that.

Did You please tell me the actual answer? It will be helpful for me.

Ok. Thanks.

Thanks.
But I need the above output not the below one -
C:
C:/Ram
C:/Ram/Ram1
C:/Ram/Ram1/Ram2

1) Input is already given, means we can't take the input from user.
2) To print the output we can use only one print statement option, means we
will print the output using only one print statement.