AllExperts > Oracle 
Search      
Oracle
Volunteer
Answers to thousands of questions
 Home · More Oracle Questions · Question Library  · Free Encyclopedia ·
More Oracle Answers
Question Library

Ask a question about Oracle
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
About Edson
(Top Expert on this page)

Expertise
I can answer questions about Sql (including Sql tuning), pl/Sql and a bit of oracle administration

Experience
I work as a consultant in Brazil and I face problems of all kind in oracle every day development.

Education/Credentials
INFNET

   

You are here:  Experts > Computing/Technology > Oracle > Oracle

Questions Answered By Expert  Edson 
In Category  Oracle

SubjectDate Asked

Csv data into oracle10/22/2009
  Q: I want to load data from csv file into oracle database can u tell me step by step process for this
  A: SQL Loader SQL*Loader (sqlldr ) is the utility to use for high performance data loads. The data can ...
sql query9/26/2009
  Q: I want to know that how to use flash back query if anybook please tell me I want to rollback The ...
  A: ---Examples of FlashBack create table test_flashback (ab number(2)); insert into test_flashback ...
Execuitng queries stored in a table in a procedure8/31/2009
  Q: I have to execute 20+ static insert queries in procedure (which will be executed by a java ...
  A: A good and common approach is to create a table with a blob column. When you perform the loop, call ...
Call a stored procedure from a function8/28/2009
  Q: I have written a function which calls a stored procedure. A single parameter is passed to ...
  A: I could not understand your question well. What you want is to know the name of the procedure? If ...
Oracle8/16/2009
  Q: Sir I want to retrieve all records between two dates . that is all records between this two dates ...
  A: Some examples: select * from dual a where sysdate between to_date('16/07/2009','dd/mm/yyyy') and ...
sql query7/31/2009
  Q: GM sir SELECT count(*), deptno FROM employees GROUP BY deptno HAVING count(*) = (SELECT ...
  A: The question is not so clear for me, but see if this query helps you: select a.deptno, co from ...
sql query7/27/2009
  Q: emp001 emp002 14 emp002 emp003 8 emp003 emp001 12 emp003 ...
  A: I did the following: create table abc (a varchar2(100), b varchar2(100), c number); insert ...
oracle7/22/2009
  Q: Respected sir, I am student of MCA and I have one query in oracle. I have to insert record in two ...
  A: I didnīt really understand the problem, but see if this command helps you: Insert all Into ...
oracle - vb6/29/2009
  Q: How to insert a jpeg file into an oracle table? How to print the same column into data report in ...
  A: You must create a column with the type LOB (BLOB or CLOB). After you must create a procedure to ...
DECODE Function in pl/sql6/21/2009
  Q: There is a table with three columns name,location& sex.in name column there are different names and ...
  A: select count(*), sex, substr(location,..,..) from table group by sex, substr(location,..,..) If ...
Default Constraint6/20/2009
  Q: Will you please help me to implement Default constraint for multiple columns using alter statement. ...
  A: When you create a database table, you have the option to specify a DEFAULT value. Using default ...
data transfer from CSV file to database.6/6/2009
  Q: I want to transfer the data stored in CSV(comma seperated value) file to Oracle Database table. Can ...
  A: So you must have to use the final choice, the utl_file. Utl_file is a oracle�ackage that ...
data transfer from CSV file to database.6/5/2009
  Q: I want to transfer the data stored in CSV(comma seperated value) file to Oracle Database table. Can ...
  A: There are some good ways to do it. The simplest way is to use a interface, just like PL/SQL ...
need help to create table different db in oracle2/13/2009
  Q: How can i create a table in remote database 'db2' for which i have the prveliges, from the database ...
  A: An easy way to do it would be: 1 - Create a procedure in db1 2 - Create a procedure in db2 ...
why we need functions?1/6/2009
  Q: Procedures and functions both have same syntax except return. Both are functionally same. Then why ...
  A: You use functions when you need a result to be showed as an output. For example. Suppose you want ...
query12/30/2008
  Q: it is a etable Name Distance a 51 b 102 c 122 d 32 this table i have ...
  A: No, it is not. Try this sql: select dsitance, count(noofpeople) noofpeople from ( select 'From 0 ...
query12/9/2008
  Q: Please help me in this query: I have three tables tot_work, work_started and work_done. Each table ...
  A: select tab.*, case when work_done is not null and work_started is not null and tot_work ...
oracle12/2/2008
  Q: I have Hierarchical data in my table. I need the output as <parent1> <child1> ...
  A: I really didnīt understand what you want. However, when we want to make a hierarchical query, we ...
Oracle10/31/2008
  Q: I wanted to update some 400 records. 'RKTBG-EA-120001' To 'RKTBG-EA-120400' has to be changed as ...
  A: If all prefixes are RKTBGEA-EA- then update tab set col = 'R-KT-BG-EA-' || substr(col,12) if ...
Total vacation days per month10/29/2008
  Q: Edson, I want to calculate the number of vacation days per month for each employee based on the ...
  A: It is not "end Dec", what is listed bellow is a case case when () then end alias The jan, feb ...
Total vacation days per month10/26/2008
  Q: Edson, I want to calculate the number of vacation days per month for each employee based on the ...
  A: I made a query that I think can help you. But this query has to be a lot tested, so I suggest you ...
Case statements and subqueries10/21/2008
  Q: I have a column with either percentages, grams or an error message stored in it. I.e. EnteredValue ...
  A: I donīt know if I understood your question, but I did a little sql that I tnink can help you: ...
Clear Screen through PL SQL10/11/2008
  Q: ! Please help me to find out the solution for PL SQL questions : 1. How to Print the boolean ...
  A: One possible solution is the folowing: declare A boolean; B Varchar2(10); begin a := ...
snap shot dropping(internal error)9/4/2008
  Q: i canot drop snapshot log SQL> drop snapshot log on sad.sadik it is working 1 Day but not completed ...
  A: This can be many things, but the last time I saw this I had to put oracle down and then star it ...
Rearrange Columns in Table7/17/2008
  Q: I've been using MS Access for about a year and I am switching to Oracle lately. Is there a way to ...
  A: There is not a thing such this. What we usually do is to create another table with the same ...
describe all tables in database7/1/2008
  Q: i am thivya. i want to know whether is there any privilege to describe all the tables in my datbase ...
  A: There is not a thing such that. What you can do is to make a script: SET HEAD OFF SPOOL ...
Profile6/30/2008
  Q: We can see database entry by using oratab command and profile command..what is difference between ...
  A: "oratab" is a file created by Oracle in the /etc or /var/opt/oracle directory when installing ...
Oracle8i- TNS could not resolve service name6/26/2008
  Q: i am thivya working as a software developer. we got a project with VB as front end and oracle8i ...
  A: It can be many things, but there are some more possible: 1) The file TNSNAMES contains the ...
Can we have triggers on table present in different database.5/5/2008
  Q: Suppose we have two table present in database1 and database2 and we want to have a trigger to take ...
  A: Use the CREATE DATABASE LINK statement to create a database link. A database link is a schema object ...
cursors5/3/2008
  Q: What is the difference between using explicit cursor(without for update) to update data of emp table ...
  A: Many users perceive Explicit Cursors as a difficult means of retrieving data from the database. In ...
question abot matrix report4/15/2008
  Q: I am making a matrix report containing 2 rows and 1 column,I got it but my ist row feild is ...
  A: I would have to see your query for a deeper validation. But in a first see, I guess your are ...
pl/sql4/8/2008
  Q: Hai, How to use unwrap in pl/sql? Bcoz i wrapped one file now i want to unwrap how is it ...
  A: Yes you can, When you refresh a materialized view, you must choose a method to do it. The ...
Tuning3/28/2008
  Q: 1) I wrote two pages sql query but it will take time,now what are the steps i want to follow? ...
  A: You have some good bokks: http://www.amazon.com/SQL-Tuning-Dan-Tow/dp/0596005733 Almost All sql ...
Log on Session time out3/26/2008
  Q: On the following Answer where do I look for idle period in application server. thanks, Hi ...
  A: Oracle provides the ability to limit resource consumption via the user PROFILE, a collection of ...
pl/sql3/25/2008
  Q: 1) what is tkprof? and use of that? 2) I modified one table,some procedures,functions and packages ...
  A: 1) Understanding TKPROF You can run the TKPROF program to format the contents of the trace file ...
