Home
Search results “Mm dd oracle”
Oracle tutorial : Conversion Functions In Oracle
 
09:30
Oracle tutorial : Conversion Functions In Oracle. oracle tutorial for beginners sql convert This Oracle tutorial video will show how to use conversion function in sql oracle TO_CHAR() , TO_DATE() , TO_NUMBER() these are mostly used functions. Conversions functions are used to convert one data type to another type. 1)To_CHAR ( number | date, [fmt], [nlsparams] ) The TO_CHAR function converts the number or date to VARCHAR2 data type in the specified format (fmt). 2)TO_NUMBER( char, [‘fmt’] ) The TO_NUMBER function converts the characters to a number format. 3)TO_DATE( char, [‘fmt’] ) The TO_DATE function converts the characters to a date data type. — TO_CHAR() fmYYYY YYYY/MM/DD SELECT TO_CHAR(SYSDATE, ‘YYYY/MM/DD’) FROM DUAL; — SO USING TO_CHAR U CAN GET FORMATE OF DATE ACCORDING TO UR REQURMENTS —- $99,999 99.99 99,00 SELECT TO_CHAR(487, ‘$99,0’) FROM DUAL; — U CAN GET DATA IN CURRENCY FORMAT —- TO_NUMBER() SELECT TO_NUMBER(‘1745′,’99999’) FROM DUAL; SELECT TO_NUMBER(‘1,47,982′,’9,99,999′) FROM DUAL; —- TO_DATE() — THIS CONVERT VARCHAR DATE TO PROPER DATE FORMAT SELECT TO_DATE(’30-JAN-1995′,’DD-MON-RRRR’) FROM DUAL; For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond sql convert convert function in sql
Views: 3840 Tech Query Pond
Custom date time format in Oracle SQL Developer?
 
01:03
From Oracle SQL Developer's menu go to Tools -- Preferences. From the Preferences dialog, select Database -- NLS from the left panel. From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS or for 24-Hour, DD-MON-YY HH24:MI:SS Or just for an active session use below instead. alter SESSION set NLS_DATE_FORMAT = 'required_date_format' i.e. alter SESSION set NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS' into the Date Format field. Save and close the dialog.
Views: 648 Maruti AIR Tech
Oracle Date Format
 
07:13
http://www.databasestar.com/oracle-to_date/ - A video that explains the different date formats in the Oracle SQL database.
Views: 3453 Database Star
Oracle SQL TUTORIAL – Date columns with Time in Where condition
 
12:41
In this video, we will see how to retrieve records for a specific time duration. SQLs used in this video are given below. select * from employees; alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS'; SELECT DBMS_RANDOM.VALUE(0,9) FROM DUAL; SELECT SYSDATE-DBMS_RANDOM.VALUE(0,9) FROM DUAL; SELECT FIRST_NAME,LAST_NAME, SYSDATE-DBMS_RANDOM.VALUE(0,9) CREATED_DATE FROM EMPLOYEES; CREATE TABLE EMP_TEST AS SELECT FIRST_NAME,LAST_NAME, SYSDATE-DBMS_RANDOM.VALUE(0,9) CREATED_DATE FROM EMPLOYEES; SELECT * FROM EMP_TEST ORDER BY CREATED_DATE DESC; select sysdate from dual; select sysdate,trunc(sysdate) from dual; 26 sep 2018 00:00:00 to 26 sep 2018 23:59:59 select sysdate,trunc(sysdate),trunc(sysdate)+0.99999 from dual; Records that got created yesterday.. 25 sep 2018 00:00:00 to 25 sep 2018 23:59:59 select trunc(sysdate-1),trunc(sysdate-1)+0.99999 from dual; SELECT * FROM emp_test WHERE created_date BETWEEN trunc(SYSDATE-1) AND trunc(SYSDATE-1)+0.99999 order by created_date; Retrieve records for 22nd Septembter 2018 SELECT * FROM emp_test WHERE created_date BETWEEN to_date('22-sep-2018 00:00:00','dd-mon-yyyy hh24:mi:ss') AND to_date('22-sep-2018 23:59:59','dd-mon-yyyy hh24:mi:ss') order by created_date; SELECT * FROM emp_test WHERE created_date BETWEEN to_date('22-sep-2018','dd-mon-yyyy') AND to_date('22-sep-2018 23:59:59','dd-mon-yyyy hh24:mi:ss') order by created_date; -- Get all records created in last 24 hours select sysdate,sysdate-1 from dual; SELECT * FROM emp_test where created_date between sysdate-1 and sysdate order by created_date;
Views: 51 Ganesh Anbarasu
Oracle TO_TIMESTAMP Function
 
01:31
https://www.databasestar.com/oracle-to_timestamp/ The Oracle TO_TIMESTAMP function can be confusing, but we’ll explain it in this video. This function allows you to convert a string value into a TIMESTAMP value. A TIMESTAMP value is a type of DATE, but has a few components: - A date, including day, month, and year - A time, including hours, minutes, seconds, and fractional seconds This is a useful data type because it allows you to store a time down to fractions of a second. The syntax of the TO_TIMESTAMP function is: TO_TIMESTAMP ( input_string [, format_mask] [, nls_param] ) The input_string parameter is the string you want to convert. The format_mask is where you specify the format of the input_string parameter. This is so you can specify the input_string in a variety of formats, and just use this format_mask to indicate which format it is in. The nls_param parameter is another optional parameter, and allows you to specify the returning language of the month and day names. The default format will depend on the region you’re running your database in. In my example (using Oracle Express in Australia), the default format is ‘DD-MM-RRRR HH:MI:SS AM’. For more information on the Oracle TO_TIMESTAMP function, including the SQL used in this video, read the related article here: https://www.databasestar.com/oracle-to_timestamp/
Views: 387 Database Star
Flashback Query Oracle Database||  Recovery Deleted Row
 
