Search results for query: *

...n1 NUMBER(5), padding VARCHAR2(200) ); / -- Create a table type -- CREATE TYPE array_table_type AS TABLE OF array_row_type; / /* Now define a table function which returns a collection containing a subset of the columns from T1 table. Table function mimics the table and can...

...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 T1.n1 5 , T1.small_vc 6 , mytable.padding 7 FROM 8...

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...

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...

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...

...on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 2 0.00 0.00 Disk file operations I/O 1 0.00...

...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; END...

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...

...| UPDATE STATEMENT | | 113K| 26M| 30409 (1)| 00:06:05 | | 1 | UPDATE | T1 | | | | | |* 2 | TABLE ACCESS FULL| T1 | 113K| 26M| 30409 (1)| 00:06:05 |...

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...

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

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...

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

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

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

This is a simple SQL that tries to replace 1024*1024 with a bind variable. Finding out table and index size for a table in MB The easy one 1 select substr(segment_name,1,30) AS "Object", 2 sum(bytes)/1024/1024 AS "Size/MB" 3 from user_extents where segment_name in...

...operates. For example is this unsigned integer? With UNSIGNED INTEGER you have a max value of 4294967295. However, if I perform the following maths, Oracle does not seem to mind! select 4294967295 * 4294967295 from dual; 4294967295*4294967295 --------------------- 1.8447E+19 Thanks

Thanks again. Trying as you suggested. First try what is running under oracle racle@rhes5:/home/oracle% ps -fuoracle UID PID PPID C STIME TTY TIME CMD oracle 5755 1 0 Nov17 ? 00:00:13 /u01/app/oracle/product/11.2.0/grid/bin/ohasd.bin reboot oracle 6847...

Thanks Karluk, I decided to reboot the host and check what is started by deamons first; ps -fuoracle oracle 5755 1 0 14:50 ? 00:00:02 /u01/app/oracle/product/11.2.0/grid/bin/ohasd.bin reboot So we have the Oracle Grid running. I will then do your suggestion...

...with errors. Although the last line says 'Command Start failed', it actually works and both the grid and instance are started. idle> select * from v$asm_diskgroup; GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB...