Αποτελέσματα Αναζήτησης
To convert a DATE column to another format, just use TO_CHAR() with the desired format, then convert it back to a DATE type: SELECT TO_DATE(TO_CHAR(date_column, 'DD-MM-YYYY'), 'DD-MM-YYYY') from my_table
19 Φεβ 2015 · For example: UPDATE CONTACT C SET (C.PHONE, C.FAX) = ( SELECT P.PHONE, P.FAX FROM PERSON P WHERE P.PERSON_ID = C.PERSON_ID ) WHERE C.CURRENT_YEAR_ID = ( SELECT CURRENT_YEAR_ID FROM CURRENT_YEAR WHERE DEFAULT_YEAR = 1 ); (You'll have to check my logic, because I'm not entirely clear on your relationships.)
18 Μαΐ 2021 · SQL Developer will export dates as excel dates, and then the Custom format specification (in Excel) can be used to format the dates however you choose. For example, here's what came out of SQL Dev for ALL_OBJECTS
31 Δεκ 1999 · Oracle Database uses an internal format for storing DATE data. Therefore, before inserting date data in a non-standard format into the database, you have to use the TO_DATE() function to convert it to the Oracle’s internal date format.
5 Απρ 2023 · Now we update the data in T1 using a join to the T2 table. We want to update the T1.CODE and T1.DESCRIPTION values, using the values from T2.CODE and T2.DESCRIPTION using a join in the ID value. update t1 a set a.code = b.code, a.description = b.description from t2 b where a.id = b.id and b.id <= 5;
This statement updates the value of a single column, FLIGHT_NUMBER, in a particular row. The row to be updated is specified using a WHERE clause. After the update operation, a SELECT statement displays the data in the FLIGHTS table. Verify that the specified column was updated.
15 Μαρ 2010 · If you have lots of records to update, use join, so something like: update (select bonus from employee_bonus b inner join employees e on b.employee_id = e.employee_id where e.bonus_eligible = 'N') t set t.bonus = 0;
