Data dodania Pytanie
2017-08-05 05:08 simple random sampling while pulling data from warehouse(oracle engine) using proc sql in sas »
I need to pull humongous amount of data, say 600-700 variables from different tables in a data warehouse...now the dataset in its raw form will easily...
(2) odpowiedzi
2017-08-04 22:08 PL/SQL transactions when invoking procedures »
I have 2 tables in a master-detail composition, User and Employee (this is because Employee is a type of user and there are other types of users). Whe...
(2) odpowiedzi
2017-08-04 18:08 convert number from scientific notation in R »
I have a numeric variable imported from Oracle with 17 numbers, for example: 20172334534654667. Now I imported it from Oracle using dbGetQuery() in R...
(1) odpowiedzi
2017-08-04 17:08 Oracle With, Case When statement missing keyword »
Hi I am trying to create a view in Oracle SQL Developer. I would like the view to be everything from raw_test with a new column As 'Exclusion Reason'...
(2) odpowiedzi
2017-08-03 20:08 Checking if a Birthday was between a 6 month span which crosses the year break »
I am trying to write SQL code (using SQL Developer) that checks if a person had a birthday within the past 6 month insurance term. This is what my c...
(4) odpowiedzi
2017-08-03 10:08 how to sum up minutes and seconds ?in oracle »
I have a column called duration_d which is varchar2 and the data in that table looks like below duration_d ----------- 12:25 01:35 12:10 04:21 12:18 ...
(4) odpowiedzi
2017-08-03 09:08 Oracle SQL NTILE - equal distribution »
This query: SELECT min( "x" ) as "From", max( "x" ) as "To", sum("quantity") FROM ( SELECT t.*, ntile( 4 ) over (order by "x" ) ...
(1) odpowiedzi
2017-08-02 21:08 Oracle SQL - distributing into buckets »
i'am searching for a smart oracle sql solution to distribute data into a number of buckets. The order of x is important. I know there are a lot of al...
(1) odpowiedzi
2017-08-02 11:08 Using JAVA to save data to Oracle table with TIMESTAMP WITH ZONED TIME column »
I am trying to find a Java Time Type that can be persisted to a column of type TIMESTAMP WITH TIME ZONE in the Oracle DB. The Java type needs to have ...
(0) odpowiedzi
2017-08-02 10:08 Which schema does the store procedure run? the owner's schema or caller's schema? »
I found the question. user B has a store procedure "B.pk.sp", and user A can reads the "B.pk.sp" and executes it. The procedure "B.pk.sp" manipulate...
(1) odpowiedzi
2017-08-01 22:08 How to handle/use special charaters like percent (%) and ampersand (&) in Oracle SQL queries »
I need to include the special character "%" in my LIKE clause in a SQL query, e.g.: Select * From Some_Table Where Field_Name Like 'bla%bla&2'; ...
(5) odpowiedzi
2017-08-01 18:08 Apply 'numerical' sort to odd data structure with multiple decimal points / periods »
I've got an ASP.NET application that's pulling data from an Oracle table into a GridView. I have absolutely no control over the Oracle data, it is wh...
(1) odpowiedzi
2017-08-01 14:08 How to make System partition in Oracle 11g? »
I am very new to database .I would like to do system partition for a existing large database table in oracle. Can someone suggest How i can achieve ...
(1) odpowiedzi
2017-07-31 13:07 Generate WORKFLOW in plSQL »
i try to generate a workflow with recusive functions in plSQL but i don't get what i want. i got this table TABLETEST : GROUPE STATUS STATUSNEW A...
(0) odpowiedzi
2017-07-31 11:07 Execute dynamic DDL in PL/SQL procedure through definer role permissions »
I want to perform some dynamic DDL in a procedure owned by an admin user. I'd like to execute this procedure with a technical operational user with de...
(1) odpowiedzi
2017-07-31 06:07 Oracle UPDATE as a inner query inside a where clause »
I want to insert some values to a table based on the number of updates made by the same query. An example queries I tried is as follows. SELECT col...
(2) odpowiedzi
2017-07-30 23:07 How to handle this type of Oracle SQL issue »
Just have a question for writing SQL. In ORACLE DB, I have rows of different apples in one "APPLE" TABLE, where the "TAGS" holds all the features of t...
(5) odpowiedzi
2017-07-30 21:07 How using PL/SQL Locally Defined Types with TABLE Operator »
I am developing a trigger that keeps a table updated where the departments are recorded and the total sum of their salaries. Each time the EMP table i...
(2) odpowiedzi
2017-07-30 14:07 'where' in with duplicates or 'select distinct' - performance »
I would like to return some results basing on subquery results and I was wondering what would be faster - having subquery results be distinct or wher...
(1) odpowiedzi
2017-07-29 16:07 ORACLE SQL Query - test a list of keys for NOT EXISTS? »
Let's say I have a table with columns K1, K2, V, where (K1,K2) is a composite primary key. I have a list of K1 values 'possiblyNew'. I would like to f...
(2) odpowiedzi
2017-07-29 09:07 How to get lastest active record »
Here is my data. Member can be enroll multiple times and can change plan anytime,I need to get C_level data for latest near to getdate that is "8/1/20...
(1) odpowiedzi
2017-07-29 01:07 Oracle APEX: Searching for a substring »
I'm struggling with a SQL Query: I have some text like this: *any text can appear here* input type="hidden" name="f01" value="1524" And what I ne...
(1) odpowiedzi
2017-07-28 23:07 Using JAVA to store date/time info in the DB? »
What is the best way/approach to store date/time info (and timestamps in general) so the information that can be displayed in different timezones? My...
(1) odpowiedzi
2017-07-28 20:07 SQL: How to check a value in column is equal to the sum of any combination of the other columns in a row »
I came across a scenario where I have a table structure as such: Column0 Column1 Column2 Column3 Column4 Column5 100 U V X Y ...
(3) odpowiedzi
2017-07-28 14:07 how to add a foreignkey to a composite primary key »
I have 2 tables: T_CAMPAGNE_SMS_REPARTITION and T_CAMPAGNE_SMS_EXECUTION. In T_CAMPAGNE_SMS_REPARTITION there are 2 primary keys. In T_CAMPAGNE_SM...
(3) odpowiedzi
2017-07-27 23:07 cx_Oracle: Using PL/SQL RECORD types as arguments to stored procedures »
I'm attempting to call AP_VENDOR_PUB_PKG.CREATE_VENDOR from cx_Oracle (This is an Oracle R12 stored procedure) It requires an argument that is a prede...
(1) odpowiedzi
2017-07-27 14:07 FTPClient move files from Linux to windows. Know when they end generating »
I create an service that moves files from Linux Computer to Windows by FTPClient. The files in LinuxComputer are generate by an Oracle Store Procedure...
(1) odpowiedzi
2017-07-27 14:07 utPLSQL Installation - ORA-04047 error when exec ut.run(); »
I am setting up utPL/SQL for my Oracle database, and everything seemed to installed correctly, but when I try to run the basic test runner, it gets an...
(1) odpowiedzi
2017-07-26 18:07 How to find rows where the same column has only the same another column »
Suppose following table: Name Age Occupation Alex 20 Student Alex 20 Seller Alex 20 Minister Liza 19 Student Liza 20 Volunteer Liza 21 HR partn...
(3) odpowiedzi
2017-07-26 14:07 Oracle custom order based on previous id field »
I have a table with a previous id and want to sort the output based on id_prev. Null must be the first value. example image Table id | id_prev | da...
(3) odpowiedzi
2017-07-26 10:07 Find broken sequence with match_recognize using Oracle 12C »
I want to detect gaps in my CDR_ID sequence for each numbers, for that I am using the match_recognize analytic function. Code: SQL> select distinct...
(1) odpowiedzi
2017-07-26 08:07 How to restore one record/row in table when testing? »
I am conducting Junit test on an AM. The thing is that, in some cases there are changes to the values of the attributes in one row, sometimes even ha...
(1) odpowiedzi
2017-07-25 13:07 Create parent node in XMLSCHEMA »
Have objects: create or replace type test.type_numberlist as table of number; / create or replace type test.type_test as object ( LIST test.typ...
(0) odpowiedzi
2017-07-25 10:07 Optimizing SQL by using temporary table in Oracle »
I have a data cleanup-er procedure which deletes the same data from the card rows of two tables. Both of these update statement use the same subQuery ...
(1) odpowiedzi
2017-07-25 04:07 Explain syntax of Oracle SQL where ('a','b') in (('x', 'y')) »
In Oracle SQL this syntax is not accepted, returns ORA-00920: invalid relational operator select name from employees where (emp_id, dept...
(1) odpowiedzi