1,135 Topics
| |
Hi All, Could anyone suggest us how to check the Time in the Database when an Order get injected into the Oracle data base as of now i am able to see only the date , but inorder to know the time when i got generated can anyone help me? … | |
Hi, I have a table which I want to update thus: If d_date is has a value and b_date is 30 or more then set d_date as the min value already in d_date. I know that the WHERE EXISTS clause is wrong but I don't know how to make this … | |
Hi, I want to replace a word based on the positions. input I love programming (ilp) i want to replace lowercase ilp with uppercase ILP I love programming (ILP) how can resolve this issue? | |
Hello all I need some tips from people who are familiar with Oracle dba. i m trying to get OCA exam and i just finished reading my first chapter and now i m on chapter 2 and its telling me to download the dba software. so i m very confuse … | |
I need to derive last 2 numbers after the '-' from the code column. example if the code is 76767-99 then I need a query to return only 99. I am using substr and instr functions but not getting what I want. Please help me correct the below query. code … | |
Hi i have two tables called GeneralTable and SpecializedTable which has Name and State in It LIke 1 .GeneralTable ( GName , State ) 2. SpecializedTable( SName , State ) i want to write an SQL query which display the State from where the majority of Person ( both General … | |
Hi All: I installed oracle report server 10.1.2.02 I tried the following url and it display the page properly that ask Test run Job: [url]http://xxx/reports/rwwebservice?operation=runJob[/url] When I tried the url: [url]http://xxx/reports/rwservlet/showJobs?server=rep_xxx_oracleas3[/url] It is suppose to redirect me to an url to login. It did the first time. I was able … | |
hi I have a coulumn named Status which can have only three values: 1. Available (Default) 2. Unavailable 3. CheckedOut How can I add this functionality while creating the table? i.e. while creating the table itself how can i specify that the column can hold only these 3 values and … | |
i'm using jsp to connect to oracle database. I've installed oracle 10g .when i try to set a dsn name in control panel-administrative tools-Data sources(odbc)-system dsn-add-only sql native client and sql server are availabe. OS: vista home premium Please help me. | |
hello exprts!! i am new 2 database!!! i have oracleXE and jdk 1.6.0_14 installed on windows XP!! i want 2 connect them via my java program.but i am gettting errors after executing the program. my code is: [code=java]import java.sql.*; //import oracle.jdbc.*; //import oracle.jdbc.OracleDriver; public class OracleConnect { public static void … | |
i have oracle 9i. my friend created some tables and inserted few records in each. I want these tables with the records inserted. which files should he send me and where should I place those files? will that affect my existing tables? | |
Hi, I am not able to logn in sqlplus.. while I can logon with the same username and password in Enterprise Manager... EM- username: sys password: ***** option as sysdba.. but with the same username and password i am not able to logon in sqlplus.. can anybody tell me the … | |
hello, I am not getting which SQL statement should be used to insert multiple data at a same time without writing [ICODE]insert into...[/ICODE] again and again. suppose whenever i want to insert data into 'customer' table then i may write statement as [ICODE]insert into customer(c_id,c_name,c_city,c-street) values('C101','Hayes','Downtown','Main')[/ICODE] But it will create … | |
Hello Folks, I'm a not an expert in Oracle/SQL Server query and need some guidence and help from the professionals. Basis for my challange is that I have two tables that i need to collect data from. The main table is ACTIVITIES...secondary table is CODESET... Fields (column) To collect/ are... … | |
Dear Programmers, How can I dispaly and insert other language (Arabic/hindi/bangla/chinees etc) through form level field at run time window directly by keyboard???. | |
Hi Friends I am working as an asst. DBA in a Software Company. I am using SQL SERVER and Oracle 9i both to create and maintain database. I am also pursuing my administration in Oracle. I usually analyze that most of the companies with high profile are using Oracle and … | |
I have to create a report based on the customer for particular order. For example find all the customers who ordered an item ‘ABC’ for current month and look back 11 months to find out if the same customers ordered the same item and list all the customers who ordered … | |
Hi There. I am newbie. I need some helps on the below issues. Please help me! 1. How to create / delete user in Sql / Oracle? 2. How can I set privilages while create a new user? 3. How can I view all forms / tables? 4. How can … | |
i need a source code of LIBRARY SYSTEM or a RENT A CAR System plz help me. the code should be written in oracle. thank you. | |
I m trying to execute the sdo_migrate.to_current method like this : [CODE]execute sdo_migrate.to_current('tablename');[/CODE] but i keep getting invalid sql error, and i dont understand why. Please help | |
Hello, I am new to Crystal Reports with Oracle. I am trying to create a report ( in Crystal Reports) from an existing Oracle Database. The problem I am having is that I can get the tables but when I do a "browse Data" within the table, there are these … | |
Can anyone tell me .what will return this subquery.any help would be Greatly appreciated.kindly help me.it will return single row or multiple row if single then how.kindly let me know some idea. [code=oracle] select * from sub where job=(select job from job) [/code] | |
Hi All, I created a table with blob datatype in oracle and store the .doc and pdf file in that column But when i try to access the data from that table i am faceing an error data is corrupted. i am using php 5.2 and adodb driver and oracle … | |
First of all. Sorry if I don't have a good English... My operating system is Windows XP SP2 I'd created script files below for creating Oracle database manually: dbcamin.bat [code]mkdir C:\oracle\product\10.2.0\admin\dbcamin\adump mkdir C:\oracle\product\10.2.0\admin\dbcamin\bdump mkdir C:\oracle\product\10.2.0\admin\dbcamin\cdump mkdir C:\oracle\product\10.2.0\admin\dbcamin\udump mkdir C:\oracle\product\10.2.0\admin\dbcamin\dpdump mkdir C:\oracle\product\10.2.0\flash_recovery_area\dbcam in mkdir C:\oracle\product\10.2.0\admin\dbcamin\pfile mkdir C:\oracle\product\10.2.0\cfgtoollogs\emca\dbcamin mkdir C:\oracle\product\10.2.0\flash_recovery_area mkdir C:\oracle\product\10.2.0\oradata\dbcamin … | |
hi I have 3 tables - table1,table2,table3 table1 has 3 columns named col1,col2 and col3 and has 1 dummy record with values 0,1,2 respectively. The other records are my master records col1 col2 col3 0 1 2 A B C AA BB C D E F table 2 has the … | |
i have a database containing 100 questions . i want to select random 10 from it. how to do that? there is another database containing 100 questions. questions are stored along with an attribute level. there are 10 levels. so there are 10 records whose level value is 1 and … | |
Hi, I created a simple application in Oracle APEX, and on the first page (blank page), I put a textbox. Now, I want to be able to insert the input data from the textbox into the tables, e.g. insert new first name, last name etc... Can someone tell me if … | |
Can anyone suggest me how to create web pages using PlSql?? |
The End.