Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dbalearner

  1. dbalearner

    Joining associative array with a table

    Thanks Carp. At the end I decided to use pipelined table function as follows: DROP FUNCTION array; DROP FUNCTION regular_array; DROP TYPE array_table_type; DROP TYPE array_row_type; -- --First define a row type that contains the columns we need -- CREATE TYPE array_row_type AS OBJECT (...
  2. dbalearner

    Joining associative array with a table

    I am new to associative arrays. Here I am trying to do the equivalent of the folowing: create table mytable as select n1,padding from T1 where rownum <=5; Table created. And join this table with T1 and the get the first 10 matching records 1 SELECT * FROM 2 ( 3 SELECT 4...
  3. dbalearner

    populating a million row based on existing table

    I have a table t that I created as follows: CREATE TABLE T AS ( SELECT a.* ,RPAD('*',4000,'*') AS PADDING1 ,RPAD('*',4000,'*') AS PADDING2 FROM ALL_OBJECTS a ) ORDER BY dbms_random.random; ALTER TABLE T ADD CONSTRAINT T_PK PRIMARY KEY (object_id); this table has...
  4. dbalearner

    Can one add new columns to CREATE TABLE AS ..

    Thanks guys. CREATE TABLE T AS ( SELECT a.* ,RPAD('*',4000,'*') AS IND_PAD ,RPAD('*',4000,'*') AS IND_PAD2 FROM ALL_OBJECTS a ) ORDER BY dbms_random.random; ALTER TABLE T ADD CONSTRAINT T_PK PRIMARY KEY (object_id); The above works fine. We are using this to test...
  5. dbalearner

    Can one add new columns to CREATE TABLE AS ..

    Oracle does not seem to like: CREATE TABLE T AS (SELECT *,RPAD('*',4000,'*) FROM ALL_OBJECTS) ORDR BY dbms_raddom.random * ERROR at line 1: ORA-00923: FROM keyword not found where expected However I think the only way is to do: CREATE TABLE T AS (SELECT * FROM...
  6. dbalearner

    Wait times differences

    Hi, I created a table T1 with index as follows: CREATE TABLE T1 ( n1 NUMBER(5) NOT NULL, ind_pad VARCHAR2(40) NOT NULL, n2 NUMBER(5) NOT NULL, small_vc VARCHAR2(10) NOT NULL...
  7. dbalearner

    Help with the code

    Thank you Santa all fixed. In the statement below: FOR i IN 1 .. l_data.count LOOP BEGIN SELECT * INTO l_rec FROM t WHERE object_id = l_data(i).object_id; EXCEPTION WHEN NO_DATA_FOUND THEN NULL...
  8. dbalearner

    Help with the code

    I have been given a sample code to test. The code is as follows: create table t as select * from (select * from all_objects order by dbms_random.random); alter table t add constraint t_pk primary key (object_id; 1 declare 2 type array is table of t%rowtype index by binary_integer; 3...
  9. dbalearner

    Comparing the same update on Hard Disks with Solid State Disks

    I have Oracle 11.2.0.1.0 - 64bit I created a table called T1 as follows: select DBMS_METADATA.GET_DDL('TABLE','T1') from DUAL; CREATE TABLE "MICH"."T1" ( "N1" NUMBER(5,0) NOT NULL ENABLE, "IND_PAD" VARCHAR2(40) NOT NULL ENABLE, "N2" NUMBER(5,0) NOT NULL ENABLE...
  10. dbalearner

    check if database server is running

    You can test it in UNIX script as follows: isql -U${USERNAME} -P${PASSWORD} -S${SQL_SERVER} -w1000 << ! > ${LOG_FILE} exit ! if [[ $? != 0 ]] then msg="`date` ${SQL_SERVER} problem. ${SQL_SERVER} on ${HOST} is down or...
  11. dbalearner

    sp_addlogin Password Protection

    Try isql with -X option isql -U${USERNAME} -P${PASSWORD} -S${SERVER_NAME} -w1000 -X exec sp_addlogin <LOGIN_NAME>,<PASSWORD>,<DATABASE>, ... go -X specifies that, in the connection to the server, the application initiates the login with client-side password encryption HTH, Learner
  12. dbalearner

    Non-fatal internal error happenned while SMON was doing logging scn-&gt;t

    Guys, I am getting this message in my alert file Errors in file /u01/app/oracle/diag/rdbms/mydb/mydb/trace/mydb_smon_7194.trc (incident=220642): ORA-00600: internal error code, arguments: [13013], [5001], [267], [8459028], [2], [8459028], [17], [], [], [], [], [] Incident details in...
  13. dbalearner

    Dictionary table showing all Oraccle data types

    Is there any dictionary table or view in Oracle that will provde the description of all data types that is available Oracle? Thanks, Learner
  14. dbalearner

    Pipe or limit sp_tables output

    To get a list of all tables in a given database do: use <DATABASE> go select name from sysobjects where type = 'U' order by name go To see a structure of a table do sp_help <TABLE_NAME> go etc good luck
  15. dbalearner

    Which sql code is more appropriate

    Hi Santa, Thanks for reply. Just needed a second opinion. Regards, Learner
See more

Part and Inventory Search

Back
Top