Hi Can anyone explain what this mean? I have practise PL/SQL about REF obj_type, my codes are:
CREATE or REPLACE TYPE home_type AS OBJECT ( street VARCHAR2(50), city VARCHAR2(20), state VARCHAR2(20), zipcode VARCHAR2(6), owner VARCHAR2(10) ); /
CREATE TABLE homes OF home_type; INSERT INTO homes VALUES ('300 Regina St', 'WATERLOO', 'ON', '010010', 'HFWANG'); INSERT INTO homes VALUES ('301 Regina St', 'WATERLOO', 'ON', '010010', 'MMWANG'); commit;
CREATE TABLE person ( id NUMBER(6) PRIMARY KEY, name VARCHAR2(10), addr REF home_type );
INSERT INTO person SELECT 10, 'HFWANG', ref(p) FROM homes p WHERE p.owner='HFWANG';
When I try to insert like the last sentense, the error comes out.
Hi all I wrote a procedure to send email via plsql procedure, It was compiled sucessfully but not working ....here is the code (actuly i added the dbms output like step1 ,step 2 to see in which step the control is going on )create or replace PROCEDURE send_test_messageIS mailhost VARCHAR2(64) := 'mail.cmcltd.com'; sender VARCHAR2(64) := 'akash.sharma@cmcltd.com'; recipient VARCHAR2(64) := 'lalit.mohan@cmcltd.com'; mail_conn utl_smtp.connection;BEGIN
Hi Can anyone explain what this mean? I have practise PL/SQL about REF obj_type, my codes are: CREATE or REPLACE TYPE home_type AS OBJECT (street VARCHAR2(50), city VARCHAR2(20), state VARCHAR2(20), zipcode
Latest Answer : I checked the code it's working fine. ...
C String Representation and Handling In this C tutorial you will learn about string representation and handling how is string represented end string notation initializing char array character representation string literals example programe to understand the character array concept and the accessing
JavaScript String Object In this JavaScript tutorial you will learn about String Object purpose of string object in JavaScript purpose of string object indexof method lastIndexOf method and substring method along with syntax and example mosgoogle center Purpose of String Object in JavaScript The mai
How to convert a string into an integer in C program?
This is done by using the function named as atoi(). This function atoi() is present in the header file named as <stdlib.h>. When programmers use this function they must include the header file by the statement
#include <stdl
What is the string handling functions present in header file <string.h>?
There are number of string handling functions present in string.h. In other words if a programmer uses any of the function present in string.h then they must include the header file as
#include <string.h&am
What string function is used to convert a string into long value?
This is done by using the function named as atol() . This function atol() is present in the header file named as <stdlib.h>. When programmers use this function they must include the header file by the statement
What happens when we try to change the value of base address of the string?
The base address of the sting takes a special place in the context of strings. This is because suing this base address only the string gets identified. In other words the base address therefore takes the position of constant
How To Properly Choose a CRM Solution If you go to CRM trade shows you will find that many of the vendors place an emphasis on slick packaging rather than a powerful product While you would think most companies would avoid falling for such marketing tactics you would be surprised by the number of co
How To Speak Properly During Group Discussions Speech plays an important role in our ability to communicate as humans This is especially important when we get together in groups During group discussions the speech you use can have a powerful impact on the way your message is received by those who li
How To Properly Manage a Data Warehouse When you manage your data warehouse you will want to do more than simply place an emphasis on maintaining the data You will want to maintain the data warehouse in a way which is directly related to caring for your customers mosgoogle When you maintain your dat
How To Delegate Tasks In Order To Properly Manage Your Time If you are the owner of a business it is likely that you have employees that work under you If this is the case you may be responsible for delegating tasks for them Being able to properly delegate time is an important part of good time mana
