how to get required data from oracle
source is like this
ram_05_seetha
lax_05_viswa
bamr05frummy
run_01_away
sw_sas_trim
i want my target data like
ram_05_seetha
lax_05_viswa
to get data using %_05_%
but it will give
ram_05_seetha
lax_05_viswa
bamr05frummy
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 |
Explain what are the different type of segments?
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
what is primary key and foreign key when and where have to use
How to call a stored procedure inside a trigger? Give an example.
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
What is an external table?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What are virtual columns?
What is Data Block ?
How to insert a record into a table?
What happens to indexes if you drop a table?