Data dodania Pytanie
2017-06-05 09:06 Reading Oracle Explain plan »
explain plan for SELECT * FROM schema2.mv_a_data mv WHERE mv.routing_code_type_id = 3 AND mv.static_data_status_id IN(5, 8) ...
(3) odpowiedzi
2017-06-04 20:06 Stuck with linking SQL queries together »
I'm trying get the MAX value of my subquery denoted as NUM_of_CUST column and to display it alongside with the artist name in tge main query so it wou...
(2) odpowiedzi
2017-06-04 10:06 How to fetch different records in same row in sql? »
I have a table structure similar to one given below 1001 Jon 1002 Jacob 1003 Cayle I want to fetch records from table in a way that it sho...
(3) odpowiedzi
2017-06-04 07:06 Usage of Oracle virtual column to increment value »
This an attempt to the test the usage of the VIRTUAL column with a function to increment the value in a column. I am using a function which would ret...
(1) odpowiedzi
2017-06-03 17:06 group by and select max with value null »
I have a next problem with query SELECT T.DETALLE_BECA_ANIO anio, T.DETALLE_BECA_MES mes, T.DETALLE_BECA_NIVEL_EDU_ID edu_id, T.DETALLE_BECA_TRAMO_I...
(1) odpowiedzi
2017-06-03 06:06 Obtain the total of a condition in the same query »
I'm trying to create a query, which consists of get a percentage. Here is the structure of the tables: STransaction: TRANSACTIONID -> NUMBER(10,0...
(2) odpowiedzi
2017-06-03 02:06 Oracle SQL max() with group by - duplicated values »
This is a simplified version of a query I created that gives me what I want (a list of all stud_id with the selected cpnt_id, whether there is a value...
(2) odpowiedzi
2017-06-02 06:06 PL/SQL returning a list in a CASE statement »
I need a CASE statement to return a list of strings but I'm having some syntax problems. The resulting SQL should be something like this: SELECT * FR...
(1) odpowiedzi
2017-06-02 01:06 Oracle's to_date function returns a non existing date »
When java.util.Date is parsing "01/01/1901" to a Date objet, Java API is converting the date to “01/01/1901 0:08:39” instead of “01/01/1901 0:00...
(1) odpowiedzi
2017-06-02 00:06 SQL - Cross Join when Left Join isn't met »
I am unsure if this is even the correct way to do this but I'll explain the situation. I have two tables, the first table is a list of products while...
(3) odpowiedzi
2017-06-01 19:06 Turn xml into a string using PHP »
I do query an oracle database for a field that stores xml content using blob data type I want to generate a string to pass as parameter to a simplexm...
(1) odpowiedzi
2017-06-01 11:06 Oracle SQL - Keep null value if it's the only one, else avoid null value »
I have this table : Table1 ----------------- ID VAL ----------------- 1 A 1 B 1 null 2 null 3 ...
(2) odpowiedzi
2017-06-01 10:06 plsql number formating 9'999.00 »
I'd like to format a number in a PL/SQL select like this 9'999'999.00 How can I do this? It works for 9,999,999 with the following command to_cha...
(1) odpowiedzi
2017-05-31 23:05 CHECKSUM_AGG Equivalent in Oracle »
I have a query with STANDARD_HASH(Column1|Column2|ColumnN, 'MD5') AS HashValue for each row in a table. Is it possible to GROUP by ColumnX and p...
(1) odpowiedzi
2017-05-31 12:05 Cursor infinite loop »
This question is just out of curiosity. I am trying to find out what happens when no exit condition is specified for a cursor. What happens after last...
(2) odpowiedzi
2017-05-31 09:05 PLSQL Special Character in input parameter is not being passed »
Please find below my function: CREATE OR REPLACE FUNCTION TESTER_TESTING ( P_STRING IN VARCHAR2) RETURN NUMBER IS BEGIN Dbms_Output.Put_L...
(2) odpowiedzi
2017-05-30 18:05 How to clear stored substitution variables in Oracle SQL developer »
Suppose I have a query: SELECT * from table1 tr where tr.start_time < &&starttime; First time i execute the query, SQL Developer prompts...
(2) odpowiedzi
2017-05-30 14:05 Sql group by query with combine data »
Hi I have one requirement. I have below data in my table. ID REASON FLIGHT_KEY_ID FLIGHT_NO ...
(2) odpowiedzi
2017-05-30 07:05 Filter sql records on multiple time periods in codeigniter and mysql? »
Table Group_Users id | user_id | join_time | left_time ----------------------------------------------- 1 | 123 | 2017-05-29 15:26:00 |...
(2) odpowiedzi
2017-05-29 21:05 Oracle group by only ONE column - update »
I am stuck in similar situation as this. I have multiple columns with different types of data, and I want to select all columns but group by it with o...
(1) odpowiedzi
2017-05-29 13:05 Getting around queries that use UNION in JPA »
So I'm migrating some services from and old application that used native queries to retrieve data and I've found some issues and would like to discus...
(1) odpowiedzi
2017-05-29 11:05 Updating the parent table considering the values of the child table in oracle »
I have table Parent_tbl which consists of 3 columns H_N, Col58 and Type this both the first two columns will be having the same values, only the colum...
(2) odpowiedzi
2017-05-28 22:05 Minimal Oracle DDL to bump DBA_OBJECTS.LAST_DDL_TIME »
I'm using an external tool that scans tables in my database. It uses dba_objects.last_ddl_time to determine which tables have been scanned. Obviously,...
(1) odpowiedzi
2017-05-28 14:05 java persistence with dates »
I have problems executing an orm query in an oracle database, when one of its parameters is a date string this is the query : <named-native-quer...
(1) odpowiedzi
2017-05-28 00:05 Changing tablespace increment size »
One of our datafiles hit the max of 32G. So, we created a 2nd datafile in that tablespace. However, we forgot to give a default NEXT size. So, file...
(1) odpowiedzi
2017-05-27 23:05 odp db specific value pull from dataset using powershell »
I have connected to my oracle db and pulling data using a datatable in dataadapter My dataadapter output is similar to below NO NAME ...
(1) odpowiedzi
2017-05-27 18:05 Oracle SQL Like »
I'm trying to get all the addresses that start with letters, when I say a specific letter there are no problems. SELECT customer_name, customer_a...
(3) odpowiedzi
2017-05-27 17:05 optimize Insert query with minus oracle »
Wanted to optimize an important statement that is taking longer to finish. Basically the process will: 1) insert data on NG_ORGANIZATION_CATEGORY_GT...
(3) odpowiedzi
2017-05-26 23:05 Oracle - How can I use NLSParams to force change language using TO_CHAR function? »
I'm coding a PL/SQL function to display in words a number inserted from parameter between 0 and 5000 but the result displayed is displayed in English ...
(1) odpowiedzi
2017-05-26 23:05 How do I select from a non-aliased inline function column header in SQL? »
I'm writing a Java program that grabs a (SQL Query) String from an Oracle database, executes that string against the same database, and then executes ...
(2) odpowiedzi
2017-05-26 14:05 java.sql.SQLException: ORA-00942: table or view does not exist with JPA entityManager.createQuery() »
I am using JPA createquery API to fetch the data. Here is my query data @PersistenceContext EntityManager entityManager; @Override ...
(1) odpowiedzi
2017-05-25 10:05 Oracle, How can I get tables where COMMENTS is not null and has specific column »
I want to get tables which have column 'CUST_ID' and their comments is not null. To get tables with column_name 'CUST_ID' SELECT TABLE_NAME FROM US...
(1) odpowiedzi
2017-05-25 10:05 Defering drop table after exchange partition »
I have two tables: ld_tbl - a partitioned table. tgt_tabl - a non partitioned table. In my program I'm executing alter table ld_tbl exchange parti...
(1) odpowiedzi
2017-05-25 04:05 SQL: Find max number of rows »
I am totally new to coding so might be my question is silly sorry about it first. I have a database that has CUST_REFERRED represent CUST_NUMBER who ...
(5) odpowiedzi
2017-05-24 17:05 Why can I use a column from a different table in a subquery? »
In this example, I feel like I shouldn't be able to make this mistake: create table A (A_ID int); create table B (B_ID int, OTHER_ID int); insert in...
(4) odpowiedzi