Search Results

Search found 44975 results on 1799 pages for 'oracle advanced planning command center'.

Page 630/1799 | < Previous Page | 626 627 628 629 630 631 632 633 634 635 636 637  | Next Page >

• Troubleshooting PG Function

  - by Grasper

  I have this function: CREATE OR REPLACE FUNCTION CREATE_AIRSPACE_AVAILABILITY_RECORD (cur_user VARCHAR, start_time VARCHAR, start_date VARCHAR, end_time VARCHAR, end_date VARCHAR, airspace_name VARCHAR) RETURNS VOID AS ' DECLARE c_user ALIAS for $1; BEGIN IF start_time IS NULL OR start_date IS NULL OR end_time IS NULL OR …

  Read the article

• How do i create a table dynamically with dynamic datatype from a PL/SQL procedure

  - by Swapna

  CREATE OR REPLACE PROCEDURE p_create_dynamic_table IS v_qry_str VARCHAR2 (100); v_data_type VARCHAR2 (30); BEGIN SELECT data_type || '(' || data_length || ')' INTO v_data_type FROM all_tab_columns WHERE table_name = 'TEST1' AND column_name = 'ZIP'; FOR sql_stmt IN (SELECT * FROM test1 WHERE zip IS NOT NULL) LOOP IF v_qry_str IS NOT NULL THEN …

  Read the article

• I can't make this query work with SUM function

  - by Mehper C. Palavuzlar

  This query gives an error: select ep, case when ob is null and b2b_ob is null then 'a' when ob is not null or b2b_ob is not null then 'b' else null end as type, sum(b2b_d + b2b_t - b2b_i) as sales from table where ... group by ep, type Error: ORA-00904: "TYPE": invalid identifier When I run it with group by ep, the error…

  Read the article

• One check constraint or multiple check constraints?

  - by RenderIn

  Any suggestions on whether fewer check constraints are better, or more? How should they be grouped if at all? Suppose I have 3 columns which are VARCHAR2(1 BYTE), each of which is a 'T'/'F' flag. I want to add a check constraint to each column specifying that only characters IN ('T', 'F') are allowed. Should I have 3 separate check…

  Read the article

• Got a minus one from a read call.

  - by sunyata

  I connect to a database with read only access using SQL developer. It's a TNS connection. I use a tnsnames.ora, forwarding port script and SQL Developer. In the past, occasionally, when connecting, I get a error message Got a minus one from a read call. Vendor Code 0 If I do a reboot, it goes away. Another friend suggested changed…

  Read the article

• Add comma-separated value of grouped rows to existing query

  - by Peter Lang

  I've got a view for reports, that looks something like this: SELECT a.id, a.value1, a.value2, b.value1, /* (+50 more such columns)*/ FROM a JOIN b ON (b.id = a.b_id) JOIN c ON (c.id = b.c_id) LEFT JOIN d ON (d.id = b.d_id) LEFT JOIN e ON (e.id = d.e_id) /* (+10 more inner/left joins) */ It joins quite a few tables and…

  Read the article

• Is there a Java (Sun/Oracle) equivalent of the Microsoft MVP Program?

  - by JohnAOwens

  We already run a NFR (not for resale) program where we give Microsoft MVP's a reduced cost licence of our software. We would like to extend this to the Java community, but I'm having trouble finding the equivalent program in the Sun/Oracle world. Is there such a thing?

  Read the article

• Can a sub-procedure procedure lock and modify the same rows FOR UPDATE that its calling procedure al

  - by RenderIn

  Will the following code lead to a deadlock or should it work without any problem? I've got something similar and it's working but I didn't think it would. I thought the parent procedure's lock would have resulted in a deadlock for the child procedure but it doesn't seem to be. If it works, why? My guess is that the nested…

  Read the article

• index for ' where wakeup_time < sysdate'

  - by Hlex

  Hi For most of records this field is null. Only some record I need to wake it up. table are very big , I want to know which record want to wakeup. I don't want database to seek every row. Could you example me your Idea?

  Read the article

• Analyzing data from same tables in diferent db instances.

  - by Oscar Reyes

  Short version: How can I map two columns from table A and B if they both have a common identifier which in turn may have two values in column C Lets say: A --- 1 , 2 B --- ? , 3 C ----- 45, 2 45, 3 Using table C I know that id 2 and 3 belong to the same item ( 45 ) and thus "?" in table B should be 1. What query…

  Read the article

• How do I select the max value from multiple tables in one column

  - by Derick

  I would like to get the last date of records modified. Here is a sample simple SELECT: SELECT t01.name, t01.last_upd date1, t02.last_upd date2, t03.last_upd date3, 'maxof123' maxdate FROM s_org_ext t01, s_org_ext_x t02, s_addr_org t03 WHERE t02.par_row_id(+)= t01.row_id and t03.row_id(+)=…

  Read the article

