1,488 Topics
 | |
| | Create a script named *just_lee_trg.sql* that contains the PL/SQL code to create a trigger named *books_qty_on_hand_trg*. The trigger should be set up to fire whenever the quantity on hand for a book has been updated. When the quantity on hand becomes zero, it should call the *insert_reorder* procedure and pass … |
| | I m try to solve this problem Add a column named *reorder_quanity* to the *books* table that will hold a value up to 999 with a default value of 10. 4. Update the reorder quantity of all books to 10. 5. Update the quantity ordered to 1 for all books … |
| | |
 | Is there any way to take oracle backup from java. [code] Connection c = // Connection Setting; st = c.createStatement(); rs = st.executeQuery("//What to write here for backup"); [/code] I have tried imp and exp utility , but they cant be accessed through sqlplus... |
| | select companyname,sum(sale) as TotalSale,sum(purchase) as TotalPurchase from invoice group by companyname Having companyname IN (select companyname from invoice) It returns sum only for those column whose all sum are not blank, how can i show blank sum values I mean there are 7 companies but only 4 records are shown. … |
| | How to take a user table backup from that user account? I mean i want to give him grants to take backup... also query to take backup. |
 | I need a little help connecting to an oracle database. I keep getting this error: Data provider internal error(-3000) [System.String]. [CODE=C#] using System; using System.Collections.Generic; using System.Linq; using System.Text; using Oracle.DataAccess.Client; using Oracle.DataAccess.Types; namespace OrcaleTest { class Program { static void Main(string[] args) { string connectionString = "user id=travus;password=password;data source=127.0.0.1"; … |
 | I installed Oracle 11g R2 on my Windows 7 64-bit OS.When i'm trying to login to SQL Plus,i can't.As i remember my Username and password is correct.Is there any method to login without giving username and password? or is there a way to get my username & password?Please help me.... |
| | |
| | Hi, I am trying to find out list of employees who have no dept_id. Below code works. [B]select e.emp_id, e.last_name, e.dept_id from employees E where dept_id IS NULL[/B] Below code does not work. i want to rewrite the query using NVL to replace the value by 0. does not work. … |
| | hey guys, i have a query wherein one table has the same id as the other using inner join.. SELECT c.cat_name, g.maxscore, g.description FROM grp_performance INNER JOIN category ON g.cat_id = c.cat_id Is it possible to use inner join when deleting a row? like.. DELETE FROM grp_performance INNER JOIN category … |
 | Imagine my surprise when I logged onto Daniweb and saw a scrolling advert for IBMs Informix database. I've been using Informix for years and it is an incredibly elegant bit of code, and the object extensions you can use are totally unique. I'd always thought of Informix as a secret …  |
| | Can anybody tell me the difference between a Primary key and a Unique Key ?Kindly let me know the idea.Any help would be highly appreciated. |
| | I have VS 2008 on Win 7 Professional 64bit system and database is Oracle 11g r2 installed on the same machine. In Data Source Configuration Wizard --> New Connection Data Source: Oracle Database (Oracle Client) When I click Test Connection after entering Service name, username, and password I get the … |
| | Can any one give a useful link to learn oracle report server and also how to connect it with java application.... Thank you.  |
| | Can any one give a useful link to learn oracle report server and also how to connect it with java application.... Thank you. Require second question answer.... |
| | |
| | I have an application in which user will put the query in text box and will get the output in gridview and i need to keep track that which user has run which query. for that i will be taking query from textbox and store in one variable I need … |
| | hi i already have oracle virtual box installed on my system , i need to find out if i could install vsphere client on it , or i have to install vmware? Thanks |
 | Dear all, Can any one tell me how can i take bakup on Every minute and hourly and complete whole day backup using VB.NET i.e i want to know the coding example Thanks in advance |
| | Hi, Could you please let me know if we can install Oracle 11 g R2 on Ubuntu Desktop 11.04? If + , can you please introduce me a tutorial which I can follow that? Best Regards, |
| | Hi Guys, This looks a little bit silly question but I really have problem with unzipping the oracle Oracle Database 11g Release 2 downloaded files. I am trying to install oracle on my Windows Vista and according to the Oracle download webpage : [CODE]Directions 1. All files are in the … |
| | Hi, I have four tables tab1,tab2,tab3 & tab4 [CODE] #contents of tab1: Id dataname 222 perl [/CODE] [CODE] #contents of tab2: Id data_desc 222 perl is a scripting language [/CODE] [CODE] #contents of tab1: Id other_desc 222 Regular expression [/CODE] [CODE] #contents of tab1: Id date 222 22-33-1964 [/CODE] I … |
| | I create a procedure to update table but when I execute to test the procedure with PRINT :g_name_pd show nothing as been change .. Can you guy's help where I m doing wrong Thanks Agaba[code]CREATE OR REPLACE PROCEDURE update_name_pd (p_name IN bb_product.productname%TYPE, p_id OUT bb_product.idproduct%TYPE ) IS BEGIN UPDATE bb_product … |
| | Hi, I want do pagination per page show only 25 records. Here is fetching data is too large and there I can't use rownum for that. in fetching data there is no any unique column. so tell me how can do it? Thnaks in advance. |
| | Hi, Im using Oracle 11g, and i have a query like select * from test where ID_PRIVILEGES = 'ADMIN'; but in database ID_PRIVILEGES is stored as Admin, I want case insensitive search to be done. I cannot change my query as select * from test where ID_PRIVILEGES = 'Admin'; Can … |
| | Can nay one tell me how can i set user permissions on form level to control user i.e i want to allow user1 only add permission and uer2 should have both add and edit permission how to do it on form level. Thanks in advance. |
| | I have an application which updates some files overnight from an oracle server. the application runs fine until at the very end when it closes. Then I get the message "Application has encountered a problem and needs to close. We are sorry for the inconvenience." when I click on the … |
| | I am getting data by view but there is too large data. so I want to select data in particular slab (i.e. 25 rec) but in my resulting data there is no any unique record in column for fetching. so please give me solution. selection records like rows 1 to … |
| | Hi This post is more for information purposes rather than help. I have just been tasked to investigate the upgrade for our applications to run on Windows 7. Oh, yes - easy one might say... Not!! We have a few applications running on a central Oracle server. To upgrade the … |
The End.