Oracle Help
in [SQL]
|
How to determine the Oracle session's constraint state? Hello! First time poster in this forum -- please forgive me if this is the wrong place for my question. I've exhausted a web search on this issue, and was hoping that this might be a more targeted approach. I am trying to programmatically determine the current session's constraint state (immediate, deferre... 9 Feb 2010 20:48
Collections Hi, Can you call a procedure from SQLPLUS that takes a collection as input? INSERT_PORTFOLIO_ARR ( p_customer_id NUMBER, p_price IN_ARR, p_shares IN_ARR, p_date IN_ARR, p_product VARCHAR2 DEFAULT NULL) IN_ARR is defined as: CREATE OR REPLACE TYPE "IN_ARR" ... 3 Feb 2010 18:31
dbstart with wrong shell / wrong systax hi all After installing Oracle database 11.2 on Solaris 10 x86 the dbstart script doesn't work because of the interpreter is set to /bin/sh but the script uses syntax of ksh/bash . dbstart: line 1:#!/bin/sh .... line 89:export ORACLE_HOME=$ORACLE_HOME_LISTNER This export statement is illegal for bourne... 3 Feb 2010 03:57
Immediate Openning Hi, We have an immediate requirement for different Location in india Interested candidtes can send in their profiles to mamta(a)jobworldindia.com /9945991215 with mandatory information Current CTC Expected CTC Notice Period Current Organisation. Current Role Current Location Preferred Location ... 2 Feb 2010 14:38
Query optimization Hi all, this is my first foray into optimization and I'm at a relatively beginner level. The situation that I have is an exceedingly simple one. I have a table with a list of phone numbers, table A. I have another table with a list of ranges of phone numbers, table B. If the number in A lies between the st... 2 Feb 2010 14:38
Aggregation, sort of Hi all, (How I wish there was a comp.lang.sql for generic sql questions!). I have a table structured thus: Emp_org, emp_dept, emp_sub_dept, emp_language, emp_location. (This is not my table but an attempt at a simplified example). So there could be 20 employees with the same emp_org, emp_dept and emp_sub_de... 27 Jan 2010 11:27
Last not null value from previous rows I vaguely remember this has been asked and answered before, but can not find the answer anymore: Suppose I have a table in which a column has a value for some rows, and none (null) for others. Is there a way to let a select statement (which returns values from the current row) return the last non null value for ... 26 Jan 2010 16:38
string concatenation via Group By Is it possible to concatenate records in a field via Group By clause of an SQL statement? Untested script is : create table t1(country varchar2(32), state varchar2(32), city varchar2 (32)) ; insert into t1 values ('USA', 'CA', 'Sacramento') ; insert into t1 values ('USA', 'CA', 'San Jose') ; insert into t1 v... 26 Jan 2010 15:29
SQL-- Please help me :) table 1 ref code 1 code_1 1 code_2 2 code_3 2 code_5 ........ ........ table 2 code code_description value code_1 description1 3.4 code_2 description2 3.5 code_3 description3 0 code_4 description4 0 code_5 description5 ... 26 Jan 2010 12:02
Mixet.se® - International Business Advertising MIXET CLASSIFIEDS ARE STILL FOR FREE...! Google Translate: http://mixet.se http://translate.google.com/#sv|en|http%3A%2F%2Fmixet.se Mixet Japan http://translate.google.com/translate?hl=sv&sl=sv&tl=ja&u=http%3A%2F%2Fmixet.se%2F Mixet USA/United Kingdom http://translate.google.com/tr... 23 Jan 2010 16:32 |