• SqlPlus on mac osx 10.6 doesn't work

  - by lesce

  When i try to run this #sqlplus system@orcl it gives me this error SQL*Plus: Release 10.1.0.3.0 - Production on Tue Apr 20 02:24:41 2010 Copyright (c) 1982, 2004, Oracle. All rights reserved. Enter password: ERROR: ORA-12154: TNS:could not resolve the connect identifier specified the oracle server is…

  Read the article

• SOFT delete is this a good idea or a bad idea?

  - by Khou

  Is soft delete a good idea or a bad idea? Instead of actually deleting the data, you would flag it as "IsDeleted" = true, upon recovery you just flag it as "False". Is this a good idea?

  Read the article

• Attaching a List of Value [LOV] to an existing page item in APEX

  - by Sathya

  I'm pretty new to APEX ( well, just started using it ~an hour ago), and I'm stuck at a pretty basic level. I've created a simple form with all the required fields. I've created a simple LOV. I can't seem to figure out how to Attach the LOV to the existing item. I tried to attach the LOV by heading over to…

  Read the article

• update query on multiple tables

  - by jon

  I have a schema like : employees (eno, ename, zip, hdate) customers (cno, cnmae, street, zip, phone) zipcodes (zip, city) where zip is pk in zipcodes and fk in other tables. I have to write an update query which updates all the occurence of zipcode 4994 to 1234 throughout the database. update…

  Read the article

• How to bulk insert data from ref cursor to a temporary table in PL/SQL

  - by Sambath

  Could anyone tell me how to bulk insert data from a ref cursor to a temporary table in PL/SQL? I have a procedure that one of its parameters stores a result set, this result set will be inserted to a temporary table in another stored procedure. This is my sample code. CREATE OR REPLACE PROCEDURE…

  Read the article

• Optimize the sql query

  - by joseph

  UPDATE employees SET job_id = (SELECT job_id FROM employees WHERE employee_id = 205), salary = (SELECT salary FROM employees WHERE employee_id = 205) WHERE employee_id = 114; This is the query i have been using. Here i use 2 subqueries but they have the same where condition.. The seek time is…

  Read the article

• sorting two tables (full join)

  - by Ruslan

  i'm joining tables like: select * from tableA a full join tableB b on a.id = b.id But the output should be: row without null fields row with null fields in tableB row with null fields in tableA Like: a.id a.name b.id b.name 5 Peter 5 Jones 2 Steven 2 Pareker 6 Paul …

  Read the article

• Does vsize give the correct result for number?

  - by sathish reddy

  When I create a table as Create Table e_det(eno Number, ename Varchar2(20), sal Number); I inserted eno as 111 ename as jone sal as 2000 vsize(ename) returns 4 because name is 4 characters. vsize(sal); returns 2. Can you explain this?

  Read the article

• .Net: What is your confident approach in "Catch" section of try-catch block, When developing CRUD op

  - by odiseh

  hi, I was wondering if there would be any confident approach for use in catch section of try-catch block when developing CRUD operations(specially when you use a Database as your data source) in .Net? well, what's your opinion about below lines? public int Insert(string name, Int32…

  Read the article

• Newbie database index question

  - by RenderIn

  I have a table with multiple indexes, several of which duplicate the same columns: Index 1 columns: X, B, C, D Index 2 columns: Y, B, C, D Index 3 columns: Z, B, C, D I'm not very knowledgeable on indexing in practice, so I'm wondering if somebody can explain why X, Y and Z were…

  Read the article

• No_data_found exception is propagating to outer block also?

  - by Vineet

  In my code i am entering the salary which is not available in employees table and then again inserting duplicate employee_id in primary key column of employee table in exception block where i am handling no data found exception but i do not why No data found exception in the end…

  Read the article

• Select result in single cell

  - by Ruslan

  How can i select all id's for records in single cell? For example: --example select of all values select id, name, address, phone from table And get all id's where phone like '%555%' and show them in single field like: '111 123 234 321 231 234'

  Read the article

• JBoss JDBC warning - "Unable to fill pool"

  - by Marcus

  We're getting this random warning from JBoss.. any idea why? It happens at random times when there are no active threads. Everything works when any processing resumes. 13:49:31,764 WARN [JBossManagedConnectionPool] [ ] Unable to fill pool…

  Read the article

• Knowing the selections made on a 'multichooser' box in a mechanical turk hit (using Command Line Too

  - by gveda

  Hi All, I am new to Amazon Mechanical Turk, and wanted to create a hit with a qualification task. I am using the command line tools interface. One of the questions in my qualification task involves users selecting a number of options. I use a…

  Read the article

< Previous Page | 626 627 628 629 630 631 632 633 634 635 636 637  | Next Page >