importing3/25/2008
  Q: how can i load the data from excel sheet to oracle 9i tables
  A: There are two ways. A easy and a difficult. The difficult one is to create a utl directory, put the ...
pl/sql3/19/2008
  Q: Hai, How to find out three maximum salary in Each department? How to find out ...
  A: ---1š Question select department, sal from ( select department, max(fpgg_vl_m01) sal, RANK() ...
Substitution in PLsql2/25/2008
  Q: I want to know : Through Subsitution variable using '&'I am taking value within a 'for loop'. ...
  A: Doesīt it works? declare a number; begin for i in 1 .. 3 loop if i = 1 then a:= ...
pl/sql2/22/2008
  Q: What is the use of raise_application ,exception_init? and when will use those give with example?
  A: Associating a PL/SQL Exception with a Number: Pragma EXCEPTION_INIT To handle error conditions ...
Substitution in PLsql2/20/2008
  Q: I want to know : Through Subsitution variable using '&'I am taking value within a 'for ...
  A: .. When you use '&' in oracle your are telling it to get a variable. It does it once and ...
Groups in oracle12/26/2007
  Q: .. Is it possible to manage groups in oracle. i.e. my requirement is i want to create a group and ...
  A: Managing Oracle Roles Administration of large numbers of objects can be difficult. Roles allow you ...
Use of Substitution12/12/2007
  Q: ! Please consider the code and output : Code: declare a number; begin for i in 1 .. 3 ...
  A: .. Unfortunately '&' is made to use once in a code, So the first value you pass is the one used for ...
Create Table12/6/2007
  Q: i am new to sql, i have currently created database in oracle, i have put the fk and pk on all table ...
  A: Forgive me! There were errors in the code. Here goes the right version: create or replace trigger ...
query12/4/2007
  Q: what is the default package in Oracle? ANSWER: Hi there. Could you be a little more specific? ...
  A: This will show you all packages: select * from ALL_OBJECTS A WHERE A.OBJECT_TYPE = 'PACKAGE' So ...
Disadvantage of Index9/17/2007
  Q: Can you tell me what are the disadvantages, if we user Index
  A: Your question is to wide, but I can answer this way: Bitmap Index vs. B-tree Index: Which and When? ...
Logical Directories/External Tables.9/12/2007
  Q: Could you please explain logical directories, including what they are and how you make them? What is ...
  A: Oracle introduced the concepts of DIRECTORY objects in Oracle 8.0. DIRECTORY object is a logical ...
oracle Question8/25/2007
  Q: sir,I will be conduct the exam for oracle 9i OCA certification,so what is format of question paper ...
  A: Run this script below: Change the names of the tables for that you want: create table 'NEW_TABLE' ...
oracle Question8/23/2007
  Q: sir,I will be conduct the exam for oracle 9i OCA certification,so what is format of question paper ...
  A: What is a unique constraint? A unique constraint is a single field or combination of fields that ...
oracle Question8/23/2007
  Q: sir,I will be conduct the exam for oracle 9i OCA certification,so what is format of question paper ...
  A: 1)suppose i am creating 2 user in one user i am creating one table takeing a primery and not null ...
