Search results for query: *

I have some data in my table declared in varchar 2000 200 20 2 Is any way I can write a SQL to output those data as 2000 0200 0020 0002 Many Thanks

There is the table: ColA ColB ColC ColD 0001 00011574 111500 Purchases Cost Pool 0001 00010001 280001 Home Office 0002 09910001 280001 Home Office 0001 00010002 280002 Short North 0001 00010003 280003 Affinity Deposits Is any way I can write a SQL query to...

How to move the logfile members from $ORACLE_BASE/oradata/ to $ORACLE_BASE/oradata/test? Thanks

How to change the password of the system user using alter user command?

Do you know the name of the admin scripts which is stored in the %ORACLE_HOME\rdbms\admin directory? I am new for Oracles, it does have lot of scripts inside this folder. Thanks

Hi all: How can I identify the instance name? Also, is anyway I can find out the version of the database?

Any comment for my Normal form concept is right .... CAR_SALE TABLE (Car #, Date_sold, Salesman#, Commission%, Discount_amt) Assume that a car may be sold by multiple salesman and hence {Car #, Salesman#} is the primary key. Additional dependencies are: Date_sold -> Discount_amt, and...

SET SERVEROUTPUT ON SET VERIFY OFF SET ECHO OFF ACCEPT p_num PROMPT 'Please enter the number of top money makers: ' DECLARE Wrong_Input EXCEPTION; v_num NUMBER(2) := &p_num; v_ename emp.ename%TYPE; v_sal emp.sal%TYPE; v_dept dept.dname%TYPE; tmp_sal emp.sal%TYPE; v_count Number...

Hello all: Is any command that I can identify the instance name, database vesion, database name and the its block size?

Hi: I am newbie for Oracle. I do have Oracle 9i database Personal ver install in my PC. Question: I open the SQLPLUS, Pop up Diolag Box ask for User & Password. Since I want be in DBA role to create database, tablespace, new user & grant this new user as DBA priviledges. So inside the...

Hello: I try to create my first sample trigger regarding checks inserts and updates on the attribute LOC of the DEPT table. If the new value is 'Houston', change it to 'Chicago'. *************************************************** CREATE OR REPLACE TRIGGER DEPT BEFORE INSERT OR UPDATE ON DEPT...

I just learn & install the Oracle 9i personal edition into my home PC. As I am DBA, what is the diff when I log into SQLPUS using Scott/tiger, system/manager, sys/change_on_install, sysoper/?? Thanks