05:41
MD.Rahim Uddin Shohag Founder - Oracle Bangla https://www.oraclebangla.com/ fb :: https://www.facebook.com/oracle.shohag email: [email protected] Recovery Deleted Row in Oracle using Flashback Query ============================================ i'm show you how to recovery Deleted row in oracle database following Step :: ================== /* FLASHBACK QUERY NO NEED DBA */ CREATE TABLE DEMO_CUSTOMER ( CUST_ID NUMBER CONSTRAINT DEMO_CUSPRIMARY PRIMARY KEY, CUST_NAME VARCHAR2(100 BYTE), CUST_ADDRESS VARCHAR2(200 BYTE), CUST_PHONE VARCHAR2(15 BYTE), CUST_WEBSITE VARCHAR2(100 BYTE), CREATE_DATE DATE DEFAULT SYSDATE ); SELECT SYSDATE FROM DUAL; --------------- INSERT RECORD --------- INSERT INTO DEMO_CUSTOMER VALUES(100,'SHOHAG','DHAKA','121212','www.oraclebangla.com',SYSDATE); INSERT INTO DEMO_CUSTOMER VALUES(101,'RAHIM','Feni','121212','www.google.com',SYSDATE); INSERT INTO DEMO_CUSTOMER VALUES(103,'Rubel','karwan bazar','121343','www.obn.com',SYSDATE); INSERT INTO DEMO_CUSTOMER VALUES(104,'Karim','DHAKA','1212432','www.OCA.com',SYSDATE); COMMIT; SELECT * FROM DEMO_CUSTOMER; SELECT COUNT(*) FROM DEMO_CUSTOMER SELECT SYSDATE FROM DUAL; ---- AFTER FEW MINUTE -------- DELETE FROM DEMO_CUSTOMER WHERE CUST_ID = 100; DELETE FROM DEMO_CUSTOMER WHERE CUST_ID = 101; DELETE FROM DEMO_CUSTOMER WHERE CUST_ID = 103; COMMIT; SELECT * FROM DEMO_CUSTOMER; SELECT COUNT(*) FROM DEMO_CUSTOMER -----Way No 1 AFTER 1 MINIUTE ---------- SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP (SYSTIMESTAMP -INTERVAL '1' MINUTE) ; SELECT COUNT(*) FROM DEMO_CUSTOMER; SELECT * FROM DEMO_CUSTOMER; /* IF SPECIFIC TIME FINDE DATA HISTORY */ ---- why no 2 SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM'); ---============== recovery data ============= SELECT * FROM DEMO_CUSTOMER; --------------------------- SPECIFIC DATA RECOVERY -------------------------- SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP (SYSTIMESTAMP -INTERVAL '2' MINUTE); INSERT INTO DEMO_CUSTOMER (SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP (SYSTIMESTAMP -INTERVAL '2' MINUTE) WHERE CUST_ID = 101); COMMIT; SELECT * FROM DEMO_CUSTOMER; --- RECOVERY SINGEL RECORD FLASHBACK 2ND WAY SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM'); INSERT INTO DEMO_CUSTOMER ( SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') WHERE CUST_ID = 100 ); COMMIT; SELECT * FROM DEMO_CUSTOMER; ---IF YOU RECOVERY DATA ALL DELETE RECORD JUST SIMPLE TECHNIC ----- SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') MINUS SELECT * FROM DEMO_CUSTOMER INSERT INTO DEMO_CUSTOMER( SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') MINUS SELECT * FROM DEMO_CUSTOMER); COMMIT; SELECT * FROM DEMO_CUSTOMER; SELECT COUNT(*) FROM DEMO_CUSTOMER; ------ IF YOU UPDATE RECORD FLASHBACK QUERY CHECK --- UPDATE DEMO_CUSTOMER SET CUST_NAME = 'Oracle' WHERE cust_id = 104; commit; SELECT * FROM DEMO_CUSTOMER; SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:24:40 PM','DD-MM-RRRR HH:MI:SS AM') WHERE CUST_ID = 104 SELECT * FROM DEMO_CUSTOMER AS OF TIMESTAMP TO_TIMESTAMP('21-02-2018 04:30:00 PM','DD-MM-RRRR HH:MI:SS AM') WHERE CUST_ID = 104
Views: 708 Oracle Bangla
#12  Java + Oracle ::: Insert Date to DB using JDate Chooser in Java oracle
 
18:20
کلیک لەم لینکەی خوارەوە بکە بۆ دابەزاندنی سەرجەم فایلە پێویستەکان کە لەم فێرکارییە باسکراوە Visit below link to install all jar file connection for (MySql ,MS Access , Oracle , SQLite) ...rs2xml,JCalender: ======================================= https://www.4shared.com/s/fa8Bha-kvgm =======================================
Views: 290 H4T
WR MC Find what is wrong with Oracle SQL Developer
 
04:35
SQL 1 : SELECT LTRIM(sq.sql_text) FROM v$sql sq INNER JOIN dba_users us ON sq.parsing_user_id = us.user_id WHERE us.username = 'PRDB'; SQL 2: ALTER SYSTEM FLUSH SHARED_POOL; SQL 3: DECLARE RESULT_CURSOR SYS_REFCURSOR; BEGIN "PRDB"."PP_F4006"( result_cursor, TO_DATE('01-02-2017 00:00:00','DD-MM-YYYY HH24:MI:SS'), TO_DATE('28-02-2017 00:00:00','DD-MM-YYYY HH24:MI:SS'), 0, '', 0, '', '', '', '', 0, 1, '103', 0, 0, 1, 1, 'protel' ); END; Ref: http://www.dba-oracle.com/10g_flush_shared_pool.htm http://www.thatjeffsmith.com https://asktom.oracle.com
Views: 25 Kaan Çelik
Oracle Interview question How To Get unique records without using distinct in oracle
 
11:56
Oracle Interview question How To Get unique records without using distinct in oracle? http://easy-learning-tech.blogspot.com/2018/07/how-to-get-unique-records-without-using.html List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 263 Siva Academy
Função Oracle MONTHS BETWEEN
 
04:54
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função de MONTHS_BETWEEN retorna a diferença de meses entre duas datas. SELECT months_between(TO_DATE('28/12/2017', 'DD/MM/YY'), TO_DATE('03/08/2017', 'DD/MM/YY')) AS MONTHS_BETWEEN FROM dual; SELECT trunc(months_between(TO_DATE('28/12/2017', 'DD/MM/YY'), TO_DATE('03/08/2017', 'DD/MM/YY'))) AS MONTHS_BETWEEN FROM dual; SELECT round(months_between(TO_DATE('28/12/2017', 'DD/MM/YY'), TO_DATE('03/08/2017', 'DD/MM/YY'))) AS MONTHS_BETWEEN FROM dual; https://www.youtube.com/watch?v=PjaBYIwXf8c&list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 638 Aprenda PL/SQL
TUTORIAL MEMBUAT PHYSICAL DATABASE DARI ORACLE SQL DEVELOPER
 