oracle Question8/22/2007
  Q: sir,I will be conduct the exam for oracle 9i OCA certification,so what is format of question paper ...
  A: Specifying table-level or column-level constraints You can declare integrity constraints at the ...
DB Connectivity Problem8/16/2007
  Q: Sir, Whenever I login to oracle no login is accessible & following message displayed: "ORA-01033: ...
  A: ORA-01033: ORACLE initialization or shutdown in progress Cause: An attempt was made to log on while ...
ORA-00979: not a GROUP BY expression8/16/2007
  Q: I need advice on the above subject..below is my sql statement.. SELECT DISTINCT max(hdr_ver) as ...
  A: I really didnīt understand what you want...but here goes an advice: Which columns must be in the ...
PL/SQL8/12/2007
  Q: I'm trying to do this : The More Movies company needs to be sure that the number on hand of each ...
  A: Here goes some material http://infolab.stanford.edu/~ullman/fcdb/oracle/or-triggers.html ...
Oracle query8/10/2007
  Q: create table master_temp (Col1 number(2), Col2 varchar2(10)) insert into master_temp values ...
  A: select a.col2, mastval, c.keyval from master_temp a, child_temp b, transact c where ...
Help8/1/2007
  Q: i am steve working on a project using visual basic 2005 and oracle 10g as back end application for ...
  A: Try to use this type of connection. Dim OraSession As OraSessionClass Dim OraDatabase As ...
