Recent IT Questions

1 - 20 of 39
<<PREVIOUS 1|2 NEXT>>

Function to find greatest numeric value across different fields

In a row of data with multiple numeric fields, how can I easily find the greatest value using simple function like GREATEST(Attribute1, Attribute2) as for Oracle SQL?

View Answer   |  Aug 25 2009  2:52 AM GMT
WINSQL Numeric Function, WinSQL, Oracle SQL
asked by Kevling

  5 pts.

following error when logging into SQLPlus

When i try to log into Oracle SQL*Plus i get the following error ORA-01034: Oracle not available ORA-27101: shared memory realm does not exist I'm using Oracle 9i Personal Edition Software/Hardware used: P4 2.5ghz and windows 2003 server

View Answer   |  Aug 21 2009  6:41 AM GMT
SQL Plus, Oracle SQL, ORA-01034
asked by Oracle999

  5 pts.

SR in oracle(tickets)

Can u please give me a list pf SR's u have solved ?

Answer Question   |  Aug 18 2009  6:22 AM GMT
PL/SQL, Oracle SR, Oracle Service Request
asked by Johnview

  5 pts.

Equivolent HLOOKUP using SQL

I am a beginner at SQL... I've come across a situation maybe someone can help me out. I have a table with the following structure: bkt_id am bkt_101 bkt_102 bkt_103 ... bkt_228 bkt_101 $100 $100 $20 $0 bkt_102 $50 $100 $20 $0 ... I want to compare am with the proper bkt_n...

Answer Question   |  Jul 24 2009  1:31 AM GMT
Oracle, SQL, Oracle SQL
asked by Pg38528

  5 pts.

Conecting Oracle through dynamic IP

I want to connect 2pcs's having oracle 9i (sever version) installed in them ,through a broadband connection(ie. a dynamic IP). Can any one show me the way.

View Answer   |  Apr 28 2009  4:39 PM GMT
Oracle SQL, Dynamic IP address
asked by Meettan

  5 pts.

How To execute procedure

I have procedure iven below Output of the procedure below is multiple rows but i am getting only 1st row how to use concept of SYS_REFCURSOR over here CREATE OR REPLACE procedure Vishal_PROC_sp1 (kpiid in number, val1 out varchar2, val2 OUT Number) as cursor c1 is select...

View Answer   |  Apr 15 2009  7:25 PM GMT
Oracle SQL, Oracle stored procedures, SYS_REFCURSOR
asked by Hanrahul

  85 pts.

Oracle SQL question

I want to create a SQL script in Oracle that will run one of two possible SQL scripts based on what the user enters in the Parameter request. Since I'm unable to use IIF and If Then like I can in SQL Server, is there another way to do this? I have tried using case statements but Oracle doesn't...

View Answer   |  Apr 13 2009  2:39 AM GMT
Oracle developers, Oracle SQL, Oracle development
asked by Wanderer9577

  5 pts.

HOW TO SAVE DATA FAST

I have a query that retrieves 7 lakh rows of data in say 3 minutes but when i go to save this data in comma sepatrated file using toad's save as feature .it takes almost 3 hrs to save the data. This query looks like: SELECT circle_name,cluster_name,rsnnumber ,mdnnumber,hs_rsnnumber ,otafdate, ...

View Answer   |  Apr 9 2009  12:46 AM GMT
Oracle Output Via SQL, Oracle SQL, Oracle Database
asked by VEERRELIANCE

  10 pts.

What is the difference between software package in SQL and PL/SQL

why is the need of psql when the sql is already avaliable.

View Answer   |  Mar 30 2009  7:43 AM GMT
PL/SQL, SQL, SQL development
asked by Krrishkundan

  5 pts.

iSQLPlus creating packages with multiple procedures in it

Hi, I am a bit stuck i need to create a package which has a number of different procedures in it. The procedures work on their own however whenever i try to put them into a package they then don't work and i get the error package created with complication errors, however when i type show errors...

