nishikanta swain


{ City } jajpur
< Country > india
* Profession * plsql developer
User No # 109092
Total Questions Posted # 16
Total Answers Posted # 3

Total Answers Posted for My Questions # 29
Total Views for My Questions # 56998

Users Marked my Answers as Correct # 4
Users Marked my Answers as Wrong # 0
Questions / { nishikanta swain }
Questions Answers Category Views Company eMail

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

TCS,

1 SQL PLSQL 2747

How did you export data from database to excel file.

TCS,

1 SQL PLSQL 4626

Difference between global and parameter variables?

TCS,

SQL PLSQL 1446

What is extent clause in table space?

TCS,

1 SQL PLSQL 2759

What is the use of time stamp in select statement?

TCS,

1 SQL PLSQL 3030

Which data type doesn't allow null data type?

TCS,

6 SQL PLSQL 7511

What is window clause?

TCS,

1 SQL PLSQL 3364

Can you alter start with clause?

TCS,

1 SQL PLSQL 3799

how view used for security purposes?

Glam India,

3 SQL PLSQL 4501

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

MasterCard,

1 Oracle General 3118

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

MasterCard,

1 Oracle General 2619

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

MasterCard,

2 Oracle General 2707

how to we delete a row using varray

CTC,

3 Oracle General 3316

if i am using dml statement in function. then i am writing select statement what was the output

MasterCard,

2 Oracle General 3256

difference between bind variable and variable

Attra,

1 Oracle General 2334

 [1]   2    Next



Answers / { nishikanta swain }

Question { British Telecom BT, 9677 }

write a query to count number of alphabets in given string
for example "APPLE"

write a query to generate sequence from 50 to 100


write a query to display in single string "ABCD,EFGH,IJKL,PQRS"


Answer

1.SELECT 'APPLE' STRING,LENGTH('APPLE') FROM DUAL;
2.SELECT ROWNUM RN FROM DUAL CONNECT BY ROWNUM<=100 MINUS SELECT ROWNUM RN FROM DUAL CONNECT BY ROWNUM<=49;
3.SELECT 'ABCD,EFGH,IJKL,PQRS'STRING,
REPLACE('ABCD,EFGH,IJKL,PQRS',',') FROM DUAL;

Is This Answer Correct ?    0 Yes 0 No

Question { 6048 }

write a query to find 4th max salary


Answer

select distinct sal from table_name t1 where 4=(select count(distinct sal) from table_name t2 where
t1.sal<=t2.sal);

Is This Answer Correct ?    0 Yes 0 No


Question { HSBC, 11439 }

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?


Answer

using pragma autonomous transaction

Is This Answer Correct ?    4 Yes 0 No