38:24
Tutorial kasar : -sqlplus oa/oa -connect as sysdba; -create user paijo identified by paijo; -grant all privilege to paijo; -connect paijo/paijo -show user //lalu buat file di oracle home dengan nama paijo.sql dengan isi: ========================================= DROP TABLE "DOKTERS"; DROP TABLE "PASIENS"; DROP TABLE "DIAGNOSAS"; CREATE TABLE DOKTERS ("ID_DTR" VARCHAR (7), "NAMA" VARCHAR (25) NOT NULL, "ALAMAT" VARCHAR (30) NOT NULL, CONSTRAINT "ID_DTR_PK" PRIMARY KEY ("ID_DTR") USING INDEX ENABLE); CREATE TABLE PASIENS ("ID_PSN" VARCHAR (9), "NAMA" VARCHAR (25) NOT NULL, "ALAMAT" VARCHAR (30), CONSTRAINT "ID_PSN_PK" PRIMARY KEY ("ID_PSN") USING INDEX ENABLE); CREATE TABLE DIAGNOSAS ("TANGGAL" DATE, "HASIL" VARCHAR (30) NOT NULL, "ID_DTR" VARCHAR (7), "ID_PSN" VARCHAR (9), CONSTRAINT "TGL_PK" PRIMARY KEY ("TANGGAL", "ID_DTR", "ID_PSN") USING INDEX ENABLE); ====================================== [email protected] -desc dokters; -desc pasiens; -desc diagnosas; //lalu buat file di oracle home dengan nama alter_paijo.sql dengan isi: ===================================== ALTER TABLE DIAGNOSAS ADD CONSTRAINT "DIA_ID_DTR" FOREIGN KEY ("ID_DTR") REFERENCES DOKTERS ("ID_DTR"); ALTER TABLE DIAGNOSAS ADD CONSTRAINT "DIA_ID_PSN" FOREIGN KEY ("ID_PSN") REFERENCES PASIENS ("ID_PSN"); =================================== [email protected]_paijo.sql //lalu buat file di oracle home dengan nama isi_paijo.sql dengan isi: =================================== INSERT INTO DOKTERS VALUES('D100799','PAIJO','JALAN IN AJA'); INSERT INTO DOKTERS VALUES('D120498','PAINO','JALAN JALAN'); INSERT INTO DOKTERS VALUES('D071297','PAIWO','JALAN YANG BENAR'); INSERT INTO PASIENS VALUES('PSN130193','JARWO','JALAN LURUS'); INSERT INTO PASIENS VALUES('PSN040494','JARVIS','JALAN GRAK'); INSERT INTO PASIENS VALUES('PSN121212','JARAN','JALAN BERBELOK'); INSERT INTO DIAGNOSAS VALUES(TO_DATE('18-12-18','DD-MM-YY'),'PARU KERING','D100799','PSN130193'); INSERT INTO DIAGNOSAS VALUES(TO_DATE('19-12-18','DD-MM -YY'),'KAGETAN','D120498','PSN040494'); INSERT INTO DIAGNOSAS VALUES(TO_DATE('20-12-18','DD-MM-YY'),'GATEL','D071297','PSN121212'); ================================ [email protected]_paijo.sql -select * from dokters; -select * from pasiens; -select * from diagnosas; //lalu buat file di oracle home dengan nama select_paijo.sql dengan isi: ============================== SELECT DOKTERS.ID_DTR, DOKTERS.NAMA, PASIENS.ID_PSN, PASIENS.NAMA, DIAGNOSAS.TANGGAL, DIAGNOSAS.HASIL FROM DOKTERS, PASIENS, DIAGNOSAS WHERE DOKTERS.ID_DTR = DIAGNOSAS.ID_DTR AND PASIENS.ID_PSN= DIAGNOSAS.ID_PSN =========================== [email protected]_paijo.sql
Sql function for returning date from given format
 
04:36
Sql function for returning date from given format of date like DD/MM/YYYY or MM/dd/yyyy or MMM-dd-yyyy etc
Views: 475 Pankaj Kumar Sinha
How To Using Date Fomat In SQL Server
 
11:50
This video for the SQL Programmer beginner only it will show you how to using date format in SQL Server
Views: 11926 Sourn Sarim
TO_CHAR(datetime) Function in SQL Query
 
03:59
TO_CHAR (datetime) : TO_CHAR (datetime) converts a datetime datatype to a value of VARCHAR2 datatype in the format specified by the date format. The following is a list of valid parameters when the TO_CHAR function is used to convert a date to a string. These parameters can be used in many combinations. YEAR Year, spelled out YYYY 4-digit year YYY Last 3 digits of year. YY Last 2 digits of year. Y Last 1 digit of year. IYYY 4-digit year based on the ISO standard Q Quarter of year (1, 2, 3, 4; JAN-MAR = 1). MM Month (01-12; JAN = 01). MON Abbreviated name of month. MONTH Name of month, padded with blanks to length of 9 characters. RM Roman numeral month (I-XII; JAN = I). WW Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year. W Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh. IW Week of year (1-52 or 1-53) based on the ISO standard. D Day of week (1-7). DAY Name of day. DD Day of month (1-31). DDD Day of year (1-366). DY Abbreviated name of day. J Julian day; the number of days since January 1, 4712 BC. HH Hour of day (1-12). HH12 Hour of day (1-12). HH24 Hour of day (0-23). MI Minute (0-59). SS Second (0-59). SSSSS Seconds past midnight (0-86399). FF Fractional seconds. Thanks for watching...:)
Views: 10235 WingsOfTechnology
CARGA MASIVA DE DATOS BASE DE DATOS ORACLE
 