Help8/1/2007
  Q: i am steve working on a project using visual basic 2005 and oracle 10g as back end application for ...
  A: As your code is big I can be making a mistake. But arenīt you connecting to the database : ... ...
Host bind array to small7/9/2007
  Q: The following happens on an Oracle 10.2.0.3 on a Sun Solaris 10 server. I have used JPub to ...
  A: ... I havenīt understand your function, I guess you didnīt send me all of it. Please send me all ...
Temporary Table7/4/2007
  Q: I want to know what is the difference between creating a temporary tale and a static table. I want ...
  A: ORACLE 8I GLOBAL TEMPORARY TABLES ORACLE TEMPORARY TABLES In Oracle 8i, the CREATE GLOBAL ...
Oracle locking on Unix V/s Windows7/3/2007
  Q: I have PeopleSoft applications as my front end and Oracle as backend. Presently I have both these ...
  A: I agree with you, but here goes an article for better explain: In support of Oracle Linux Roby ...
adding a extra column onto a query7/2/2007
  Q: I am trying to complete the following query within oracle - Produce a report listing those students ...
  A: The problem is that you will have a a column with the same value along all the result: select ...
calling a function inside a select statement6/12/2007
  Q: why "calling a procedure with a commit inside a select statement" is possible and why "calling a ...
  A: U can't commit within a function. the function will compile but u get error at run time like this ...
Oracle Certification6/3/2007
  Q: I am planning to pursue DBA certification. Currently I am working as a Data Analyst. My question ...
  A: Oracle 10G has started working with grid applications, itīs the big difference, and of course those ...
oracle v/s foxpro6/2/2007
  Q: i know foxpro, and would request you to guide me and many other foxpro users regarding :- 1) does ...
  A: I would say yes to almost all questions, but as Iīm not a FoxPro expert I canīt answer the questions ...
oracle5/28/2007
  Q: i wanted to know about oracle.
  A: Oracle is a relational database worldwide used. Oracle is one of the best (if itīs not the better) ...
Join with possibly empty results5/21/2007
  Q: My question is about how to build a query for an Oracle server, so I can get in the same row results ...
  A: .. What you want is to get a parent-child model and transform it in a generation model. Itīs used ...
Join with possibly empty results5/18/2007
  Q: My question is about how to build a query for an Oracle server, so I can get in the same row results ...
  A: Sorry, but I really didnīt understand what you want. If you could please tell me the problem with ...
Oracle Trigger Error5/16/2007
  Q: I am trying to create a trigger that does not allow any student to enroll in more than five courses ...
  A: Try this: CREATE OR REPLACE TRIGGER studentfive AFTER INSERT OR UPDATE OF studentno ON enrolment ...
Oracle Trigger Error5/16/2007
  Q: I am trying to create a trigger that does not allow any student to enroll in more than five courses ...
  A: select count(studentno) into violation from enrolment group by studentno, sem, year; When you group ...
question5/11/2007
  Q: Can u tell me how to check a range of dates within a another range in oracle sql? for example i want ...
  A: Sorry, but I really didnīt understand what you want. an you give a example, or specifically your ...
subqueries4/16/2007
  Q: in oracle isqlplus how do you structure a multiple column subquery that allows you to return two ...
  A: This query represents the idea of what you want. See if it helps you, if not, ask me back Regards.. ...
SQL Query3/27/2007
  Q: I want to populate one row of a table into multiple rows on the base of start and end date column ...
  A: I created a table with the same structure of yours called Teste. Please change it by the name of ...
how to pivot a string3/23/2007
  Q: i want to break a string for Ex. 'William Jone Mathew' into three field and display it into three ...
  A: Try this block: select substr('William Jone Mathew', 1, instr('William Jone Mathew',' ', 1)), ...
