Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Oracle


How to add and print in sql  

Hihere is my code it prints data for 1 perticular date.instead of it printing 13313113030011105for whole dayI want it to add and print the total please help Continue Reading
Views : 32
Sunday 30th of December 2012

Data type problem  

In my oracle database i have a view:SELECT REGEXP_SUBSTR(LV.VAN_ID, '[^ ]+', 1, 1) VanNumber, REGEXP_SUBSTR(LV.VAN_ID, '[^ ]+', 1, 2) DayName, REGEXP_SUBSTR(LV.VAN_ID, '[^ ]+', 1, 3) ShiftName, REGEXP_SUBSTR(LV.VAN_ID, '[^ ]+', 1, 4)... Continue Reading
Views : 150
Sunday 30th of December 2012

Having a problem with HAVING  

The "HAVING" statement from the query below removes all rows where the "name" field starts with "Port" and it removes all rows where count is less than 11. What I want is to removes all rows where the "name" field starts with "Port" and the count for that row is less than 11. Continue Reading
Views : 110
Sunday 30th of December 2012

Oracle Installation Questions  

As I finalize my Oracle 11g R2 (11.2.0.3) database installation on RHEL 6.3 Linux, I have some questions I wasn't able to find in the documentation:1. The documentation advise you to configure the 'oracle' users home environment variables but I'm not 100% on exactly what MUST be... Continue Reading
Views : 28
Sunday 30th of December 2012

Create record above  

Hello, good day .. I'm new to the forum need some help, how do I insert a new record in a DataBlock, and the standard is always insert a line below, you could add a record above? Continue Reading
Views : 69
Sunday 30th of December 2012

Configure SQL*Plus  

One of my biggest struggles learning / cutting my teeth on Oracle 11g has been how SQL*Plus is configured on a standard / default installation. Mainly I'm trying to understand how I can have it work more or less like 'psql' utility that ships with PostgreSQL. Obviously most Oracle dudes... Continue Reading
Views : 22
Sunday 30th of December 2012

How to name a column from data stored in certain row  

Hello, thank you for reading this and trying to help me, I am trying to name a column from data stored in a row (Phone number) I want to name it from the first 3 digits (Area code) and I have no clue how to do it I have googled but I think the query is a little too complicated for me to... Continue Reading
Views : 40
Sunday 30th of December 2012

Oracle 10g refusing connection for clients  

hello,I have installed oracle 10g server(linux version) in centos and have made all the settings. But when i start the server and try to access from client system.. it gives the following message - "Connection refused from server". I m not getting what went wrong".Please... Continue Reading
Views : 51
Sunday 30th of December 2012

JDBC Oracle date format  

Hi, guys. I have a simple question, hope it has a simple answer. I changed the default date format for a SCHEMA using a TRIGGER and AFTER LOGON, so it set the NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'. It does work fine, however, the problem is when I connect using a client with JDBC... Continue Reading
Views : 64
Sunday 30th of December 2012

Oracle problem with using Both OrderBy & ROwNum  

Hello EveryBody!I tried to make my Query as simple as possible but also it contains the problem: Code: Continue Reading
Views : 68
Sunday 30th of December 2012

PL/SQL video tutorials  

Does anybody know of a good PL/SQL online video tutorial? I've done PL/SQL at school, but my work experience is limited. I found through experience - learning .NET and Python - using online videos to be a very helpful way....Any help is much... Continue Reading
Views : 35
Saturday 29th of December 2012

Simple question  

Hi guyz,I have a simple question, the question is that what ever i am doing or making in sql*plus (creating triggers, functions, settings, changing the nls_lang and etc) they are working in sql*plus but as i want them to work from the oracle form i am developing, they are not... Continue Reading
Views : 78
Saturday 29th of December 2012

Join using first match  

Hi Friends,Please help Me with this requirement as I am new to sql..I need to join 2 tables based on first match.. I cldnot use distinct on the result, as distinct work with entire row..I cant use group by as well, since for group by hv to select all the columns... Continue Reading
Views : 85
Saturday 29th of December 2012

Oracle SQL laboration help (school coure) Subquery and Join  

Hi,I have a introductory course in database systems (Oracle SQL) at my university and now when we have moved on to nested querys and joins I would very much appreciate some pointers form anyone who have spare time.In this lab I am supposed to display customer number,... Continue Reading
Views : 52
Saturday 29th of December 2012

Append columns from one table to another  