14:20
Nombre: Marco Alexander Mateo Carnet: 200917702 Enlaces: http://silexcorp.org/ Archivo de cotrol: OPTIONS (SKIP=1) LOAD DATA INFILE 'FileData/entrevista_con_prueba_psicometrica.csv' INTO TABLE TEMP_ENTREVISTA FIELDS TERMINATED BY "," ( carne "substr(:carne, 1, 4) || substr(:carne, 6, 10)", fecha "TO_DATE(:fecha,'DD/MM/YYYY','NLS_DATE_LANGUAGE=ENGLISH')", carrera1 , unidad1 , califica1 , carrera2 , unidad2 , califica2 , sede , departamento , municipio , nombresede , direccion , telefono1 , telefono2 , telefax , fax1 , fax2 , fax3 ) Script: sqlldr userid=practica2/practica2 control=entrevista.ctl sqlldr userid=practica2/practica2 control=estudiantes.ctl https://www.mediafire.com/?9gond0dcdcaufr6
Views: 1010 Alexander Mateo
Oracle SQL Loader - Introduction - Tutorial -1
 
07:47
This video is the first tutorial on Oracle SQL*Loader utility. This video gives the introduction and helps in understanding the concept behind Oracle SQL Loader. Why it should be used and the advantages of using it. SQL Loader is a bulk loader utility used for moving data from external files into the Oracle database tables. In this video we look at the overview of Oracle SQL Loader, we look at the complete flow of the process. It's basically a Conceptual introduction to the SQL Loader utility. What you will learn in this video 1. What is SQL Loader? 2. You will get an understanding on the Components of SQL Loader like control file, Log file, Discard File and Bad file. 3. Complete flow of the process. Visit the other videos on the same : Second video visit https://youtu.be/ogidUWHHRL8 Third video visit https://youtu.be/yD_CL_cf8tQ Check out the advantages of using TRUNCATE over a DELETE from the following video: Delete VS Truncate : https://youtu.be/u76wMm2byXo #KishanMashru #Oracle #SqlLoader #SqlLoaderConcept #SqlLoaderIntroduction #SQLandPLSQL #OracleSqlLoader #ETL #database
Views: 590 Kishan Mashru
Função Oracle LAST DAY
 
03:51
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função LAST_DAY retorna o último dia do mês da data passada como parâmetro. SELECT trunc(sysdate) AS Data_atual, last_day(trunc(sysdate)) AS ultimo_dia_mes FROM dual; SELECT last_day(to_date('10/02/2016', 'DD/MM/YY')) AS ultimo_dia_mes FROM dual; SELECT hire_date, last_day(hire_date) AS Ultimo_dia_mes FROM hr.employees WHERE employee_id =114; https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 508 Aprenda PL/SQL
Função Oracle ADD MONTHS
 
05:29
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função ADD_MONTHS no Oracle recebe 2 parâmetros, sendo o primeiro a data que vai ser manipula e o segundo um inteiro que pode ser positivo ou negativo referente a quantidade de meses que serão adicionados ou subtraídos. SELECT trunc(sysdate) AS Data_atual, add_months(trunc(sysdate), 5) AS ADD_MONTHS FROM dual; SELECT add_months(to_date('29/02/16', 'DD/MM/YY'),1) AS ADD_MONTHS FROM dual; SELECT add_months(to_date('28/02/17', 'DD/MM/YY'),1) AS ADD_MONTHS FROM dual; SELECT add_months(to_date('27/02/16', 'DD/MM/YY'),1) AS ADD_MONTHS FROM dual; SELECT trunc(sysdate) AS Data_atual, add_months(trunc(sysdate), -1) AS ADD_MONTHS FROM dual; https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 486 Aprenda PL/SQL
Oracle SQL Select Part_2
 
04:11
Oracle SQL Select Part_2
Views: 35 Engin Kosova
create java calendar in oracle forms 10g | Ten Minute Code
 
16:19
Below Code Set CALENDAR in Oracle’ forms & Show SYSDATE at run time. 1.create table : Create table add_date (Id number, Start_date date); 2.create forms 3. Calendar.jar set in java- D:\DevSuiteHome_2\forms\java\calander.jar 4. Set formsweb.config- D:\DevSuiteHome_2\forms\server find- archive 5. Create FUNCTION In the program unit FUNCTION Quium_function RETURN date IS hBeanEventDetails ParamList; eventName varchar2(80); paramType number; eventType varchar2(80); newDateVal varchar2(80); newDate date := null; begin hBeanEventDetails := get_parameter_list(:system.custom_item_e¬vent_parameters); eventName := :system.custom_item_event; if(eventName = 'DateChange') then get_parameter_attr(hBeanEventDetails, 'DateValue', ParamType, newDateVal); newDate := to_date(newDateVal,'DD.MM.RRRR'); -- else -- MsgBox.show(MsgBox.STOP_ALERT,'Uknown event received - ' || eventName); end if; return newDate; end; 6 Create When-custom-item-event in bean trigger declare newdate date; begin newdate := Quium_function; if (newdate is not null) then :ORDERS.ORDER_DATE:= newdate; end if; end; 7. Write Property palates in bean area Implementation Class: oracle.forms.demos.CalendarWidgetWrapper
Views: 3808 Together Oracle
When Are You Getting Married? 🕒 Pick A Number 🔮 Tarot Time Prediction
 
13:31
Hi Earthlings! 🌏 Thanks for stopping by 🦋 I’m an intuitive Tarot healer. 🔮🎴✨ ⛔️Please remember that if you don’t resonate with this general reading, the message may not be for you. 🌙 Donations to this channel : http://www.paypal.me/earthtoanza (much appreciated!) 🖥 Website : http://www.earthtoanza.com 🍵 Tarot Tea-Shirts (merch) : https://teespring.com/stores/earth-to-anza PopSockets : http://a.co/d/gdsv91d 🎴Tarot & Oracle Cards I Use: http://a.co/jhrM2sT 🐘 Favorite Items : http://a.co/494qQue 💧 Best 100% Therapeutic Oils & Diffuser I use : https://goo.gl/TLHk4Y (I do receive commission when you sign up but so can you :) ) ⭐️ PERSONAL READINGS I OFFER ⭐️ To book a reading, please visit my website at http://www.earthtoanza.com If stated on the website that readings are unavailable, please check back soon! Please book your reading on http://www.earthtoanza.com along with your question and birthday (mm/dd/yyyy). Once payment is confirmed, you will receive your reading from me within 72 hrs from the scheduled time. (72 hours from the date and time you scheduled when booking. Pacific Standard Time) Thank you! ✌️❤️🌟 ** Refunds will only be made if I am unable to do your reading. ** Not responsible for the decisions you make and the outcome.
Views: 2118 Earth to Anza
ORACLE SQLPLUS.✓ Acceso con Command ✓ Ejecución de *.txt ✓ Formato Fecha ✓ Spool
 
