Data dodania Pytanie
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
2017-05-24 16:05 Passing large BLOBs to Stored Procedure »
I have a simple (example) script to upload a file into the database (Oracle, if it matters): <cfscript> param string filename; if ( FileExists...
(2) odpowiedzi
2017-05-24 16:05 Why does this Oracle regexp_like test FALSE? »
Why does this Oracle regexp_like expression test FALSE? I'm running this PLSQL on Oracle 11g. v_string is a 0 and two spaces. It tests TRUE at REGEX1...
(1) odpowiedzi
2017-05-24 01:05 PL/SQL - Delete current record in FOR IN LOOP »
I am trying to figure out how to delete a record using the FOR .. IN .. LOOP FOR REC IN (SELECT * FROM WORKLIST) LOOP GET_DATA(REC); --DELETE REC...
(2) odpowiedzi
2017-05-23 18:05 How to create a dummy columns in SSIS 2008 »
I have a Flat file (.csv) ID, Name 1, ABC 2, CDE 3, DEF I want to the Insert these columns into the target Oracle Table with the sysdate to be inse...
(2) odpowiedzi
2017-05-23 16:05 Is there a way to write 'good' queries against the SQL-CSV-Antipattern? »
TL;DR at the bottom. I have inherited a rather poorly-designed table which holds a log of requests against a third-party webservice. This table conta...
(1) odpowiedzi
2017-05-23 15:05 Oracle - Group By with "steps" »
I have to following table: |MY_VALUES| |---------| | 1 | 1' iteration | 3 | 1' iteration | 2' iteration | 2 | 1' iteration | 2'...
(3) odpowiedzi
2017-05-22 20:05 Minimum transfer Sql query »
I have two Tables and I need to fulfill table 2 Need_qty with minimum movement from table 1 sending_qty. Table 1 sending_QTY STORE_ID_A 30 ...
(1) odpowiedzi
2017-05-22 14:05 Getting nextval from a backing sequence of an identity column »
I have a table column declared like this: file_id number(10) generated always as identity primary key, Is it possible to programatically get a curr...
(1) odpowiedzi
2017-05-22 10:05 Check constraint for column in SQL Developer »
I need to create a table, where the values of column "ttime" can be within the range of 10:00 and 22:00. Here' the code: create table test ( tt...
(1) odpowiedzi
2017-05-21 18:05 PL/SQL ORACLE triggers »
I'm trying to create a trigger that when you insert an employee in the company, assign a commission of 0.10 if it is from department 80. This is what ...
(1) odpowiedzi
2017-05-21 18:05 Oracle 12.1 strange plan when using string literal against VARCHAR2 column (NLS_COMP=BINARY_AI) »
I'm having a very specific issue with Oracle 12.1 concerning the handling of string literal ending with space in SQL WHERE clause applied on a VARCHAR...
(1) odpowiedzi
2017-05-21 12:05 Trying to create a trigger based on day and time »
I'm trying to create a trigger which would prevent insertions, updates and deletions if done outside office hours(i.e, other than 8-18 hours or sunday...
(1) odpowiedzi
2017-05-20 22:05 Using Subqueries to get a percentage from a number of SQL columns »
I have an oracle database ischema with a 'Goals' table, the table has 5 columns: G_ID - Int M_ID - Int G_Method - Text G_X_Loc - Int G_Y_L...
(2) odpowiedzi
2017-05-20 16:05 How can I configure email alert to check if an Essbase Application is running or not? »
I want to develop a script which will check the state (running or not) of an Essbase application (say, every 15 mins.). If the Essbase application is...
(1) odpowiedzi
2017-05-20 06:05 How to choose Oracle JDBC pool vendor »
The JDBC driver Oracle released has included the data-source and connectivity pool ability, e.g. PoolDataSource, OracleConnectionCacheManager and etc...
(0) odpowiedzi
2017-05-19 21:05 Oracle Weblogic OAM get user information using session cookies »
Oracle/WebLogic noob here. I'm not sure if I'm asking the right questions but any and all tips will be greatly appreciated. We are trying to deploy ...
(1) odpowiedzi
2017-05-19 20:05 Update column with sort number based on another column value »
Say I have a two column table. The first column 'value' is filled with random numbers. The second column 'sort' is empty. How can I update 'sort' w...
(1) odpowiedzi
2017-05-19 15:05 Creating indexes on columns where primary key or unique key constraints already present »
I am currently learning indexes in Oracle. In Oracle documentation, following can be found : Although the database creates an index for you on a ...
(2) odpowiedzi
2017-05-18 18:05 ORA-00905: missing keyword Hibernate Query Oracle »
I have n columns in a table. I want to have selection criteria as if a value in column2 is null then select row based on column 1 and if column2 is no...
(1) odpowiedzi
2017-05-18 09:05 User defined type dropped while in use »
I have an Oracle database with a table as follows: create table Table1 (Column1 number(5,0), Column2 special_type); Now, due to some data errors, ...
(2) odpowiedzi
2017-05-18 07:05 sequence number not allowed here in same session »
How can i get current rule id in a same session because select ID from rules where ID=rules_seq.currval is throwing error : ORA-02287: sequenc...
(4) odpowiedzi
2017-05-17 15:05 Retreive a list of private procedures/functions from a package body »
I want to obtain a list with all private procedures/functions from a package body. For public object it is easy but I have no idea how to do that for...
(1) odpowiedzi
2017-05-17 10:05 Compound index for columns with OR operator »
I have two tables with two matching columns (c1,c2); TABLE_A TABLE_B ======= ======= id id c1 c1 c2 c2 double col_y...
(2) odpowiedzi