To have a readable big numbers under oracle and to facilatet the reading, I’m looking for a way to add blank space to obtain something like that: 213537592384.236 ===> 213 537 592 384.236 The problem that I have big numbers like above. Answer Spaces are a curious separator, and not directly supported…
Tag: oracle
ORACLE ALIAS in WHERE Clause Subquery
Here is my SQL code. I used subquery and labeled it, but when I call column from that subquery, it shows that as invalid identifier. error as per below Please help me to sort out this issue. I need to call subquery’s columns also in my final SQL view. Answer You can only use colums that are in your FROM
How do I process data in Multivalued Column in Oracle PLSQL?
I am working on creating a small database in Oracle for a project at work. One of the columns will need to have multiple values recorded in it. What’s the query to create a multivalued column?
Flattening a hierarchial data set in Oracle
I have a set of data as shown below I need to flatten this data as below: And so on. I can have up to 30 parent child relationship I used the connect by and sys_connect_by_path as follows The result set is too large. There are other trees in this table and I don’t think it just looks at the
Converting Numbers to Words in MYSQL result! Using Query
I am trying to print a output as follows when I execute a query in mysql. Name Salary Sal_in_Words Mohan 45000 Rupees Forty Five Thousand Only The column Salary has a value 45000 and in the …
Select EMP with max SAL from each DEPT
I´m having a bad time with a SQL query. I´m using oracle default tables: ‘EMP’ TABLE http://imageshack.us/photo/my-images/850/sinttuloxps.png/ AND ‘DEPT’ TABLE http://imageshack.us/photo/my-images/19/assayp.png/ I wan´t to get the employee with the highest salary in each department. I´…
REGEXP_LIKE conversion in SQL Server T-SQL
I have come across this line in an old report that needs converting to SQL Server. examCodes being the source and learner_code being the pattern. I know that SQL Server doesn’t have REGEXP_LIKE and most places tell you to use PATINDEX. Here’s me thinking that this would work: But I get the error: …
Generating dates between two dates
I need to generate all dates between two given dates. This works fine as long as there is just one date range. However, if I have multiple date ranges, this solution doesn’t work. I have searched here …
ORA – 00933 confusion with inner join and “as”
I have this query of getting data from two tables using an inner join, but I get the error SQL command not properly ended with an asterix under “as”: select P.carrier_id, O.order_id, O.aircraft_id, O….
Oracle SQL. How to execute query one by one
Could you help me, how can I execute query one by one in Oracle SQL Developer? When there’s one query system works correctly. But when I write 2 or more and press “ctrl” + “enter”, System marks out all queries and trying to execute all of them. Answer Separate each query by semi-…