If “mirror” is reversed text use: SELECT REVERSE(‘my_text’) FROM dual; EDIT: SqlFiddleDemo SELECT t ,REVERSE(t) AS Mirror1 ,TRANSLATE(t, ‘abcdefghijklmnopqrstuvwxyz’,N’ɐqɔpǝɟbɥıظʞןɯuodbɹsʇnʌʍxʎz’) AS Mirror2 ,TRANSLATE(REVERSE(t), ‘abcdefghijklmnopqrstuvwxyz’,N’ɐqɔpǝɟbɥıظʞןɯuodbɹsʇnʌʍxʎz’) AS Mirror3 FROM tab; 2 solved Sql code to create the Mirror image of the string in Oracle sql [closed]
Use the answer to this question to sort both sides of the comparison alphabetically, and then compare the two sides with an equals operator. solved Convert SQL query to SQL Server [closed]
The error speaks for itself: Error(4,1): PLS-00103: Encountered the symbol “AS” when expecting one of the following: return Remove the AS and define what the function RETURN create or replace FUNCTION BOD_FM_FSCS_A_Data( — Add the parameters for the function here p_ExclusionsOnly NUMBER DEFAULT 0 ) RETURN NUMBER…. Here’s an example from the docs CREATE FUNCTION … Read more
In simple terms, trim removes whitespace from the beginning or end of a bit of text. For instance, it will turn ‘myvalue ‘ into ‘myvalue’ and ‘ tonsofexteriorwhitespace ‘ into ‘tonsofexteriorwhitespace’. Note that it won’t remove whitespace from the interior of the text though, so ‘ interior spaces remain ‘ becomes ‘interior spaces remain’. It … Read more
select to_char(systimestamp,’YYYY-MM-DD”T”HH24:MI:SS.FF2TZHTZM’) from dual; 2018-02-07T11:43:37.47+0800 solved How to print system date in this format “2017-04-04T05:30:27.27-0700”
there are many ways of skinning this particular cat, this is just one method. By the way in your example you gave a date of 31st April, this does not exists. SELECT TO_Char(ordered_date,’DD-MON-YYYY’) as ordered_date, order_number, customer_name FROM order_tbl WHERE NVL(:P_ORDER_NUMBER, order_number) = order_number AND ordered_date between NVL(TO_DATE(:P_FROM_DATE,’DD-MON-YYYY’),TO_DATE(’01-MAR-1900′,’DD-MON-YYYY’)) and NVL(to_date(:P_TO_DATE,’DD-MON-YYYY’),TO_DATE(’31-DEC-2100′,’DD-MON-YYYY’)) AND NVL(:P_CUSTOMER_NAME, customer_name) = customer_name … Read more
This looks like the author is comparing Apples to Oranges (no that’s too similar, how about Apples to Aliens). The performance they speak of comes form the result set being displayed in a browser (as a table) instead of waiting for hours for Brio or Toad to return results in a browser (with a crash … Read more
It is very clear that you are not creating a dynamic query properly. Space is missing between TABLE’|| C.table_name It must be something like this: EXECUTE IMMEDIATE ‘TRUNCATE TABLE ‘|| C.table_name; — see space after TABLE Cheers!! 3 solved ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT … Read more
This works: CREATE TABLE TBL_TD_USER ( USER_ID INTEGER NOT NULL , USER_NAME VARCHAR2(20) NOT NULL, PASSWORD VARCHAR2(20) NOT NULL, CREATED_BY VARCHAR2(20) NOT NULL, CREATED_DATE DATE NOT NULL, MODIFIED_BY VARCHAR2(20) NOT NULL, MODIFIED_DATE DATE NOT NULL, IS_ACTIVE VARCHAR2(1) NOT NULL, DESCRIPTION VARCHAR2(200) NOT NULL, CONSTRAINT TBL_TD_USER PRIMARY KEY (USER_ID) ); There’s no variable type named CHARACTER … Read more
WITH sample_data AS (SELECT 1 AS id, 10 AS age, 11 AS name, ‘A’ AS type FROM dual UNION ALL SELECT 2, 0, 1, ‘B’ FROM dual UNION ALL SELECT 3, 9, 11, ‘C’ FROM dual UNION ALL SELECT 4, 10, 11, ‘D’ FROM dual UNION ALL SELECT 5, 10, 11, ‘E’ FROM dual UNION … Read more