I want to perform this query:

select user0_.user_id as user1_1_,
user0_.password as password0_1_,
user0_.email as email0_1_,
user0_.user_name as user4_0_1_,
user0_.address1 as address5_0_1_,
user0_.address2 as address6_0_1_,
user0_.phone as phone0_1_,
user0_.status as status0_1_,
shoppingin1_.userId as userId3_,
shoppingin1_.shopping_id as shopping1_3_,
shoppingin1_.shopping_id as shopping1_ 0_,
shoppingin1_.user_id as user2_2_0_,
shoppingin1_.description as descript3_2_0_
from userinfo user0_,
(select * from shopping_info where shopping_id > 2) shoppingin1_
where user0_.user_id=shoppingin1_.userId(+)
user0_.status > 1
order by shoppingin1_.shooping_id

No HQL. Only Criteria or Expression or Etc.

Please help me.

(I'm korean. I am not so good at English. I hope you`ll overlook my mistakes in my question, if any.)

-- DDL
CREATE TABLE userinfo
(
user_id VARCHAR2 (100) PRIMARY KEY ,
user_name VARCHAR2 (100) ,
password VARCHAR2 (100) ,
email VARCHAR2 (100) ,
first_name VARCHAR2 (100) ,
last_name VARCHAR2 (100) ,
status NUMBER (1) ,
address1 VARCHAR2 (100) ,
address2 VARCHAR2 (100) ,
zip VARCHAR2 (100) ,
phone VARCHAR2 (100) ,
language_preference VARCHAR2 (10)
) ;

insert into userinfo values ('id1', 'chiang1', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id2', 'chiang2', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id3', 'chiang3', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id4', 'chiang4', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id5', 'chiang5', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id6', 'chiang6', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id7', 'chiang7', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id8', 'chiang8', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id9', 'chiang9', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id0', 'chiang10', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id11', 'chiang11', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id12', 'chiang12', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id13', 'chiang13', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id14', 'chiang14', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id15', 'chiang15', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');
insert into userinfo values ('id16', 'chiang16', '1234', 'aa@abc.com', 'abc', 'p', 1, 'd', 'e', '123-1234', '016-123-1234', 'ko');

-- shopping_info
CREATE TABLE shopping_info
(
shopping_id NUMBER (10) ,
user_id VARCHAR2 (100) ,
description VARCHAR2 (2000) ,
CONSTRAINT shopping_info_pk PRIMARY KEY (shopping_id ) ,
CONSTRAINT shopping_info_fk FOREIGN KEY (user_id ) REFERENCES USERINFO
(
USER_ID
)

) ;

insert into shopping_info values (1, 'id1', 'snack');
insert into shopping_info values (2, 'id2', 'kimchi');
insert into shopping_info values (3, 'id3', 'water melon');
insert into shopping_info values (4, 'id4', 'DVD-Batman Beggings');
insert into shopping_info values (5, 'id5', 'The Old boy');
insert into shopping_info values (6, 'id6', 'arirang');