Help for Oracle 9I SQL3/10/2007
  Q: I have Debit and credit transactions for each of month days. The fields are :- account,DrCr_Code(D ...
  A: These two examples illustrate a option to solve your problem: Using group by cube Example 1: ...
what are the "tab" and "dual"?3/7/2007
  Q: I always use "select * from tab" and "select SYSDATE from dual", what are the "tab" and "dual"? are ...
  A: Tab is a view, as seen: create or replace view sys.tab as select o.name, decode(o.type#, 2, ...
what are the "tab" and "dual"?3/7/2007
  Q: I always use "select * from tab" and "select SYSDATE from dual", what are the "tab" and "dual"? are ...
  A: Tab is a view, as seen: create or replace view sys.tab as select o.name, decode(o.type#, 2, ...
Replication1/9/2007
  Q: I am really new to this. I need to discuss with my manager and after that only I can decide. So this ...
  A: I guess there must be other solutions, but Iīve experience to work with this one and, it proved to ...
Replication1/9/2007
  Q: I am really new to it. I need to discuss with my manager about this. Then only I will know whether ...
  A: I guess there must be other solutions, but Iīve experience to work with this one and, it proved to ...
Replication1/9/2007
  Q: Host Machine:- VMS platform, Oracle database ( 7 database) Server Machine:- Windows 2003 Server, ...
  A: A way is: 1) create that replication triggers in the oracle database. 2) Create a process that ...
Replication1/9/2007
  Q: I was thinking about the master/slave replication but it works within mysql. Is there any other ...
  A: Letīs go. Please, tell me all the process you want... replicate from where to where? when ...
Replication1/9/2007
  Q: The trigger you have metioned, should I create them in the oracle(host) or mysql(server). Because I ...
  A: You would have to create them in oracle database. Unfortunately, if you want to create a ...
Replication1/8/2007
  Q: 1st thing i am going to do this migration of database from oracle to mysql using mysql migration ...
  A: Well...about the replication, you can do the following.... create a replication table for each ...
Replication1/7/2007
  Q: How to do replication from oracle to mysql. Can you explaind in detail pls.. Thanks
  A: This is a very wide question...full of possibilities. But thereīs two points we should have in ...
Views in SQL1/5/2007
  Q: Unfortunately, the query which I have placed below doesn't run and highlights the b and gives the ...
  A: All right, But whenever you want to do a query like that, do the following.... select <columns> ...
Views in SQL1/5/2007
  Q: I have written the query below but now I want to outer join my results which are in the select ...
  A: Try this select <columns> from tab1 A, <other table you want> (SELECT st.STORE_NO, ...
Looping through a Ref cursor12/28/2006
  Q: The below code gives the following error at line (for i in V1 loop) PLS-00221: 'V1' is not a ...
  A: .. The problem seems to be in this line: TYPE MY_CUR IS REF CURSOR; If you change for MY_CUR ...
how i read a string of format NN/NN.......12/13/2006
  Q: query to read a string, which in the format '--/--', the actual question is to check whether the ...
  A: Try: select decode(format,1,'Valid','Invalid') from ( select case when length('22/22') ...
How to move database12/12/2006
  Q: If u don't mind can u give me a detail description or way of coding for import/export. ByeHi, I ...
  A: How does one use the import/export utilities? Look for the "imp" and "exp" executables in your ...
Oracle SQL Query.12/8/2006
  Q: I have partly understood your answer and the have listed below the unanswered part that still ...
  A: Letīs go, You said: " For ex.: select <<expr>>,* from dual. But, this fails too. " It fails, ...
Oracle SQL Query.12/8/2006
  Q: When we fire the query "Select * from emp" oracle resolves the * to all the columns present in the ...
  A: The problem is: There is a concept in Relational Methodology that says: A line can not be ...
handing db_link error in exception12/7/2006
  Q: i want to trap the error regarding db_link in Exception. what should i write for raising an ...
  A: 1) Oracle execptions are: Oracle Exception Name Oracle Error Explanation ...
oracle12/5/2006
  Q: what is the difference between a view and a snapshot? how can i encode my password?
  A: This is not a small but a big confusion.....anyway... A view, is physically not a segment, but the ...
Oracle11/30/2006
  Q: I want to make a career in Oracle.So which certifications should i go for?And i would also like know ...
  A: I think a good way to start is to learn about relational databases. Itīs essencial that a good ...
Tuning11/27/2006
  Q: I would like to know that how a programmer can know that which specific query out of 200 Queries in ...
  A: Sory about the long time you waited, but I had problems in my account. If I understood your ...
round11/13/2006
  Q: how to get ROUND(0.51)=0.55 AND ROUND(0.50)=0.50
  A: Forgive me aboute the long time...but I was in trouble with my account in allexperts. Oracle treats ...

All Questions in This Category

Email this page
     
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2006 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.