View Answer   |  Mar 14 2009  5:24 PM GMT
iSQL*Plus, SQLPlus, Oracle SQL
asked by Cazza88

  55 pts.

Oracle Forms 6i Database Objects

I have problem that Forms 6i does not see packages stored on Database with Dynamic SQL code on it. When I open Forms Designer it does see Database Objects at the bottom but with running the forms it gives and error that does see sys. dba_sql. Thank you

View Answer   |  Mar 9 2009  9:31 AM GMT
Oracle Forms 6i, Oracle Designer, Dynamic SQL
asked by Oikhleif

  30 pts.

Finding the number of rows of all tables of a user/schema in Oracle

how can i know all the table names along with the no. of rows they contain for a user/scema in oracle 9i through sql? plz answer ......

View Answer   |  Feb 22 2009  7:16 PM GMT
Oracle 9i, Oracle SQL, SQL queries
asked by Chrishram

  15 pts.

SQL query and Oracle database design help needed

Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could put this as an item of the...

Answer Question   |  Feb 22 2009  6:22 AM GMT
SQL, Oracle SQL, SQL queries
asked by Rohit3312

  25 pts.

Inserting 50000 rows using FORALL statement

How can we insert 50000 rows by using FORALL,please give me entire code?

View Answer   |  Feb 18 2009  5:48 AM GMT
Oracle development, FORALL statement, PL/SQL
asked by Ramesh55

  30 pts.

Oracle SQL-Pagination Help

Hi, The below inner SELECT returns huge amount of rows (1000000+) and the outer SELECTs(alpha BETWEEN #startRec# AND #endRec#) is used for PAGINATION to display data with 25 in each page. Issue is:-This PAGINATION done below is very slow and slows the entire display of data.So could all please...

View Answer   |  Feb 16 2009  4:24 PM GMT
Oracle SQL, Oracle SQL Pagination, Pagination
asked by Rohit3312

  25 pts.

concatenating rows of a column in oracle 9i sql

how can i concatenate several rows of a column which is of datatype varchar taking group by of two other columns in oracle 9i sql??

View Answer   |  Feb 12 2009  10:17 PM GMT
Concatenate, Oracle SQL, Oracle 9i
asked by Chrishram

  15 pts.

Errors in Creating Oracle packages

Can anybody plz find out the error in the following code?? plz reply back. SQL> CREATE OR REPLACE package body PKG_IMAGEM1 2 as 3 PROCEDURE IMGINSERT1(P_Region IN VARCHAR2, 4 P_College IN VARCHAR2, 5 P_CourseCat in varchar2, 6 P_CourseName in...

View Answer   |  Feb 9 2009  1:04 PM GMT
Creating Oracle packages, Oracle Package, Oracle SQL
asked by Shreeshonkar

  10 pts.

ORA-03113: end-of-file on communication channel

I am running a database health report which consists of many SQLs against the data dictionary. Every SQL returns fine except one querying for chained/ migrated rows which takes a little more time, and I get the following: ERROR at line 1: ORA-03113: end-of-file on communication channel I am...

View Answer   |  Feb 3 2009  3:54 PM GMT
Oracle error messages, Oracle SQL, SQLPlus
asked by OracleATE

  190 pts.

How to write a test case in PL/SQL

Hi Experts, How to write a test case in PL/SQL to check whether the parameter of a procedure (eg email iddress) takes only lower case ,i did this way in my procedure If(emailadd) <> lower(emailadd)then raise_app_error_ But this can be checked n test case please guide me with pseudo code ...

asked by Inprise

  525 pts.

ALTER INDEX statement

'ALTER INDEX ' || C_Indices.INDEX_NAME ||' REBUILD '; 'ALTER INDEX ' || C_Indices.INDEX_NAME || ' REBUILD ONLINE COMPUTE STATISTICS'; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code ,...

View Answer   |  Dec 16 2008  12:54 AM GMT
Oracle development, Oracle SQL, Oracle stored procedures
asked by Shaksing

  5 pts.

1 - 20 of 39
<<PREVIOUS 1|2 NEXT>>