how to get required data from oracle
source is like this
i want my target data like
to get data using %_05_%
but it will give
how can i get my target data?
Answer / mukesh
select source_field from
(select rownum rn,source_field from source_data
) where rn In(1,2)
|Is This Answer Correct ?||1 Yes||2 No|
How to run create database statement again?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
How to filter out duplications in the returning rows using oracle?
How remove data files before opening a database?
what are the advantages of running a database in archive log mode?
how to make an oracle object
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
Explain an exception and its types?
What is integrity and what is constraint??Explain with example
what is integrity constrains?
How many types of table in Oracle?
What is oracle thin client?