• Retrieve data from Oracle9i to SQL server

    Currently my database client using SQL Server 2005 and there have another database whereby is using Oracle 9i, I wanted to retrieve the data from the oracle whereby query in SQL server 2005. 

    Xue8715 pointsBadges:
  • 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 help...

    Rohit331225 pointsBadges:
  • 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?

    Kevling5 pointsBadges:
  • 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

    Oracle9995 pointsBadges:
  • SR in oracle(tickets)

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

    Johnview5 pointsBadges:
  • 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 value using the bkt_id...

    Pg385285 pointsBadges:
  • 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...

    Hanrahul85 pointsBadges:
  • 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.

    Meettan5 pointsBadges:
  • 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 like...

    Wanderer95775 pointsBadges:
  • 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, (case...

    VEERRELIANCE10 pointsBadges:
  • What is the difference between software package in SQL and PL/SQL

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

    Krrishkundan5 pointsBadges:
  • 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

    Oikhleif30 pointsBadges:
  • 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 ......

    Chrishram15 pointsBadges:
  • 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...

    Rohit331225 pointsBadges:
  • 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??

    Chrishram15 pointsBadges:
  • 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 running...

    OracleATE190 pointsBadges:
  • 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 varchar2, 7 P_StudentName in varchar2, 8 P_ID in...

    Shreeshonkar10 pointsBadges:
  • 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...

    Inprise610 pointsBadges:
  • 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 , i...

    Shaksing5 pointsBadges:
  • Search for a keyword in all columns of all database tables

    Dear Team, i have an requirement that : i want to search all the columns of all the tables in the particular database based on the specific key word or an free text. example : table 1: columns data empname sam empid 01 table 2 columns data deptname sam departmentid 10 table 3 columns data...

    Abdulgani5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following