oracle tag

46 questions

1 answers
85 views
0

Oracle sql developer broken Korean

Hello, everyone I am studying web application.We are making a simple web of membership information through eclipse and oracle sql developerWhen you sign up as a member, the data is entered into the or...

oracle database

2 years ago

1 answers
108 views
0

Is Oracle different from Oracle's MySQL?

In the IT development process of the six-month state-funded course Today, we've started a new journey with a book called Oracle SQL and PL/SQL, which are easy to learn with a variety of examples.There...

oracle mysql dbms

2 years ago

1 answers
55 views
0

Query question.

SELECT dayName, round(sum(REVIEW_GRADE)/count(*),1) as dayAvg FROM ( SELECT A.REVIEW_SEQ, A.REVIEW_DTTM, B.REVIEW_RATING_TYP_CCD, B.REVIEW_GRADE, TO_CHAR(TO_DATE(a.REVIEW_DTTM, 'yyyymmddHH2...

java oracle

2 years ago

1 answers
96 views
0

Spring Security Oracle sql Question (incompatible column index)

List<String> type =getJdbcTemplate().query( SQL , new String[] {id, id}, new RowMapper<String>() {SELECT USER_TYPEFROM ( SELECT 'user' as USER_TYPE FROM TABLE_USER WHERE USER_ID=? UNI...

oracle java database spring-security

2 years ago

1 answers
43 views
0

Can two columns in one table be grouped together to extract only one of the most recent rows?

Column Sender | Message Code | Contents | Recipient | Time Sent A ME-1 AA B 12:30 A ME-1 AA B 12:32 B ME-1 AA A 12:31 B ME-1 AA A 12:33 A ME-1 AA C 12:30 A ME-1 AA C 12:32 C ...

oracle

2 years ago

1 answers
83 views
0

To ensure that the Oracle property value always contains a constant string...

I want to set the same string to always be entered in one property in the table.What should I do>?

oracle querying string identical

2 years ago

2 answers
63 views
0

I'd like to know how to compare different column values in the same table

There are two columns in one table, and I want to check only the ones with the same values.For example, there are columns of seq1 and seq2, and these two columns have the same sequence value I want to...

oracle

2 years ago

1 answers
122 views
0

It's a question from MAPPER

I'm planning a car rental systemWe are implementing a function that shows the rental area on the next screen after inserting the rental area and the return area on the web. There are other columns in ...

dbms insert oracle sql

2 years ago

1 answers
53 views
0

Error question creating view.

CREATE VIEW C_R ASSELECT LICENSEPLATE, CARNAME, CARMODEL, CARCOM, CONDITION, FUEL, RENT, PASSENGER, DISTANCEFROM CAR_RELATIONS CR, CAR CA, CARMODEL CM, CARCOM CO, PASSENGER PG, RENT RT, FUEL FL, CONDI...

sql oracle database erd

2 years ago

1 answers
44 views
0

SQL query question.

On the reservation table, there are columns such as SYSDATE, rental fee, rental date, return date, payment amount, and final payment amount.When the rental fee is 30,000 won per day, When I rented it ...

oracle sql

2 years ago

- 4 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656