If we have multiple conditions to check, can we use like operator?
eg where empid like ('123%') or like ('23%')?
Type: Posts; User: Sant_parkash; Keyword(s):
If we have multiple conditions to check, can we use like operator?
eg where empid like ('123%') or like ('23%')?
In addition to above answers, when you fire DELETE the data will move to rollback segment, due to which it is slower than Truncate but you can recover the data.
In Oracle _ and % are Wild characters, so _ means exactly 1 ..in case of '_n' means max length is 2 and last character has to be n.
But % is for 0 or any no. of characters/numbers, so %n means...
No.
2nd and 3rd will be fast than 1st query.:confused:
But amng 2nd and 3rd which will b fast,i dont know...
But you can use RETURN keyword with procedure,so there is no difference at all in the functioning....
select count(*) from T1
select count(1) from T1
select count(PK) from T1:confused:
In ORACLE where you are creating function, you can create Procedure and vice-versa?Can someone explain the practical sceneria where Procedure will work not Function or Vice-Versa?:confused:
Thanks for the reply but i think there is a limit upto 254. I am not sure about the count but limit is definately ther.
Is there any command to display ROWS as COLUMNS and vice-versa??
Is there any parameter limit defined for a procedure(IN+OUT+ IN OUT)??
how many at max we can define??