10:53
Prof.: Juan Miguel Vargas Rivera. Contenidos de la Sesión ✓ SqlPlus se puede abrir desde la ventana de comandos (Windows+R), ingresando 'sqlplus usuario/contraseñ[email protected]'. ✓ Recordar que para ingresar debemos utilizar 'connect'; para cerrar cerrar debemos ingresar 'disconnect' y luego 'exit'. ✓ Uso de archivo de texto para cargar lineas de codigo sql. Una vez creado el archivo ingresar 'start' o "@" seguido de la ubicacion del archivo. ✓ Mostrar tablas del usuario usando la estructura 'select table_name from user_tables'. ✓ Para modificar la fecha de sistema debemos ingresar: "alter session set nls_date_format='yyyy-mm-dd' ". Para visualizar la fecha de sistema ingresamos 'sysdate'. ✓ Uso de 'spool'. Sirve para guardar el registro de las consultas y resultados. Se utiliza ingresando 'spool' seguido de la ruta del archivo de destino. Al final se ingresa spool off y nos da como resultado un archivo con todas las operaciones y resultados obtenidos con el SqlPlus.
Views: 59 Elías Jurado
oracle to ms excel using forms 6i | Ten Minute Code
 
02:45
Below Code declare application ole2.obj_type; workbooks ole2.obj_type; workbook ole2.obj_type; worksheets ole2.obj_type; worksheet ole2.obj_type; cell ole2.obj_type; arglist ole2.list_type; row_num number; col_num number; fontObj ole2.obj_type; cursor rec is select emp_id,emp_nm,to_char(join_dt,'dd/mm/rrrr') date_of_birth from emp_mast where join_dt is not null; procedure SetCellValue(rowid number,colid number,cellValue varchar) is begin arglist := ole2.create_arglist; ole2.add_arg(arglist,rowid); ole2.add_arg(arglist,colid); cell:= ole2.get_obj_property(worksheet,'Cells',arglist); fontObj := ole2.get_obj_property(cell,'Font'); ole2.destroy_arglist(arglist); ole2.set_property(cell,'value',cellValue); ole2.set_property(fontObj,'Size',16); ole2.set_property(fontObj,'BOLD',1); ole2.set_property(fontObj,'ColorIndex',7); ole2.release_obj(cell); end SetCellValue; procedure app_init is begin application := ole2.create_obj('Excel.Application'); ole2.set_property(application,'Visible',true); workbooks := ole2.get_obj_property(application,'workbooks'); workbook := ole2.invoke_obj(workbooks,'add'); worksheets := ole2.get_obj_property(application,'worksheets'); worksheet := ole2.invoke_obj(worksheets,'add'); ole2.set_property(worksheet,'Name','Emp Sheet'); end app_init; procedure save_excel(path varchar,filename varchar) is begin OLE2.Release_Obj(worksheet); OLE2.Release_Obj(worksheets); -- Save the Excel file created If path is not null then Arglist := OLE2.Create_Arglist; OLE2.Add_Arg(Arglist,path||'\'||file_name||'.xls'); OLE2.Invoke(workbook, 'SaveAs', Arglist); OLE2.Destroy_Arglist(Arglist); end if; end save_excel; begin app_init; row_num:=1; col_num:=1; SetCellValue(row_num,col_num,'Emp Code'); col_num:=col_num + 1; SetCellValue(row_num,col_num,'Emp Name'); col_num:=col_num + 1; SetCellValue(row_num,col_num,'Date of Birth'); for i in rec loop row_num:=row_num + 1; col_num:=1; SetCellValue(row_num,col_num,i.emp_id); col_num:=2; SetCellValue(row_num,col_num,i.emp_nm); col_num:=3; SetCellValue(row_num,col_num,i.date_of_birth); end loop; save_excel('d:\excel_export','emp_data'); OLE2.Release_Obj(workbook); OLE2.Release_Obj(workbooks); OLE2.Release_Obj(application); end;
Views: 2171 Together Oracle
PICK A CARD 🔮 3 WEEKS FROM NOW 🤯 PREDICTION ⭐️ Love, Money, Spirituality...
 
41:17
Hi Earthlings! 🌏 Thanks for stopping by 🦋 I’m an intuitive Tarot healer. 🔮🎴✨ ⛔️Please remember that if you don’t resonate with this general reading, the message may not be for you. 🌙 Donations to this channel : http://www.paypal.me/earthtoanza (much appreciated!) 🖥 Website : http://www.earthtoanza.com 🍵 Tarot Tea-Shirts (merch) : https://teespring.com/stores/earth-to-anza PopSockets : http://a.co/d/gdsv91d 🎴Tarot & Oracle Cards I Use: http://a.co/jhrM2sT 🐘 Favorite Items : http://a.co/494qQue 💧 Best 100% Therapeutic Oils & Diffuser I use : https://goo.gl/TLHk4Y (I do receive commission when you sign up but so can you :) ) ⭐️ PERSONAL READINGS I OFFER ⭐️ To book a reading, please visit my website at http://www.earthtoanza.com If stated on the website that readings are unavailable, please check back soon! Please book your reading on http://www.earthtoanza.com along with your question and birthday (mm/dd/yyyy). Once payment is confirmed, you will receive your reading from me within 72 hrs from the scheduled time. (72 hours from the date and time you scheduled when booking. Pacific Standard Time) Thank you! ✌️❤️🌟 ** Refunds will only be made if I am unable to do your reading. ** Not responsible for the decisions you make and the outcome.
Views: 54133 Earth to Anza
Função Oracle NEXT DAY
 
03:15
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função NEXT_DAY recebe 2 parâmetros de entrada, onde o primeiro é uma data e o segundo é o dia da semana que eu quero trazer a próxima data. Esta função retorna o próximo dia da semana em comparação a primeira data. SELECT next_day(TO_DATE('01/07/2017', 'DD/MM/YY'), 'SUNDAY') AS prox_sabado, next_day(TO_DATE('29/06/2017', 'DD/MM/YY'), 'SAT') AS prox_quinta FROM dual; SUNDAY - SUN MONDAY - MON TUESDAY - TUE WEDNESDAY- WED THURSDAY - THU FRIDAY - FRI SATURDAY - SAT Veja os outros vídeos da nossa Playlist https://www.youtube.com/watch?v=PjaBYIwXf8c&list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 439 Aprenda PL/SQL
Spiritual 🔮✨ Self-Care Goddess Provisions Box Unboxing 🌙 Crystals, Oracle Cards, etc November 2018
 
11:02
Get your Goddess Provisions box here! : http://caurl.co/r/kr0ey/8l17 Thanks Goddess Provisions 😊 IG - http://instagram.com/goddessprovisions + #goddessprovisions FB - http://fb.com/goddessprovisions Twitter - http://twitter.com/goddessbox + #goddessprovisions Website: goddessprovisions.com Hi Earthlings! 🌏 Thanks for stopping by 🦋 I’m an intuitive Tarot healer. 🔮🎴✨ ⛔️Please remember that if you don’t resonate with this general reading, the message may not be for you. 🌙 Donations to this channel : http://www.paypal.me/earthtoanza (much appreciated!) 🖥 Website : http://www.earthtoanza.com 🍵 Tarot Tea-Shirts (merch) : https://teespring.com/stores/earth-to-anza PopSockets : http://a.co/d/gdsv91d 🎴Tarot & Oracle Cards I Use: http://a.co/jhrM2sT 🐘 Favorite Items : http://a.co/494qQue 💧 Best 100% Therapeutic Oils & Diffuser I use : https://goo.gl/TLHk4Y (I do receive commission when you sign up but so can you :) ) ⭐️ PERSONAL READINGS I OFFER ⭐️ To book a reading, please visit my website at http://www.earthtoanza.com If stated on the website that readings are unavailable, please check back soon! Please book your reading on http://www.earthtoanza.com along with your question and birthday (mm/dd/yyyy). Once payment is confirmed, you will receive your reading from me within 72 hrs from the scheduled time. (72 hours from the date and time you scheduled when booking. Pacific Standard Time) Thank you! ✌️❤️🌟 ** Refunds will only be made if I am unable to do your reading. ** Not responsible for the decisions you make and the outcome. I was provided this box for free but all opinions are my own.
Views: 4274 Earth to Anza
SQL Interview : Display Odd or Even rows in Oracle SQL
 
03:28
5/2=? 2)5(2 --quotient or result 4 ___ 1 -- remainder Mod(5,2)=1 Display ODD or EVEN rows from a table Here I have customers table with customer_id and customer_name Mod() function returns reminder eg Mod(5,2)=1 Mod(4,2)=0 when we pass even number it returns zero when divided by 2 and vice versa select row_number() over (order by customer_id) as row_no from customers this query returns the row number select * from (select ROW_NUMBER() over (order by customer_id) as row_no from customers)s1 where mod(s1.row_no,2)=1 Gives Odd rows Final: ODD rows: select * from (select c.*,ROW_NUMBER() over (order by customer_id) as row_no from customers c)s1 where mod(s1.row_no,2)=1 EVEN rows: select * from (select c.*,ROW_NUMBER() over (order by customer_id) as row_no from customers c)s1 where mod(s1.row_no,2)=0
Views: 251 Data Disc
Valid Month Solution - Web Development
 
02:56
This video is part of an online course, Web Development. Check out the course here: https://www.udacity.com/course/cs253.
Views: 2603 Udacity
Oracle APEX - Tabular form datepicker month and year selector
 
09:38
- Oracle APEX - Tabular form datepicker month and year selector https://abuelenain.blogspot.com.eg/2017/03/oracle-apex-tabular-form-datepicker.html - Change filed to be Text Filed - Add Dynamic action on ADD button set type to be Execute JavaScript code /*ADD ROW*/ javascript:apex.widget.tabular.addRow(); /*ADD DATEPICKER*/ $('input[name="f03"').datepicker({ dateFormat:'yy-mm-dd', yearRange: '1970:2200', changeMonth:true, changeYear:true, showButtonPanel:true, buttonImageOnly:true, showOn:'both', buttonImage:"#IMAGE_PREFIX#asfdcldr.gif" }).parent("td").addClass("datepicker"); Don't Forget to subscribe and share
Views: 1719 Hesham Abu Elenain
ASMR ROLE PLAY🔮 Relaxing Tarot Reading & Crystal Collection (Soft Spoken / Wisper / Shuffling)
 
24:16
I’m a newb at doing ASMR so please forgive me 🙏💖 Just wanted to try it out for fun. lol I was struggling tho lol 😂 Hi Earthlings! 🌏 Thanks for stopping by 🦋 I’m an intuitive Tarot healer. 🔮🎴✨ ⛔️Please remember that if you don’t resonate with this general reading, the message may not be for you. 🌙 Donations to this channel : http://www.paypal.me/earthtoanza (much appreciated!) 🖥 Website : http://www.earthtoanza.com 🍵 Tarot Tea-Shirts (merch) : https://teespring.com/stores/earth-to-anza PopSockets : http://a.co/d/gdsv91d 🎴Tarot & Oracle Cards I Use: http://a.co/jhrM2sT 🐘 Favorite Items : http://a.co/494qQue 💧 Best 100% Therapeutic Oils & Diffuser I use : https://goo.gl/TLHk4Y (I do receive commission when you sign up but so can you :) ) ⭐️ PERSONAL READINGS I OFFER ⭐️ To book a reading, please visit my website at http://www.earthtoanza.com If stated on the website that readings are unavailable, please check back soon! Please book your reading on http://www.earthtoanza.com along with your question and birthday (mm/dd/yyyy). Once payment is confirmed, you will receive your reading from me within 72 hrs from the scheduled time. (72 hours from the date and time you scheduled when booking. Pacific Standard Time) Thank you! ✌️❤️🌟 ** Refunds will only be made if I am unable to do your reading. ** Not responsible for the decisions you make and the outcome.
Views: 3151 Earth to Anza
create digital cock using forms 10g,11g,12c,18c | Ten Minute Code
 
06:30
Below Clode WHEN-NEW-FORM-INSTANCE DECLARE CurrTime TIMER; OneSec CONSTANT NUMBER := 1000; ---1000 ms = 1 sec BEGIN CurrTime := CREATE_TIMER('CURRTIME',OneSec,REPEAT); END; / WHEN-TIMER-EXPIRED DECLARE ExpTimer VARCHAR2(40) := Get_Application_Property(TIMER_NAME); vTime Varchar2(30) := :SYSTEM.CURRENT_DATETIME; BEGIN IF ExpTimer = 'CURRTIME' THEN -- :CONTROL.clock := SUBSTR(vTime, instr(vTime,' ')+1); :CONTROL.clock1 := TO_char(SYSDATE,'HH12');-- HH12 1-11:59:59 -- HR24 1-23:59:59 :CONTROL.clock2 := TO_char(SYSDATE,'MI'); :CONTROL.clock3 := TO_char(SYSDATE,'SS'); :CONTROL.clock4 := TO_char(SYSDATE,'DD/MM/YYYY'); END IF; END;
Views: 147 Together Oracle
WEEKLY PREDICTION 🔮 PICK A CARD ❣️12/17 - 12/23 TAROT FORECAST
 
01:01:31
Hi Earthlings! 🌏 Thanks for stopping by 🦋 I’m an intuitive Tarot healer. 🔮🎴✨ ⛔️Please remember that if you don’t resonate with this general reading, the message may not be for you. 🌙 Donations to this channel : http://www.paypal.me/earthtoanza (much appreciated!) 🖥 Website : http://www.earthtoanza.com 🍵 Tarot Tea-Shirts (merch) : https://teespring.com/stores/earth-to-anza PopSockets : http://a.co/d/gdsv91d 🎴Tarot & Oracle Cards I Use: http://a.co/jhrM2sT 🐘 Favorite Items : http://a.co/494qQue 💧 Best 100% Therapeutic Oils & Diffuser I use : https://goo.gl/TLHk4Y (I do receive commission when you sign up but so can you :) ) ⭐️ PERSONAL READINGS I OFFER ⭐️ To book a reading, please visit my website at http://www.earthtoanza.com If stated on the website that readings are unavailable, please check back soon! Please book your reading on http://www.earthtoanza.com along with your question and birthday (mm/dd/yyyy). Once payment is confirmed, you will receive your reading from me within 72 hrs from the scheduled time. (72 hours from the date and time you scheduled when booking. Pacific Standard Time) Thank you! ✌️❤️🌟 ** Refunds will only be made if I am unable to do your reading. ** Not responsible for the decisions you make and the outcome.
Views: 12057 Earth to Anza
LEO ♌️🔮 June Tarot Reading + Oracle 2018
 
11:37
Hi Earthlings! 🌏 Thanks for stopping by 🦋 I’m an intuitive Tarot healer. 🔮🎴✨ ⛔️Please remember that if you don’t resonate with this general reading, the message may not be for you. 🌙 Donations to this channel : http://www.paypal.me/earthtoanza (much appreciated!) 🖥 Website : http://www.earthtoanza.com 🍵 Tarot Tea T-Shirts : https://teespring.com/stores/earth-to-anza 🎴Tarot & Oracle Cards I Use: http://a.co/jhrM2sT 🐘 Favorite Items : http://a.co/494qQue 💧 Best 100% Therapeutic Oils & Diffuser I use : https://goo.gl/TLHk4Y (I do receive commission when you sign up but so can you :) ) ⭐️ PERSONAL READINGS I OFFER ⭐️ To book a reading, please visit my website at http://www.earthtoanza.com If stated on the website that readings are unavailable, please check back soon! Please book your reading on http://www.earthtoanza.com along with your question and birthday (mm/dd/yyyy). Once payment is confirmed, you will receive your reading from me within 24-72 hrs from the scheduled time. (24-72 hours from the date and time you scheduled when booking. Pacific Standard Time) Thank you! ✌️❤️🌟 ** Refunds will only be made if I am unable to do your reading. ** Not responsible for the decisions you make and the outcome.
Views: 124 Earth to Anza
PICK A CARD 🔮🥳 2019 Love / Money Month to Month Tarot Prediction
 
01:19:42
Hi Earthlings! 🌏 Thanks for stopping by 🦋 I’m an intuitive Tarot healer. 🔮🎴✨ ⛔️Please remember that if you don’t resonate with this general reading, the message may not be for you. 🌙 Donations to this channel : http://www.paypal.me/earthtoanza (much appreciated!) 🖥 Website : http://www.earthtoanza.com 🍵 Tarot Tea-Shirts (merch) : https://teespring.com/stores/earth-to-anza PopSockets : http://a.co/d/gdsv91d 🎴Tarot & Oracle Cards I Use: http://a.co/jhrM2sT 🐘 Favorite Items : http://a.co/494qQue 💧 Best 100% Therapeutic Oils & Diffuser I use : https://goo.gl/TLHk4Y (I do receive commission when you sign up but so can you :) ) ⭐️ PERSONAL READINGS I OFFER ⭐️ To book a reading, please visit my website at http://www.earthtoanza.com If stated on the website that readings are unavailable, please check back soon! Please book your reading on http://www.earthtoanza.com along with your question and birthday (mm/dd/yyyy). Once payment is confirmed, you will receive your reading from me within 72 hrs from the scheduled time. (72 hours from the date and time you scheduled when booking. Pacific Standard Time) Thank you! ✌️❤️🌟 ** Refunds will only be made if I am unable to do your reading. ** Not responsible for the decisions you make and the outcome.
Views: 40304 Earth to Anza
32. SQL Functions - Conversion,TO_CHAR,TO_DATE,NVL & DECODE
 
17:32
TO_CHAR (datetime) converts a datetime datatype to a value of VARCHAR2 datatype in the format specified. TO_DATE functions explained. Date Functions : https://youtu.be/HtYlMRHy4Ak
Views: 1806 ProSchool
Scorpio ♏️🔮 June Tarot Reading + Oracle 2018
 
11:54
Hi Earthlings! 🌏 Thanks for stopping by 🦋 I’m an intuitive Tarot healer. 🔮🎴✨ ⛔️Please remember that if you don’t resonate with this general reading, the message may not be for you. 🌙 Donations to this channel : http://www.paypal.me/earthtoanza (much appreciated!) 🖥 Website : http://www.earthtoanza.com 🍵 Tarot Tea T-Shirts : https://teespring.com/stores/earth-to-anza 🎴Tarot & Oracle Cards I Use: http://a.co/jhrM2sT 🐘 Favorite Items : http://a.co/494qQue 💧 Best 100% Therapeutic Oils & Diffuser I use : https://goo.gl/TLHk4Y (I do receive commission when you sign up but so can you :) ) ⭐️ PERSONAL READINGS I OFFER ⭐️ To book a reading, please visit my website at http://www.earthtoanza.com If stated on the website that readings are unavailable, please check back soon! Please book your reading on http://www.earthtoanza.com along with your question and birthday (mm/dd/yyyy). Once payment is confirmed, you will receive your reading from me within 24-72 hrs from the scheduled time. (24-72 hours from the date and time you scheduled when booking. Pacific Standard Time) Thank you! ✌️❤️🌟 ** Refunds will only be made if I am unable to do your reading. ** Not responsible for the decisions you make and the outcome.
Views: 163 Earth to Anza
Export data from Oracle table to CSV file
 
00:18
Using Withdata OraLoader, no need to program, just a few mouse clicks! http://www.withdata.com/oraloader/ . Download link: http://www.withdata.com/down/OraLoader.exe
Views: 236 Shiji Pan
TAURUS ♉️🔮 June Tarot Reading + Oracle 2018
 
17:07
Hi Earthlings! 🌏 Thanks for stopping by 🦋 I’m an intuitive Tarot healer. 🔮🎴✨ ⛔️Please remember that if you don’t resonate with this general reading, the message may not be for you. 🌙 Donations to this channel : http://www.paypal.me/earthtoanza (much appreciated!) 🖥 Website : http://www.earthtoanza.com 🍵 Tarot Tea T-Shirts : https://teespring.com/stores/earth-to-anza 🎴Tarot & Oracle Cards I Use: http://a.co/jhrM2sT 🐘 Favorite Items : http://a.co/494qQue 💧 Best 100% Therapeutic Oils & Diffuser I use : https://goo.gl/TLHk4Y (I do receive commission when you sign up but so can you :) ) ⭐️ PERSONAL READINGS I OFFER ⭐️ To book a reading, please visit my website at http://www.earthtoanza.com If stated on the website that readings are unavailable, please check back soon! Please book your reading on http://www.earthtoanza.com along with your question and birthday (mm/dd/yyyy). Once payment is confirmed, you will receive your reading from me within 24-72 hrs from the scheduled time. (24-72 hours from the date and time you scheduled when booking. Pacific Standard Time) Thank you! ✌️❤️🌟 ** Refunds will only be made if I am unable to do your reading. ** Not responsible for the decisions you make and the outcome.
Views: 149 Earth to Anza
Leo 🔮💎 Come Thru!! Collect Your Winnings! 👏👏 November 2018 Monthly Forecast
 
11:38
Hi Earthlings! 🌏 Thanks for stopping by 🦋 I’m an intuitive Tarot healer. 🔮🎴✨ ⛔️Please remember that if you don’t resonate with this general reading, the message may not be for you. 🌙 Donations to this channel : http://www.paypal.me/earthtoanza (much appreciated!) 🖥 Website : http://www.earthtoanza.com 🍵 Tarot Tea-Shirts (merch) : https://teespring.com/stores/earth-to-anza PopSockets : http://a.co/d/gdsv91d 🎴Tarot & Oracle Cards I Use: http://a.co/jhrM2sT 🐘 Favorite Items : http://a.co/494qQue 💧 Best 100% Therapeutic Oils & Diffuser I use : https://goo.gl/TLHk4Y (I do receive commission when you sign up but so can you :) ) ⭐️ PERSONAL READINGS I OFFER ⭐️ To book a reading, please visit my website at http://www.earthtoanza.com If stated on the website that readings are unavailable, please check back soon! Please book your reading on http://www.earthtoanza.com along with your question and birthday (mm/dd/yyyy). Once payment is confirmed, you will receive your reading from me within 72 hrs from the scheduled time. (72 hours from the date and time you scheduled when booking. Pacific Standard Time) Thank you! ✌️❤️🌟 ** Refunds will only be made if I am unable to do your reading. ** Not responsible for the decisions you make and the outcome.
Views: 12505 Earth to Anza
Oracle Forms | How To Set Calendar With Jar File & Dynamic Date | Bangla (17 )
 
17:43
Oracle Forms | How To Set Calendar With Jar File & Dynamic Date To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY Dear viewer, In this video you will learn how to set easily CALENDAR at run time in Oracle forms & Show SYSDATE at run time. CODE FOR FUNCTION: FUNCTION custitemevent RETURN date IS hBeanEventDetails ParamList; eventName varchar2(80); paramType number; eventType varchar2(80); newDateVal varchar2(80); newDate date := null; begin hBeanEventDetails := get_parameter_list(:system.custom_item_event_parameters); eventName := :system.custom_item_event; if(eventName = 'DateChange') then get_parameter_attr(hBeanEventDetails, 'DateValue', ParamType, newDateVal); newDate := to_date(newDateVal,'DD.MM.RRRR'); -- else -- MsgBox.show(MsgBox.STOP_ALERT,'Uknown event received - ' || eventName); end if; return newDate; end; CODE FOR TRIGGER: declare newdate date; begin newdate := custitemevent; if (newdate is not null) then :ORDERS.ORDER_DATE:= newdate; end if; end; CODE FOR Implementation Class : oracle.forms.demos.CalendarWidgetWrapper To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 394 OracleDB Solutions
ORACLESQL08 - nls_date_format, union all, union
 
12:07
Kod SQL: http://pastebin.com/3f1gynKi Ustawianie formatu daty. Łączenie wyników zapytań za pomocą union, union all.

Lek nifelat 20 mg cialis
Colchicine lirca 60cpr mg to
Kenalog nombre generico de amoxil
Atorvastatin abz 60 mg
Isoptin 120 mg cenac