Hey all,Perhaps this is a common request : I have 2 tables:Table A-------ID Value1 a2 b3 cTable B-------ID AnotherValue1 x 2 yI am hoping to append a column from... Continue Reading
Views : 125
Saturday 29th of December 2012

Select fields longer than length x  

I'm trying to select only codes from a column that are above a certain length. how would this be achieved? I've tried char_length(fieldname) > x in the where clause but i'm getting the error ORA-00904: "char_length" invalid identifier. Thanks in advance. Continue Reading
Views : 208
Saturday 29th of December 2012

SQL Server query to be convert it to Oracle 10g  

DECLARE @MainTable TABLE (UniqueID INTEGER, Category VARCHAR(200), WeekDate DATETIME, VALUE INTEGER)INSERT INTO @MainTable VALUES(123, 'Shirts', '10/07/2011', 5000)INSERT INTO @MainTable VALUES(123, 'Shirts', '10/14/2011', 8000)INSERT INTO @MainTable... Continue Reading
Views : 80
Saturday 29th of December 2012

Update Error  

Hello,I am trying to update a column based on another column in the same table (student table) and a columnfrom another table (school table)Code is:update student_tableset student_code =(select l.student_codefrom school_table l,... Continue Reading
Views : 130
Saturday 29th of December 2012

Help Backup Oracle Database Using RMAN Utility  

Quote: Originally Posted by CarlosinFL Continue Reading
Views : 48
Saturday 29th of December 2012

Delete record in an update trigger  

English is not my native language, so pardon me for my bad english. Neither am i an expert on Oracle databases, the following case is succesfully done with mssql databases.Case:Table UserGroupColumns id, name, handshakeWhen the handshake is set to 'd',... Continue Reading
Views : 58
Saturday 29th of December 2012

User Defined Data Type  

I am trying to create & use a new data type but keep getting a ora-0902 invalid data type error running on 10g express.The create type and select statements execute fine and select confirms the ssn_t is a type.The create table statement fails with the invalid data... Continue Reading
Views : 60
Saturday 29th of December 2012

Modify one table to trigger other tables  

Hi!We are running an Oracle 10g server.We are adding support for barcode scanner in one part of our information system. So that the mechanics can add parts to an work orders bill of material themselves using barcode scanner to scan the part and enter the qty. Continue Reading
Views : 46
Saturday 29th of December 2012

Noob Inserting table data into a variable  

I am trying to insert a column into a variable from a trigger.Here is the code that i have: Code: Continue Reading
Views : 68
Saturday 29th of December 2012

How To Change Default XML Storage  

Hello,As per the bellow the default XML storage has been changed in 11gr2.docs.oracle.com/cd/E11882_01/appdev.112/e10492/whatsnew.htmQuote:Oracle Database 11g Release 2 (11.2.0.2) New Features in Oracle XML DBThe following... Continue Reading
Views : 60
Saturday 29th of December 2012

Problem in recreating enterprise manager repository  

Hello everyone,I'm trying to recreate the repository using the following command:c:\windows\system32>emca -config dbcontrol db -repos recreateBut i receive the following error: Continue Reading
Views : 45
Saturday 29th of December 2012

Dynamic pivoting  

Hello, I am hoping to get some help on a view which needs to be pivoted, I am not sure though. View is in following format:Case CASE_ORDER MANAGER CURRENT_MONTH_CASES FISCAL_YEAR_CASES Continue Reading
Views : 198
Saturday 29th of December 2012

HELP PLEASE ! Oracle Application Express - EXPORTING WHOLE WORKSPACE/APPLICATION  

I need to export my whole workspace/application from Oracle Application Express so if i was to move onto a new pc and install oracle again. I can import this file and... Continue Reading
Views : 43
Saturday 29th of December 2012

Handling NULL value in XML using getStringVal  

Hi,I have below query which works fine if column 'XML_COL' has values. This select statement fails if the value is NULL for select xmltype(t.xml_col).extract('//fax/text()').getStringVal() from mytab tHow to handle rows with NULL values in the column... Continue Reading
Views : 383
Saturday 29th of December 2012

Query help regarding cursors  

Hi friends i have a Customer_Scoring table with following fieldsKEY,MAX_value,Points,Profile_IDDistance,1(here 1 means distance Continue Reading
Views : 51
Saturday 29th of December 2012

Inefficient VIEW  

I have a view that gets used 3 times by another query and am being told that the view is inefficient.Any reccomendations on how I could change this?I noticed this view is getting the value of acad_prog three times.Once from ps_acad_prog when finding the... Continue Reading
Views : 70
Saturday 29th of December 2012