Tag oracle

[Solved] MySQL Query to Oracle SQL [closed]

All you need to do is remove the < and > characters: SELECT r1.rnr, r1.anaam FROM regisseur r1, regisseur r2 WHERE r2.anaam = ‘input last name director’ AND r1.gdatum < r2.gbdatum Here’s a working demo on SQLFiddle. Presuming you don’t…

[Solved] How to do the c# string.split() in oracle

Replace the prefixes you want to remove, then find the index of the first and second underscores and then find the substring between those two separators: Oracle Setup: CREATE TABLE your_table ( value ) AS SELECT ‘DUM_EI_AO_L_5864_Al Meena Tower’ FROM…

[Solved] Nested SQL statements for Oracle [closed]

You don’t need to nest. You need to join. You’ll probably need something like this, although I would need the exact table structure to be sure. But you’ll get the general idea. select b.TITLE, a.LASTNAME, i.UNITSONHAND from BOOK b inner…

[Solved] Solve the query using join?

You only have one table so there is nothing to join on. In your current query you have no need to use a sub query .Your query should be : select name from session1 where id <>21 To find “I…

[Solved] Sql code to create the Mirror image of the string in Oracle sql [closed]

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…

[Solved] can you explain trim and what is doing? [closed]

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…

[Solved] where clause with date range give strange result

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…

[Solved] C# Error ORA 00907: Missing Right Parenthesis

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…